Question
Virtusa
IN
Last activity: 13 Dec 2016 19:39 EST
How to Generate row number in Report definition?
How to Generate row number in Report definition?
***Moderator Edit: Vidyaranjan| Updated Categories***
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Pegasystems Inc.
US
Hi,
Can you call OOTB function @(Pega-RULES:Utilities).LengthOfPageList to get the number?
Blue Rose Technologies GmbH
BE
Hi,
Please have a look on the below article :
https://collaborate.pega.com/discussion/row-number-report-definition
Let me know if it helps.
Pegasystems
IN
Couple of ways
- Write a custom SQL function which can use a database function to get the row number and use it in the select fields of the report definition
- Use the RANK option in report definition. The output page will have a pzRank property populated with the row number (though it is not displayed in the report viewer)
Virtusa
IN
Hi Nistr,
Can you please give me brief idea where i can get the Rank option in Report definition.We are using pega 7.2.1version.
Pegasystems
IN
Please take a look at this help topic - https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm
At the very end you will find the section Top / Bottom Rank and how to use that feature in report definition.
Capgemini
IN
The easy way would be creating a control to get the step page index and show it in the RD.
you can use getStepPage to get the step page then do string manipulation to get the integer subscript of the page list.
refer any property in the RD and in the control step add that control. Note the property you refer has nothing to do with the row id. Row id would be created on the browser by the control itself.
Thanks,
Saikat
IKOR
AU
Hi Anjan,
Could you be more specific about your requirement?
How exactly,the report definition is being showcased ?
If the report is being embedded in Repeat Tree grid, then with OOB option, row number can be enabled. If the report definition is executed as stand alone, then use the following approach
1)Introduce new custom control that outputs the page list subscript
span><%=tools.getActive().getParentProperty().indexOf()%></span>
2)Add a new column to the report definition (should be first column) and assign it to any property you want
3)Change the column to be formatted with new control
Cheers,
Naren