MS SQL Reporting Service in Windows 2003 Server

Hi,

I tried to Develop one Report in SQL Reporting Service. I have
installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
Database is in another machine, running on Windows 2000. I developed
and deployed the report and all went fine.

When I tried to see the report through the Report Service Manager Web
Page it is comming properly. But When I tried to See the report in
another web page, I'm not able to see the images. But the Data is
getting Displayed and only Image is not comming. When I exported the
report to Excel, the Image is comming over there.

I am using Report Viewer control (Which came as Sample Program) in
the ASPX Page to render the report. I'm using SQL Server 2000 with SP3a
and SQL Server 2000 reporting Service with SP1.

I tried setting the Mime Time for the GIF image and even "*.*" in
the Mime Type settings of IIS 6.0. Even then its not displaying the
image.

Can any one help me out in solving the problem?

Thanks in Advance.

With Regds
KrishRS sp2 is an option. There have been a lot of fixes, but I can't tell if
this specific one was in it.

Regards
----------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@.epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Krish" <jmkrish@.gmail.com> wrote in message
news:1122361416.772274.179410@.g14g2000cwa.googlegr oups.com...
> Hi,
> I tried to Develop one Report in SQL Reporting Service. I have
> installed SQL Reporting Serivice in Windows 2003 machine. SQL Server
> Database is in another machine, running on Windows 2000. I developed
> and deployed the report and all went fine.
> When I tried to see the report through the Report Service Manager Web
> Page it is comming properly. But When I tried to See the report in
> another web page, I'm not able to see the images. But the Data is
> getting Displayed and only Image is not comming. When I exported the
> report to Excel, the Image is comming over there.
> I am using Report Viewer control (Which came as Sample Program) in
> the ASPX Page to render the report. I'm using SQL Server 2000 with SP3a
> and SQL Server 2000 reporting Service with SP1.
> I tried setting the Mime Time for the GIF image and even "*.*" in
> the Mime Type settings of IIS 6.0. Even then its not displaying the
> image.
> Can any one help me out in solving the problem?
> Thanks in Advance.
> With Regds
> Krish

MS SQL Parts Database

