Hi all,
I am trying to do drill through from a summary report to a detail report .
Detail report had 3 mandatory prompt ( date , channel and method ).
in summary report i have date prompt and method query item .But, i don't have channel query item in the report.
drill through is done on a ID column.
In drill through definition i can pass the date parameter and method data item value.
How can i pass the value for channel prompt to the detail report from the drill through?
Does this summary report cover one specific channel? Try creating a text box prompt at the top of the page. Set the default to the channel you want, and then set the box type of the prompt to none. Now you can pass the parameter associated with that prompt to the target report.