Author Topic: Bursting Master-Detail Crosstabs with Singletons?  (Read 88 times)

Offline cognosonthefly

  • Associate
  • **
  • Join Date: Feb 2018
  • Posts: 3
  • Forum Citizenship: +0/-0
Bursting Master-Detail Crosstabs with Singletons?
« on: 15 Feb 2018 09:34:12 am »
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!