I am a newbie to the world of SQL Server and I am trying to develop a parts database for computer components. I need tables for each component type (mobo, cpu, memory, hard drives etc.) but I also want to show relation between compatible components (i.e. sata harddrives for mobos that support sata as an example) in my queries and stored views so that if a user selected a Motherboard they can recieve a list of compatible components with that Motherboard. So far I have setup tables for each component, each table has a comp_id (where comp is the component type) and I have a comp_type_id table that stores all of the component id's. Each component table's comp_id column is the primary key relating to the comp_type_id table (which has the foreign key. Is this the way to go or am I completly out of the ball park. Any suggestions or guidence will be greatly apprieciated.I'd recomment NOT creating separate tables for each component. That would be a nightmare to maintain.

Instead, create a single table for storing all components and assigne each component a unique ID. Then have a second table for storing compatibilities with two fields as the primary key: Comp_ID and Compatible_Comp_ID.

This is an ambitious project, and your real challenge will be getting people to enter data religiously. You may think you are making the database more powerful by adding functionality, but you may end up making it such a pain to use and update that the data is never reliable. Just a word to the wise: keep it simple!

blindman|||I see what you mean. I will work that idea out on paper. What kind of index would you use on a table that massive? Also, how do I indicate two primary keys for one table.

Thank you for your suggestions|||You are not assigning two primary keys. You can only have one primary key (the clustered index) because this dictates the order that the data is actually stored in SQL server. Other keys (non-clustered indexes) are stored as separate invisible tables that contain pointers to your actual data. This is why they are slightly slower than clustered indexes in queries, and they also take up additional space.

What you need to do is make the clustered index contain both fields. You can do this easily in Enterprise manager's table designer by selecting both fields and then clicking on the KEY icon.

Some people create a single compound keyfield by concatenating the data from both fields into a third field, but I would recommend against this for a lot of reasons.

As far as the kind of index to use, I like UniqueIdentifers, which are GUIDs (Globally unique IDs). They aren't the shortest type of ID, and they are no fun to type in, but they are efficient and ensure that if you ever have to merge data from multiple databases (production, test, backup, etc) you won't have to worry about duplicate data.

Since you are creating a parts database, I doubt you are going to be dealing with millions of rows of data, so the efficiency of the index is not nearly as important as the functionality and clarity of the design.

blindman

MS SQL 2000 Developer Edition.

Hi.
I am looking to install MS SQL 2000 on my laptop. The
purpose of which is to develop GUI and Web applications.
These applications will be installed onto our main servers
which are running MS SQL 7 and/or 2000 (V7s are scheduled
for upgrading and the new development will not be complete
before this upgrade so no need to look at V7).
Am I right in thinking the developer edition of MSSQL2K is
the appropriate product? Does this come with the
complete "manager" program and all the online books like
the full edition?
Are there any other differences between the developer
and "standard" (or whatever this is called).
Any comments, web pages, etc. would be greatly appreciated.
Regards,
Richard Quadling.
P.S. Is there a better place than in the newsgroups to ask
such questions?
Richard,
Yes, that would be the correct product for development work. Developer
Edition is the same as Enterprise Edition, except it is not licensed for
production use. You may want to test your application on a standard edition
server to ensure it will work in production first.
Choosing an Edition of SQL Server 2000
http://www.microsoft.com/sql/techinf...sKChooseEd.asp
How to Buy
http://www.microsoft.com/sql/howtobuy/default.asp
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Richard Quadling" <richard.quadling@.carval.co.uk> wrote in message
news:4c6801c42c30$10f46140$a101280a@.phx.gbl...
> Hi.
> I am looking to install MS SQL 2000 on my laptop. The
> purpose of which is to develop GUI and Web applications.
> These applications will be installed onto our main servers
> which are running MS SQL 7 and/or 2000 (V7s are scheduled
> for upgrading and the new development will not be complete
> before this upgrade so no need to look at V7).
> Am I right in thinking the developer edition of MSSQL2K is
> the appropriate product? Does this come with the
> complete "manager" program and all the online books like
> the full edition?
> Are there any other differences between the developer
> and "standard" (or whatever this is called).
> Any comments, web pages, etc. would be greatly appreciated.
> Regards,
> Richard Quadling.
> P.S. Is there a better place than in the newsgroups to ask
> such questions?
|||Thank you.

MS SQL 2000 Developer Edition.

Hi.
I am looking to install MS SQL 2000 on my laptop. The
purpose of which is to develop GUI and Web applications.
These applications will be installed onto our main servers
which are running MS SQL 7 and/or 2000 (V7s are scheduled
for upgrading and the new development will not be complete
before this upgrade so no need to look at V7).
Am I right in thinking the developer edition of MSSQL2K is
the appropriate product? Does this come with the
complete "manager" program and all the online books like
the full edition?
Are there any other differences between the developer
and "standard" (or whatever this is called).
Any comments, web pages, etc. would be greatly appreciated.
Regards,
Richard Quadling.
P.S. Is there a better place than in the newsgroups to ask
such questions?Richard,
Yes, that would be the correct product for development work. Developer
Edition is the same as Enterprise Edition, except it is not licensed for
production use. You may want to test your application on a standard edition
server to ensure it will work in production first.
Choosing an Edition of SQL Server 2000
http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp
How to Buy
http://www.microsoft.com/sql/howtobuy/default.asp
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Richard Quadling" <richard.quadling@.carval.co.uk> wrote in message
news:4c6801c42c30$10f46140$a101280a@.phx.gbl...
> Hi.
> I am looking to install MS SQL 2000 on my laptop. The
> purpose of which is to develop GUI and Web applications.
> These applications will be installed onto our main servers
> which are running MS SQL 7 and/or 2000 (V7s are scheduled
> for upgrading and the new development will not be complete
> before this upgrade so no need to look at V7).
> Am I right in thinking the developer edition of MSSQL2K is
> the appropriate product? Does this come with the
> complete "manager" program and all the online books like
> the full edition?
> Are there any other differences between the developer
> and "standard" (or whatever this is called).
> Any comments, web pages, etc. would be greatly appreciated.
> Regards,
> Richard Quadling.
> P.S. Is there a better place than in the newsgroups to ask
> such questions?|||Thank you.

MS SQL 2000 Developer Edition.

Hi.
I am looking to install MS SQL 2000 on my laptop. The
purpose of which is to develop GUI and Web applications.
These applications will be installed onto our main servers
which are running MS SQL 7 and/or 2000 (V7s are scheduled
for upgrading and the new development will not be complete
before this upgrade so no need to look at V7).
Am I right in thinking the developer edition of MSSQL2K is
the appropriate product? Does this come with the
complete "manager" program and all the online books like
the full edition?
Are there any other differences between the developer
and "standard" (or whatever this is called).
Any comments, web pages, etc. would be greatly appreciated.
Regards,
Richard Quadling.
P.S. Is there a better place than in the newsgroups to ask
such questions?Richard,
Yes, that would be the correct product for development work. Developer
Edition is the same as Enterprise Edition, except it is not licensed for
production use. You may want to test your application on a standard edition
server to ensure it will work in production first.
Choosing an Edition of SQL Server 2000
http://www.microsoft.com/sql/techin...esKChooseEd.asp
How to Buy
http://www.microsoft.com/sql/howtobuy/default.asp
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Richard Quadling" <richard.quadling@.carval.co.uk> wrote in message
news:4c6801c42c30$10f46140$a101280a@.phx.gbl...
> Hi.
> I am looking to install MS SQL 2000 on my laptop. The
> purpose of which is to develop GUI and Web applications.
> These applications will be installed onto our main servers
> which are running MS SQL 7 and/or 2000 (V7s are scheduled
> for upgrading and the new development will not be complete
> before this upgrade so no need to look at V7).
> Am I right in thinking the developer edition of MSSQL2K is
> the appropriate product? Does this come with the
> complete "manager" program and all the online books like
> the full edition?
> Are there any other differences between the developer
> and "standard" (or whatever this is called).
> Any comments, web pages, etc. would be greatly appreciated.
> Regards,
> Richard Quadling.
> P.S. Is there a better place than in the newsgroups to ask
> such questions?|||Thank you.