How to classify the value in report definition?
Hi,
I have requirement in Report. Need to display If the Value is 0 to 25 =LOW, 25 to 50 =MEDIUM, 50 to 100=HIGH. Can anyone help men on this.
***Edited by Moderator Marissa to update categories***
Pegasystems Inc.
IN
Hi Gouri,
You can create a declare expression for that property with whenever used and the assign the values High, Low etc using Decision table with required business logic.
Thanks,
Ujjwal
de Volksbank
NL
HI, The requirement is for reports, i have to show it in report..
Pegasystems Inc.
IN
Hi Gouri,
You can do it still with Declare expression where you just change the value and show it on report at runtime.
Thanks,
Ujjwal
ANZ
IN
Hi Ujjwal,
Thanks for the above. I think it would be a performance issue if we call a declare exp for each record,and that will call decision table.
I am looking for something which we can handle through functions which are available in reports.
Regards
Gouri Shankar K
Pegasystems Inc.
IN
Hi Gauri,
I have seen working example declare expression approach in production, however if you have very huge data then yes there could be performance impact.
I guess you have already seen https://docs.pega.com/how-create-custom-sql-functions-reporting and this is what Nikhil has mentioned.
Regards,
Ujjwal
ANZ
IN
Hi Ujjwal,
Yes i have seen following article https://pdn.pega.com/how-create-custom-sql-functions-reporting and used the nested functions. It worked..
Thanks for your inputs.
Regards
Gouri Shankar k
Verizon Data Services
IN
Hi Gouri,
You can create a function alias passing your value as a parameter , write the logic in the function and return the value accordingly.
de Volksbank
NL
Hi, Can you please eloborate..
Accepted Solution
ANZ
IN
I am looking for something similar to below.
https://docs.pega.com/how-create-custom-sql-functions-reporting