Good Evening All,
I have 3 tables, DivisionalOffice -> Resellers -> CampaignTxn. End of every month, a report need to be generated on
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
In the Total no of QLOCs column of the template, try this expression:
<<COUNT([Related tblResellers][Related tblCustomerQLOCs])>>
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
Iโve adjusted my suggested above. Please try the revised expression.
Thank you @Steve, let me check again.
Regards,
Senthil
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |