Hello good people,
currently im workin on a redesign of a report i created some years ago. In short words, the Reports is a collection of several prompted reports.
Example based on the IBM Demo Database: imagine there is a crosstab with Produtline in the rows, a measure and e.g. Sales Methode on the columns.
price | EMAIL | FAX | TELEFONE
Productline 1 |
Productline 2 |
The prompt asks for a region. So in the stand-alone report i can choose on region and get the crosstab filtered. In the Report-Collection i have several Reports of this same kind, but for each region filtered. Right now, i dont like the design because the data im quering from the database for each of this pages witht his report are quite similar, but only the slicer /detailfilter is filtering the different regions.
So my approach is to use a Masterquery and several Subquery-References and filter each of them. The idea is, to get one query against the db and use this big data pot for each single report, but to add a individuel region-filter.
BUT: im getting errors ("RSV-SRV-0040 internal error")...
Does anybody has some experience with similar requierments? I was thinkin about page sets/ master-detail-reports, but i would prefere a query.reference-solution if possible.
However, every hint is welcome. Thank you guys and have a nice day :P