Hi,
I have a report that has one subreport. It runs ok, but needs fixing.
The Main report gets my Inventory, and the Subreport gets my Orders. They are linked (also grouped) by Item# and Warehouse key.
The Problem I am facing is that, I want the report to pull all Orders, and all Inventory whether there is a corresponding match for it or not. Presently, I only have a corresponding Inventory vs. Order.
How do I get all Orders against that non-existent inventory to be listed. I also need that "zero" inventory to show as well.
( My Main Report prints on GF2 (detail line suppressed) My Subreport is inserted on GF2. I pass 4 parameters to main report. )
Your assistance will be greatly appreciated.
I have a report that has one subreport. It runs ok, but needs fixing.
The Main report gets my Inventory, and the Subreport gets my Orders. They are linked (also grouped) by Item# and Warehouse key.
The Problem I am facing is that, I want the report to pull all Orders, and all Inventory whether there is a corresponding match for it or not. Presently, I only have a corresponding Inventory vs. Order.
How do I get all Orders against that non-existent inventory to be listed. I also need that "zero" inventory to show as well.
( My Main Report prints on GF2 (detail line suppressed) My Subreport is inserted on GF2. I pass 4 parameters to main report. )
Your assistance will be greatly appreciated.