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