Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2004-12-20 : 14:50:00
|
| I have this db which has a ton of rows...locally it takes about 1-2 minutes to run the entire report...As soon as I deploy the report it sits there for a while trying to generate the report and then gives me a login screen asking for a user name and password (not sure why since this login does not appear locally NOR does it appear when I deploy this and shrink the report by selecting parameters).If I select a parameter for the report (say a job number) to return maybe 10 rows the report runs fine. But if I dont select a parameter and run the entire report it tries to generate than it asks for a user name and password...which it really shouldnt since i already set the credentials in reporting services to a user which has rights to the db and the procedure I am using to run the report.If I type in a user name and password it takes down report server entirely, and the only way to get it back up and running is to restart IIS.I even set the timeout property on "default web site" to 480 seconds (that's 8 minutes!!), and still nothing.What do I need to do to handle this ???Jon |
|
|
jhermiz
3564 Posts |
Posted - 2004-12-20 : 15:28:53
|
| I think its cause the report is too large...so I want to run the report with a default...but IM having a problem doing so. The report tries opening up with nothing for a job number and runs all the records...even if I specify a default for the parameter..it doesnt really allow me to select a job. It just says "Select From Query" and gives me the field names...I dont want to run the report unless the end user clicks the VIEW REPORT button. Meaning it should open empty. Is this possible. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-20 : 15:30:48
|
| Yes this is possible, you just have to make sure you didn't specify defaults for your parameters.Tara |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-12-20 : 15:33:04
|
quote:
Originally posted by tduggan
Yes this is possible, you just have to make sure you didn't specify defaults for your parameters.Tara
How I have 3 parameters that I now specify with NO defaults (2 are dates and one is a string)...Still runs the entire report. |
|
|
|
|
|
|
problem