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, The requirement is for reports, i have to show it in report..
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.
Hi, Can you please eloborate..
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