Question
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***
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
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.
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