Users may have nested prompts in a Report Services document and wish to pass the prompt answers to another document, which has the same nested prompts. This technical note describes how to handle this situation.
PREMISE:
STEPS:
1. Create a report named R1 that has the Item attribute and Cost metric. Place the nested prompts into the report filter.
2. Create a report named R2 that has the Item attribute and Profit and Revenue metrics. Place the same nested prompt as R1 into the report filter.
3. Create a dashboard named D2. Place the R2 report as a grid and a text message to easily recognize that this is the destination document as follows:

4. Create a dashboard named D1. Place the R1 report as a grid and a hyperlink to the D2 document as shown below:

5. As for the hyperlink definition, set as follows

Sample Code/Error
Main.aspx?&src=Main.aspx.2048001&evt=2048001&documentID=’document ID of D2’&reportViewMode=1& originMessageID={&DOCUMENTMESSAGEID}
6. After answering all the prompts in D1, click the hyperlink and all the elements are passed to D2 as follows
