Hi,
I have two queries that I would like to show in one single report. I did so by using a subreport. I get the info I want to in the report, but I would like to change the presentation.
I would like to select some info of the subreport and show it under the line plan (empty cells highlighted in yellow) if it matches the criteria in the main report (surrounded in red). Eg. Bananas Green January in the main should show the first line in the subreport. Does anyone have some ideas on how I could achieve this?
Thanks,
Susy
I have two queries that I would like to show in one single report. I did so by using a subreport. I get the info I want to in the report, but I would like to change the presentation.
I would like to select some info of the subreport and show it under the line plan (empty cells highlighted in yellow) if it matches the criteria in the main report (surrounded in red). Eg. Bananas Green January in the main should show the first line in the subreport. Does anyone have some ideas on how I could achieve this?
Thanks,
Susy