Question
Virtusa Corporation
IN
Last activity: 24 Sep 2021 2:05 EDT
Unable to use Clipboard Page in Report Definition
The Pega help page for report definition usage says that we can use Clipboard page in the Filter conditions. But when I tried the same by referring a system page in the Filter criteria column source, I got error as shown in the attachment. Posting this question to know whether this is the expected behavior.
Maantic Inc.
IN
It will work in the "Value" column not in "Column source". In "Column source", you might want to pass the actual column name of the table associated with the applies to class of the report definition.
Virtusa Corporation
IN
@Tanay Kumar Bal Thanks for the response. My requirement is like, based on the accessgroup of the user, need to pass different value in the Filter column value. So I suppose there is not other way other than circumstancing.
Pegasystems Inc.
IN
@GanapathyG You can use the Datapage in the report filters, inside Datapage you can use Data transform as source to calculate the value based on access group, and use Datapage.value in the Report definition filters.
Virtusa Corporation
IN
@pavan3753 Thanks Pavan. Seems that will work. I will try and update. But is there a way to reuse the same D_Page in another Report definition to fulfill same kind of requirement but different value? For example, in the data transform used to source Data page, do you think is there a way to set values based on the Report definition? Like this, When RD = ABC,
set value = Test1 Otherwise When RD = XYZ
set vaue = Test2
and so on.
Pegasystems Inc.
IN
@GanapathyG Will passing RD name as a parameter to the Data page work in your scenario? So that when you refer Data page in RD, you can pass the respective RD name.
Virtusa Corporation
IN
@pavan3753 I tried like this in the filter condition in RD, but did not work and I don't see any error in tracer also. D_DataPage[Param.Test].FilterValues where FilterValues is a value list.
Virtusa Corporation
IN
It seems we cannot use Parameterized Data pages in RD as per the link below. Use Data Page with Parameter in Report Defenition | Collaboration Center (pega.com)
Updated: 23 Sep 2021 14:37 EDT
Pegasystems Inc.
IN
@GanapathyG Yes, got it. RD is not accepting parameterized data page in the filter. And Sorry, I was referring to use the Data page in the value of filter condition, not in the column source, read the question in the other way around. In your case, circumstancing would be the better option I think.
Virtusa Corporation
IN
@pavan3753 Thanks for your suggestion. And I tried referring the Data page in column filter only. If we should only use non parameterized Data page, then I suppose we need to create a Data page and a Data transform for every RD having that requirement. So I thought to parameterize and pass RD name and based on that, conditionally set the values in the source Data transform. But anyway like you said, Circumstancing is the only easy option I could see.