Question
Virtusa
LK
Last activity: 16 Oct 2018 12:03 EDT
How to call a report definition in an activity and set a value which is getting by the report definition
Hi,
I created a report definition and get the count of a property Then I created an activity and I need to get that count value into a separate property called "ExactCount" using that activity Is this possible to do?How can I do this? Do I need to call a separate activity in that activity?
Thanks
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
Pegasystems Inc.
IN
Siemens
IN
Hi,
Report can be called in the activity using the method" call Rule-Obj-Report-Definition.pxRetrieveReportData" and the details of the report can be passed in the step parameters.
The report will not be run on UI, but its values will be stored in a temporary page that you have to create or pyReportContentPage by default. You can probably perform a sum operation or function on the values and store the result in a new property.
Hope that helps.
Regards,
Faizan.
Accepted Solution
Pegasystems Inc.
IN
Hi Shashi,
I created a sample usecase that will help you further.
Please find attached the document with screenshots.
When you call the pxRetrieveReportData, all the report data will get stored in pyReportContentPage.
You can then use a property-set method to set required value from pyReportContentPage to the property ExactCount.
In my example, I setrthe grand total value to my custom value ExactCount.
Hope this helps!
Thanks,
Gisela
Virtusa
LK
Thank you very much Gisela. This is totally worked according to my scenario.
CR Asia
IN
Hello Shashi,
I am having a parameter for report definition. that parameter acts as a filter for it. When calling in that activity how could I refer the parameter for it.
Thanks in advance
UHG
US
Set the parameters to pass in property-set above and select pass current parameter page check box when calling RD activity.
Virtusa
LK
Hello Sameer,
If you are calling the activity as a button click event, you can select run activity in the action set. There you can give the parameters if there any parameters in that activity.
CR Asia
IN
Thank you it worked for me
Noida Institute of Engineering & Technology
IN
I also want to filter report so i can get only one row
Hi Shashi,
I created a sample usecase that will help you further.
Please find attached the document with screenshots.
When you call the pxRetrieveReportData, all the report data will get stored in pyReportContentPage.
You can then use a property-set method to set required value from pyReportContentPage to the property ExactCount.
In my example, I setrthe grand total value to my custom value ExactCount.
Hope this helps!
Thanks,
Gisela