Bursting the report by using a prompt report

[bensah]

Hi,

I have one report with 3 prompts and it is working fine.

Is it possible to use the prompt report for my bursting ?

Thanks,
Benu

[Lynn]

It is indeed possible to burst reports that contain prompts. I think your question is too vague to offer much more.

[bensah]

Thank you for your reply.

My requirement is as below.

Filter Level:- DIS or MKT etc
Level number:- District number if the above filter is DIS .market number if the above filter is MKT. This field will change everymonth.
Report Level:- 500 or 510 or 530 etc
Category:- Braches,Cluster,total

I have created the report and after providing the above prompt value it is working fine.

My bursting Query have 4 columns corresponding to each prompts.

What I have done:-

In the burst option, i have selected burst query and in the group added Filter Level,Level number,report level and category value from the burst query. Burst recipient is my report Query. In the parameter below my burst query I have mapped column names.

while bursting I am not getting any output.

Please let me know if you need any information. I need to do it urgently.
Appreciate your help.

Thanks,
Benu