Posted: 24 Jul 2017 1:42 EDT Last activity: 3 Aug 2017 5:29 EDT
Problem while adding counts returned by sub reports
I have two sub reports both are returning counts using aggregate function 'Count'. I need to add these two count values in main report and tried it using pxAdd function alias in main report, at compile time there is no issue but at run time encountered the below issue.
"An error occured on generating the query for the report definition - null"
Please help me with your suggestions.
Is it possible to add the counts returned by sub reports in the main report definition.? The reason for asking this question is I don't see any issue if I add normal integer values using pxAdd funciton alias, facing issue while adding counts from sub report.