SQL Reporting 2005 Report Server is not displaying report -- sql server reporting services

code_slayer_bkk
4/21/2006 11:11:01 AM

Ryan:

Really probably not fair for me to say:

BUT - I REALLY BELIEVE THERE ARE SERIOUS BUGS IN THE WHOLE RELEASE OR SQL
2005 WITH REPORTING SERVICES:

I have migrated "perfectly working RS reports from 2000" to the equivalent
Business Intelligence RS 2005 and "THEY DO NOT RENDER OR WORK THE SAME"...

I have performed all of the recommended endeavors with SQL 2005 - but the
results in RS reports are absoutely just a mess !

Perfectly working reports in 2000 - I copy the directory for the 2000
project to 2005 - opened in Visual Studio for RS and then upgraded - and they
do not work the same way as 2000.....

This is really becomming a complete waste of time with 20056 with RS!

Best Regards,

[quoted text, click to view]

William
4/21/2006 11:51:02 AM

Have you checked your data source connection string in production version.
Someone may have altered it in the bad report.

[quoted text, click to view]

Amarnath
4/21/2006 10:55:01 PM

Hi Ryan,
Two things to check.
1. Since it is working in preview your connection string is correct. Check
after deploying; go to the data source page from report manager and see the
connection string is same as that in your VS.
2. Check the "Overwrite Datasource" status ie true/false from project
properties. this is very critical. because you might have changed when
developing in VS and when deploying, if your status is "false" then you dont
get it. In preview it works fine when deployed it wont.

Amarnath.

[quoted text, click to view]

reportdude
4/24/2006 7:40:00 AM

One more thing to check - if you have parameters than check the
parameter settings on the server....these do not get overwritten if you
set them on the server and then subsequently made a change in
designer....very annoying and confusing....

Matt A

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : SQL Reporting 2005 Report Server is not displaying report