Question
Last activity: 11 Dec 2017 1:54 EST
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


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
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://pdn.pega.com/how-create-custom-sql-functions-reporting and this is what Nikhil has mentioned.
Regards,
Ujjwal
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
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
I am looking for something similar to below.
https://pdn.pega.com/how-create-custom-sql-functions-reporting
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