If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill Through

Started by Vineet, 11 Mar 2021 03:07:34 PM

Previous topic - Next topic

Vineet

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

MFGF

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.
Meep!