Wednesday, April 11, 2012 6:07 PM
I have a report which has millions of detail rows which taking longer time to execute. Summary level report has thousands of rows which run quickly.
I want create a report such that when report is initially run it just count or sum summary level data only using SQL query. I don't need to get details initially. But when user hit toggle button for particular summary, only associated details should be displayed by query.
Is this possible to run query, based on toggle button to show details .
Wednesday, April 11, 2012 6:25 PM
I think this is not possible , but you can achive this by drill through report
go to this link
Hope this will help you !!!
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Wednesday, April 18, 2012 2:46 AM
Wednesday, April 11, 2012 10:51 PM
Hi Kevin - Sanjeewan is correct. It will not likely be useful or performant to display (or even have) millions of detail rows for the average human user. Instead, start with a report that just has the summary data calculated by SQL Server, and then use the "Go to report" action in a text box of your detail row to call another report that is filtered to the detail data for the summary row.
I hope this helps - Dean
This posting is provided "AS IS" with no warranties, and confers no rights.