I have a report (Report A). When it runs, it ask a question which selects
what report to run. This works fine.
I have another report (Report B). When it runs, it doens't ask questions by
design and returns all "inventory". There is a table in Report B that
references Report A.
I need to run Report A, inputing what report I want to run... (ex. 200).
From there, on print, need to run Report B with the selection variables from
Report A(ex. 200) if there were matching records.
So, Report A would print #200's information. If there were "inventory"
items that referenced #200, it would print the Inventory information included
in Report B.
Do I use Macros? If so, what do I build it on? Do I have to use custom code?
Thank you in advance!