Question

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.

Correct Answer
July 24, 2017 - 3:07am

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

Comments

Keep up to date on this post and subscribe to comments

July 24, 2017 - 3:19am

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.

Pega
July 24, 2017 - 3:07am

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

July 26, 2017 - 2:54am
Response to rodrg

Thank you very much Gisela. This is totally worked according to my scenario. 

January 19, 2018 - 12:33am
Response to rodrg

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

January 19, 2018 - 4:33am
Response to SameerDeepakD

Set the parameters to pass in property-set above and select pass current parameter page check box when calling RD activity.

January 19, 2018 - 5:35am
Response to SameerDeepakD

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.

January 22, 2018 - 7:04am
Response to ShashiprabhaR

Thank you it worked for me

July 3, 2018 - 3:15pm
Response to rodrg

I also want to filter report so i can get only one row