Question
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****
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.