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.