June 1, 2010 at 5:51 am
Hi,
I have a report which keeps on showing the progress bar, saying "Report is generated" but it does not get completed at all.
But when i run the same query in the SSMS it returns the result in 3 seconds. I am joining two views in the query and they have around 9,000 and 4,000 rows respectively. Can you please let me know, how i can fix these problem?
June 1, 2010 at 6:19 am
1. Try running the report with fewer rows by using TOP.
2. Check if the data retrieval or processing is taking time (can be found in report execution log table in report server database)
--Ramesh
June 1, 2010 at 8:37 am
I tried using top but it is still not working.Anyways Ramesh i created two tables and imported the data from view to tables and the report is now working fine. Can you please help me by telling me how to truncate a table using a stored procedure?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply