Quote from: Vineet on 11 Mar 2021 03:07:34 PM
Hello All
I have data in this format in Crosstab .
B1 B2 B3
A A1 2 3 4
A A2 5 7 6
I want to create drill through to a list report which (through 2,3,4 numbers) but pass a static where clause to the list report. so each of these number will pass a different where clause when clicked
Thank you in advance
Hi,
A drill-through can pass a value for use in a parameter in the target report. You mention passing a Where clause, which is a SQL construct - do you mean you want to filter the target report based on the value the drill-through passes into the parameter?
A couple of questions.
1. Do you want to filter the target report based on the actual value(s) you passed?
2. Are there any detail or summary filters currently defined in your target report? If so, do they have parameters in their expressions?
Assuming you want to filter on the values you pass (eg the values on the crosstab edges), you first need to add the relevant filters to your target report
[Item used as major row edge value] = ?Major_Row_Parameter?
[Item used as minor row edge value] = ?Minor_Row_Parameter?
[Item used as column edge value] = ?Column_Parameter?
If you then run the target report standalone, you would get prompts generated to fulfill these parameters.
When you define your drill-through from the source report you can then pass values from the source report to these parameters as part of the drill-though definition, so whatever intersection you drill through from, the row/column values will be used to filter your target report.
Is this what you need?
Cheers!
MF.