Question

7
Replies
1342
Views
AnilSadineni Member since 2016 2 posts
Incessant Technologies Pvt Ltd
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed

Problem while adding counts returned by sub reports

Hi All,

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.

Thanks in advance.

***Moderator Edit: Vidyaranjan | Updated Categories***

Reporting
Moderation Team has archived post
Share this page LinkedIn