Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sebastian Hadinata (SebastianH4229)
Accenture
SG
SebastianH4229 Member since 2018 8 posts
Posted: Sep 21, 2018
Last activity: Sep 21, 2018
Posted: 21 Sep 2018 5:34 EDT
Last activity: 21 Sep 2018 10:17 EDT
Closed

Serial Number in Report Definition

Hi,

I would like to check if anyone knows how to add serial number as a column in report definition. I am running this report definition by using report widget for manager portal and hence, will not have the option to tick the "display row number" option found in repeating grid. The only way for me to achieve this without customising the OOTB section will be to include it somehow in the report definition.

Any idea how to achieve this?

***Edited by Moderator Marissa to update platform capability tags****

To see attachments, please log in.
Low-Code App Development
Reporting

Posted: 6 years ago
Posted: 21 Sep 2018 8:06 EDT
Chandru Ramalingam (ChandruR)
Victorian Managed Insurance Authority
Lead System Architect
Victorian Managed Insurance Authority
AU

Hi Sebastian,

Try adding a SQL function in any one of the column sources in RD, SQL function can be coded using rownum (assume its an Oracle backend) or any similar function to return the row number. This would generate a row number as a column as per your need.
Hope this may fit for your scenario.
 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice