I'm trying to write a report that pulls from Lawson tables for all locations for a group of items and their usage.
I have the main report pulling from the usage table and a subreport to show all location regardless of usage. I need my subreport to only show the locations that do not have any usage - right now it causes redundancy in the report if there is usage at the location as it shows in the base report.
How do I link a subreport to show the locations without spend (basically the locations that do not exist in the base report)?
I have them linked based on an excel spreadsheet I've mapped to list the items in particular that I want to view.