Reports :: To get Sum of Grand Child Table Txns

SenthilD · 06-28-2020 04:54 AM

Good Evening All,

I have 3 tables, DivisionalOffice -> Resellers -> CampaignTxn. End of every month, a report need to be generated on

Each Division wise
a. how many resellers participated in a campaign (based on CampaignTxn data ) in a division
b. How many campaign on each division.

The campaignTxn has all transactions and has link to resellers table using resellerID

Based on the Ive setup a report format, still is not giving me the expected result. Attached below the report template format/Report sample.

Thanks,
Senthil

Steve

In the Total no of QLOCs column of the template, try this expression:

<<COUNT([Related tblResellers][Related tblCustomerQLOCs])>>

SenthilD

Thank for your quick input @Steve, as always. I tried and it didn’t work. As of now, added virtual column tblResellers to have campaign count.

The error message is
Expression ‘COUNT([Related tblResellers][RelatedtblCustomerQLOCs])’ is invalid due to: Unable to find column ‘RelatedtblCustomerQLOCs’

Thanks,
Senthil

Steve

I’ve adjusted my suggested above. Please try the revised expression.

SenthilD

Thank you @Steve, let me check again.

Regards,
Senthil