SSRS details control


  • 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:07 PM


All replies