none
Report Requirement

    Question

  • Hi Friends,

                    In my company as part of report requirement,they have given a requirement like below

    Requirement: "The system shall allow pre-generated reports to be designed so that they can be rendered online in under 5 seconds, i.e., very large reports shall be broken into pages that allow incremental drill down and navigation and so do not adversely affect the network.”"

    I'm having trouble understanding above, Is that he meant to have a scheduled report which will run for every 5 seconds? And We need to come up with a strategy where we should display few records at a time and have some navigation or drill down approach to see the further data/records. Looking confirmation from professionals to make sure my understanding is correct. 

    Thanks.



    • Edited by Murali dhar Monday, February 03, 2014 9:49 PM
    Monday, February 03, 2014 7:37 PM

Answers

  • I read it as the report should render/display data within 5 seconds.  Meaning, when i click the view report button, it should only take 5 seconds before i see data.  They then go on to say that they want to use pagination to render the report quickly to screen.  That is to say have the data be queried, but i only wan to see a certain number of records on the page, then go to the next page to get the next set of data.  Don't try and display all the data at a time.

    The best thing you could do in this instance, is go back to the customer and get clarification... "did you mean this...".  The worst thing you could do is make assumptions about what somebody wants only to under deliver.

    • Proposed as answer by JJordheim Tuesday, February 04, 2014 4:35 PM
    • Marked as answer by Murali dhar Tuesday, February 04, 2014 6:59 PM
    Monday, February 03, 2014 8:36 PM
  • Hi Murali,

    If I understand correctly, the requirement is not to display all report data in one page to improve the report running performance. We can use drillthrough to work around the issue.

    In SSRS, a drillthrough report is a report that a user opens by clicking a link within another report. The data in the drillthrough report is not retrieved until the user clicks the link in the main report that opens the drillthrough report. There is an article about SSRS Drillthrough Reports, you can refer to it.
    http://msdn.microsoft.com/en-us/library/ff519554.aspx

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Proposed as answer by JJordheim Tuesday, February 04, 2014 4:36 PM
    • Marked as answer by Murali dhar Tuesday, February 04, 2014 6:59 PM
    Tuesday, February 04, 2014 10:01 AM

All replies

  • I read it as the report should render/display data within 5 seconds.  Meaning, when i click the view report button, it should only take 5 seconds before i see data.  They then go on to say that they want to use pagination to render the report quickly to screen.  That is to say have the data be queried, but i only wan to see a certain number of records on the page, then go to the next page to get the next set of data.  Don't try and display all the data at a time.

    The best thing you could do in this instance, is go back to the customer and get clarification... "did you mean this...".  The worst thing you could do is make assumptions about what somebody wants only to under deliver.

    • Proposed as answer by JJordheim Tuesday, February 04, 2014 4:35 PM
    • Marked as answer by Murali dhar Tuesday, February 04, 2014 6:59 PM
    Monday, February 03, 2014 8:36 PM
  • thank you sir. If it is correct can we inculcate in our report like this .. only few records in a page. 

    Thanks.

    Monday, February 03, 2014 8:39 PM
  • Not my area of expertise, but I think with some searching you'll find the answer, here are some links i found with a quick search.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f0b4ab3f-0058-47dd-b6ff-259b70a932f4/how-to-do-a-performance-tuning-of-ssrs-reports-

    http://msdn.microsoft.com/en-us/library/dd255278.aspx

    http://technet.microsoft.com/en-us/library/ms156282%28v=sql.90%29.aspx

    • Proposed as answer by JJordheim Tuesday, February 04, 2014 4:35 PM
    Monday, February 03, 2014 8:50 PM
  • Hi Murali,

    If I understand correctly, the requirement is not to display all report data in one page to improve the report running performance. We can use drillthrough to work around the issue.

    In SSRS, a drillthrough report is a report that a user opens by clicking a link within another report. The data in the drillthrough report is not retrieved until the user clicks the link in the main report that opens the drillthrough report. There is an article about SSRS Drillthrough Reports, you can refer to it.
    http://msdn.microsoft.com/en-us/library/ff519554.aspx

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Proposed as answer by JJordheim Tuesday, February 04, 2014 4:36 PM
    • Marked as answer by Murali dhar Tuesday, February 04, 2014 6:59 PM
    Tuesday, February 04, 2014 10:01 AM
  • Thank you sir for your time and response. 
    Tuesday, February 04, 2014 2:48 PM