Then if I make a change to the report, like a format to the numbers, or simply close Visual Studio and open it again it starts going really slow. What makes this really weird is that sometimes it will generate quickly. That did not help, it still takes forever to generate the report. When that took forever to generate, I changed the sp to perform the summations. My initial sp returned all the rows and I let SSRS sum them and hid the detail. I don't have any groups on the report, although I would like to add one for stock versus non-stock purchases with sums for each. There is one column of text and the other four are all decimal. When I create a SSRS report using the sp it takes over ten minutes to generate the report. All processing is done at the server - case statements and sums. I have a stored procedure (sp) that returns six to ten rows of data with ten columns, displaying five of them in the report.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |