I have a report and a subreport.
That report is based ona table and has a filter coming from a multiselect listbox.
tis report is grouped by; Brand, LPGCode. The detail includes the field Account.
The subreport source is a query that essentially rolls up the records on the table in the main report and converts them to a dollar value, however, this query is a summary so only needs to show it by Brand and account.
I.e. the subreport is grouped by Brand only and has Account in the detail. (The subreport is in the Brand footer or main report - to show total value for each account for that brand).
The issue I have is that if I link by brand only all accounts and their values are listed, (but some accounts are not in main report due to filter from multi-select listbox).
If I link by Brand and by Account i get only the last account in each brand not all accounts on the main report.
Is there another way to link these reports? Can I pass the filter from trhe main report to the subreport therby allowing me to link by brand only?
That report is based ona table and has a filter coming from a multiselect listbox.
tis report is grouped by; Brand, LPGCode. The detail includes the field Account.
The subreport source is a query that essentially rolls up the records on the table in the main report and converts them to a dollar value, however, this query is a summary so only needs to show it by Brand and account.
I.e. the subreport is grouped by Brand only and has Account in the detail. (The subreport is in the Brand footer or main report - to show total value for each account for that brand).
The issue I have is that if I link by brand only all accounts and their values are listed, (but some accounts are not in main report due to filter from multi-select listbox).
If I link by Brand and by Account i get only the last account in each brand not all accounts on the main report.
Is there another way to link these reports? Can I pass the filter from trhe main report to the subreport therby allowing me to link by brand only?