Forum Discussion

StepanGurov's avatar
StepanGurov
Qrew Cadet
7 years ago

number of rows displayed per page in table report

For some reason I can't find any details for how to change number of rows displayed per page for particular table report (and if it even possible).

What makes me more wondering - different reports for the same table may display different numbers of rows: 50, or 100, or 200.
reports and charts
Tables and fields

5 Replies

  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    7 years ago
    Hi Stepan,

    There is one option which you can use to display more rows. Generally, Quick Base displays 200 rows by default.

    You can add &qrppg=50 or &qrppg=500 based on your need at the end of the report URL.

    This solution is good if you are referencing a report through a link on the homepage or linking a report on a button.

    Thanks,
    Gaurav


  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I don't think that you can control this. It's a function of the amount of data displayed on a page, so a skinny report with few columns will display more rows than a wide report with many columns.
  • BretlynHickman's avatar
    BretlynHickman
    Qrew Member
    4 months ago

    Has this been updated? I am hoping to display more than 20 records per page as I am working with a large data set

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 months ago
      1. Did you try removing columns?  That will likely give you more records.

      2. Try switching to the V3 report type.  You can add a suffix of 

        &usev3=1 to force a single report to be in the new Grid Style ("v3") Reports.  You would need to give your users a button to click.  The New Grid reports have infinate scrolling, so only 1 page for even a million records.  That suffix is an undocumented and unsupported hack, but that is what the Quickbase developers are using for their own testing purposes, so good chance it will stay alive.

      3. Take the plunge into the V3 Grid report stype for your whole app.

       

      So an answer to your question they did address that but in typical Quickbase fashion they often address these various enhancement requests when they move onto their next technology architecture and they don't go back and fix for example Old Forms or older report styles when they've launched new forms and the new grid report styles. They put their development effort into the new technology platforms not the old ones, once the news ones are out in the wild.