Post reply

Adding Row count to a report with Parameters

  • September 13, 2011 at 4:50 am

    #390391

    Hi,

    I am trying to add a row count to a report with the ultimate aim of breaking the page after 65,000 rows in order to export to excel.

    However when using the Rowcount function the rows that are returns do not increment in by 1 they are random.

    6

    7

    12

    14

    etc. I suspect this is because the final report has parameters that the user can select, (i.e Card type = 1 or 3) and the Rowcount is ignoring this filter?

  • September 13, 2011 at 8:11 am

    #1380671

    There are 2 suggestions:

    1) Use RowNumber function instead

    2) Check function scope.

    Probably it can help.

  • September 13, 2011 at 8:38 am

    #1380710

    Neither work unfortunately.

  • September 13, 2011 at 8:45 am

    #1380719

    david.adlington (9/13/2011)

    Neither work unfortunately.

    In the sql server add ROW_NUMBER() / 65000

    Then add a group with new page on that new field.

Viewing 4 posts - 1 through 3 (of 3 total)

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