Skip to Content
0
Former Member
Aug 10, 2016 at 01:20 PM

Subreport linking question

28 Views

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.