Hello guys,
I've been looking for a solution to this all day and didn't come to a solution.
I have built one report that has multiple subreports that are based on queries over multiple tables and all the subreports and queries share one common ID of a Person which I intend to filter. So I open the main Report via a Button and set a Filter on the main Report to show only his data and not everyone else's.
I put the subreports into the detail section and the data are shown multiple times which I do not intend. What is the logic behind that? The subreport is showing up as many times as there are recordsets in the query that is tied to the subreport?
I've been also looking here for similar problems but didn't quite find the solution.
I came across the idea, to group the report but I think in my case, it won't help since the subreports are kind of necessary in my opinion because I cannot do ONE single query for this ONE report because there are too many connections and too many tables so that one query returns no data back, hence grouping the report wouldnt help. So this solution has been kind of recommended many times but I do not think that this may work because as I said, the stuff is way too stretched over more than just 3 tables so that I could simply do one query and put this as a recordsource for the main report. I'm not really sure about this.
I also thought about just putting the subreports into the side headers but the thing is, the side headers appear on every page and that's exactly not what I intend haha!
Also, I'm not sure whether Linking (Master - Child) will help here...
Any other ideas?
The reports (subreports) on their own work quite well, it's just that they do not work when I embed them as supreports into this main report.
The thing is, every subreport needs to be filtered so that only the data of one selected person shows up. The Person's ID is the common ground of all the subreports which I intend to use to filter.
I also thought about automating the creation of each of the subreports on their own and then concatenate them (somehow) automatically but this seems to be a really dirty workaround.
I also thought about just putting all the sub reports into the (first) report header of the main report into which all subreports are embedded but this also seems kinda too dirty as a workaround since I actually need this report header indeed because it's an official document.
I'm kind of frustrated rn and I feel really burnt and I'd be really glad for help.
If there's additional information you need, please ask and I'll ofc answer it.
Thank you in advance for reading, I reallly appreciate this forum and all you helpful guys, you are doing a tremendous work with your help, I really mean it!
Greetings,
FinisherProgrammer21