ROW COUNT PER PAGE

[crpaculan]

Hello All,

Is there a way to have a row count listed per page ?

EG:


Name ID Address
=======================================
Anna 001 Wellington
Gina 002 Wellington
Ken 003 Wellington
Sofia 004 Wellington

========================================
Records: 4 Page 1 of 2


Name ID Address
=======================================
Allan 009 Wellington
Jenny A02 Wellington

========================================
Records: 2 Page 2 of 2


Thank you.

 

[griffindm]

Try using the running-total function on a calculated column placed in the page footer.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[crpaculan]

Hello,

Thank you so much Mr Griffin for helping.

I tried the running-total function you suggested, I got the result I want in the initial page, but the succeeding page gives the running balance of rows in page 1 + rows page 2, and so on in suceeding pages.

What I need is the actual count of records per page.

I really appreciate your help on the matter.

Thank you.

Cristina.

 

[griffindm]

Sorry Cristina. I don't think there is a way to do just the rows per page rather than a running total. Impromptu has no built in functionality for this, and the page breaks are not part of the grouping that would be required to roll your own function for it.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com