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 |
|
Jhixson
Starting Member
4 Posts |
 Posted - 2012-05-18 : 09:15:10
|
| Hello everybody, I am relatively new to SSRS, and i am having a problem when deploying a report that I have made.I am running SQL Server 2008 Enterprise Evaluation.The report is very, very simple, simply querying a single table in a database and generating a tabular report of said data. It is a production report for a Title Company, and I am having issues when i add a 5th column. When I have 4 colums (Customer name, Loan officer, Source, Closing date), the report deploys perfectly, taking only about 2 seconds to compile the report and deploy it to the reporting Services, where it works very well. However, as soon as I add a 5th column, Even a blank column, the report does not deploy. It tries to deploy it for about 2 minuts, then times out.Now, my first reaction might be to try and increase the timeout period, but why in the world would a blank column cause that to happen? I would much rather treat the problem than simply work around it.I know that Timeout issues tend to stem from large data sources. And it is true; the table being queried has about 1500 records in it. I do have parameters in place, however, so that the report only ever pulls 1 specified month at a time. Plus, like I said, it deploys just fine as long as it only has 4 columns.Strange? Please help! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-19 : 15:18:56
|
| when you say adding 5tn column do you mean adding column to report designer or adding to dataset itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Jhixson
Starting Member
4 Posts |
Posted - 2012-05-21 : 08:54:22
|
| Adding a column to the report Designer. With further testing, there have been other reports where dimilar things happen: For instance, I will have a report that deploys just fine, then when I add a group, it times out. I take the group away, and it Deploys fine again. I understand that it is strange, I was just wondering if anybody happens to know if this is some sort of known issue or somethhing. |
|
|
|
|
|
|
|
|
BIDS timeout issue