Property with Declare Expression Not Displaying Values in Report Definition

General
1

In Pega Constellation I am facing an issue with a property that is populated using a Declare Expression.

  • The property belongs to the same class as the Report Definition.
  • The property is optimized for reporting.
  • The calculated value is visible in the UI.
  • The value is present on the clipboard.
  • The corresponding database column contains the correct value, and I can verify it through a database query.
  • However, when I add this property as a column in a Report Definition, the report displays a blank value for that column.

Other properties in the same class are displayed correctly in the report. The issue occurs only for the property populated through the Declare Expression.

Has anyone encountered a similar issue? Are there any additional configurations, report settings, or known limitations related to reporting on properties populated via Declare Expressions that I should check?

2

Hi @VemulapudiB17750633 ,

Yes, you can’t see those that are used in the Declare Expression. Try using a Function Alias it will work.

Thanks,

Ashok

3

I tried this as per your suggestion, but my Column has Decimal values, so it is rounding to next integer value.

Let say if my Column has 1.5 then it is setting 2

Function I am using here is “[Decimal Value] converted to a Decimal value”

4

@Bhumireddy : In DB itself it is storing Rounded Number instead of Decimal Values ( For 1.5 it is storing 2 ) Hence it is giving 2 in report.

Above suggested approach is working it seems but Problem with stored values

5

@VemulapudiB17750633

Please check Scale of the respective column, If it not there scale value try to update scale value

Thanks,
Ashok