Post reply

Paging in Reporting Services 2000

  • January 6, 2006 at 8:39 am

    #170471

    The data in the report make contain many thousands of rows. In this case the reporting services displays the data in one long page by providing a scroll bar to the users. It obviously difficult to browse and navigate the data on the page using such interface. The users would like to break the report on pages and fit into the page exactly that many row as many fit to the screen having the row count appear in the begging of each row.
     
    How to control the row number count that will be displayed on the page, break it on pages and make it dynamic based on the amount data returned?
     
    Thanks,


    A.V.R

  • January 9, 2006 at 1:28 am

    #613465

    What object(s) have you put on your design page to create the report, ... table, matrix?  Also, if there are so many records to display, have you instigated any data filtering within the report to restrict the number of pages being displayed to the use?

    Ian

  • January 19, 2006 at 11:40 am

    #615886

    It is table and just a 4-5 pages.

    Thanks,


    A.V.R

  • January 24, 2006 at 5:52 am

    #616626

    In report properties, layout tab, what is the page hight you have given? if you reduce it then the records will be displayed in different pages

    Sen

  • January 24, 2006 at 7:00 am

    #616649

    I think this is more a case of the purpose and use of the report needs to be revisited and maybe the selection criteria adjusted to provide a smaller list of records that is not difficult to browse and navigate.

    Eg: Provide a short summary report that allows users to drill-down into detail as required.

    We had general ledger report that contained in excess of 30,000 rows every time the report was run. This caused no end of hassles because users where frustrated with having to scroll up and down the page all the time.

    To fix this we provided a summary report be General Ledger category which equated to 20-30 rows. From each of these categories the user was able to drill down to a summary by General Ledger Codes (15-20 rows) within that category and then drill down a further level to the detail rows for each General Ledger Code (100's).

     

    --------------------
    Colt 45 - the original point and click interface

  • February 5, 2006 at 7:09 pm

    #618886

    THANKS


    A.V.R

  • August 28, 2008 at 8:43 am

    #864460

    Good Day Ruzha, while you have to remove the scroll bar to have paging, i have to do exactly the opposite. I need to disable the paging, show the reporting in one page with a enormou scroll bar.

    how did you do that?

    Igor Reis

  • August 28, 2008 at 10:27 am

    #864557

    Please post in the appropriate forum. the names are at the top.

    Moved to Report Development.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply