Bursting a report with multiple parameters for a combination of prompt values

[danielwinston]

Hi All,

I have a report that has 13 prompts which can either be 'All' or have a value. Now the burst table in the database yields different results for different combinations of these 13 prompt values.The prompt values are statically defined to be either All or value. And the parameters of these prompts are altered in such a way if it is 'All'then 'All' else the value of the data item(fetched from DB).

Now the existing procedure is that there are more than 900 report views and these views are scheduled to run for a combination of values of these 13 prompts.
For Example, Prompt 1 has a 'value', Prompt 2 - 'All', Prompt 3 has a 'value'.... prompt 12 - 'All' and prompt 13 has a 'value'.
Hence the report view is named 'Report View P1P3...P13'.

These views are called by more than 20 Jobs and each Job is inturn called by another Master Job.

If new prompts are added to the report, all the views must be changed in order to accommodate the new prompt and a value has to be provided for each. We are looking to work out a method by which report can be burst without the help of these 900+ views since the number would keep on increasing.

Is there a way to schedule the reports with the help of the burst key in the burst table?

Thanks in advance.