Question
Virtusa PVT Ltd
IN
Last activity: 8 Dec 2017 4:09 EST
Dynamic Report Definition
I want to create Report Definition rule Dynamically so that I can create more generic report definition that is appropriate to take assignment data as input and query the database based on the user input by creating a report definition dynamically instead of pre assuming the inputs and the results . Is it possible to create a rule dynamically in pega?
Pegasystems Inc.
IN
Hi,
If the target class that your report belongs to is same always, then you can use the pyReportParamPage parameter to configure the query inputs dynamically.
I hope the below links will give more context this:
https://community.pega.com/sites/default/files/help_v731/procomhelpmain.htm
https://collaborate.pega.com/question/dynamic-query-logic-report-definition-v7
You can also look at the activity pxRetrieveReportData which takes pyReportPageName as a parameter. Through this parameter, we can pass the name of a page of type Rule-Obj-Report-Definition containing full information of the report that we want to run. In this case, we don't even need a physical RD present in the system.
Thanks,
Santhosh
Pegasystems Inc.
IN
Hi Gopi,
I think for you requirement you may not need Report at all.
RDB methods would be a better option and even OBJ browse if it applies.
You may be able to create a rule using pxCreateRecord activity but you may not be able to configure it dynamically.
Purpose of Reports is to query and show results in a known structured way.
Regards,
Ujjwal