Hey everyone!
Currently I face a difficult problem and I would like to hear what you guys think about it:
I have a report which has to be bursted to around 1000 sales people. So I created a burst query which defines my recipients and so on. On one of my report pages I have several crosstabs, each of them references to another query. It is quite easy to filter them using master-detail relationships obviously. But in some crosstabs there are singletons defined inside the crosstab which reference on other queries. In the non-bursted version of the report the filtering is performed using parameters which were configured by prompt page. But I cannot define the parameters when bursting.
Because there are many Singletons in the different crosstabs, I choosed to create a join which sums up the queries of crosstab and singleton. Now I have a lack of performance - because it seems, that the master-detail relationship only applies local - which is quite bad.
Because it is not possible to integrate lists into crosstab I am searching for alternatives.
Thank you very much for your ideas!