Row Count - Auditor Request

Prudence K

Content

Hi all - is it possible to add a row count to our reports, so we know how many rows are expected in the final output?  If I am understanding the tool correctly, the Data Model allows us to build the SQL and then we use the Report builder to create the final output.  We have reports that may have more than 200 rows, but we can only preview 200 rows in the build of the DM.

Our auditors are asking us for copies of the front end and the back end of the reports/DMs to ensure they align.  This is easy for reports where I can use the parameters to get them small enough (EX: 4 rows) but does not work as well for reports that have 19K rows on output.

Any suggestions of how to do this or how you may have completed this for auditors previously?

Thank you!

Raghavan p-Oracle

Hi,

IN RTF template add below and see if it works. (Replace the Person_ID with the actual column name)

<?count(PERSON_ID)?>

Regards,

Raghavan

 

Prudence K

Thank you for this!  Is there any way to do this within the DM though?  I understand how to create another report to show this information, but they want the data on the back-end to prove that what the DM is running is what should be on the report itself.