Drill through on Calculated column

[sunita.dudi]

Hi All,
I have a requirement to have a cross tab report which has calculated nodes in it and a drill through child report which will have account as input parameter.
For example
Parent report
Type A is calculated field
Type A  definition is :
CASE When ACCOUNT_ID in (1,2,3)
and Product in ('A','B') THEN
                                                Amount
END

   Type A
India   200
US   100

When I click on Type A child report should open with details of passed account_id's i.e.  account id 1,2,3 should be passed as parameters
Account ID   Amount
1   10
2   20
3   10

help will be deeply appreciated

[MFGF]

Hi,

Drill-through doesn't work quite this way, unfortunately. Your best bet is to add another calculated item to the query of your source report with the same CASE expression, but setting a flag instead of an amount. Include this in the properties of the row edge in the source report, then pass this as a single parameter value. In your target report, filter the data based on this flag value.

Cheers!

MF.