Passing Parameters or Values between a Main and a Drill-Throu Report

[gosoccer]

Hi,
Using Report Author 10.2.1,

I have a unique values that needs to be passed between the master to the detail prompt report.
The problem is that this unique value is not a prompt values to be shown to the user to select.

Is there anyway to pass the value of this unique value from the master to the detailed report using parameters, or any other way?

Could you please help. I'm stuck in this last issue.

Thx so much!! :( :(

[MFGF]

Hi,
Using Report Author 10.2.1,

I have a unique values that needs to be passed between the master to the detail prompt report.
The problem is that this unique value is not a prompt values to be shown to the user to select.

Is there anyway to pass the value of this unique value from the master to the detailed report using parameters, or any other way?

Could you please help. I'm stuck in this last issue.

Thx so much!! :( :(

Hi,

Basically you have to cheat. Add a prompt to the report page of your source report, specify a default value for the prompt (the unique value you want to pass) then hide the prompt. Change the underlying filter for the prompt to be ?parameter? = ?parameter? so that nothing in the source report gets filtered by the prompt.
In your drill-through definition you can then pass this parameter as a parameter value.

Cheers!

MF.

[gosoccer]

Hi there.  :)

Thanks so much. I'm still trying to get this working. So, here is what I have done.
Keeping in mind this parameter is not entered by the user and the values needs to be passed
from the report's Query Values that is displayed as a part of the body of the report, I have done
the following:

Added UNIQUE_CAR_ID_PARAM to the Source Report's Prompt Page.
Added the ?UNIQUE_CAR_ID_PARAM?= ?UNIQUE_CAR_ID_PARAM? to the filter of the Source Report.
Added the UNIQUE_CAR_ID_PARAM as a part of the Drill Thru definition. Used the following to define
the Drill-Thru:

NAME:
UNIQUE_CAR_ID_PARAM
TYPE: NUMBER
Multi-Select
Checked
Method:
pass data item value
Value:
UNIQUE_CAR_ID
Property to pass:
Business Key

After running the report and selecting the Drill-Thru, the values passed form the Drill-thru, it blank for the UNIQUE_CAR_ID_PARAM.

I changed the Method: from pass data item value to pass parameter value but same result, the TARGET Report value passed shows blank. The Drill-thu report works without asking for prompts but only one of the values selected by the user is establishing the filtration. The UNIQUE_CAR_ID is not filtering anything as a part of the Target Report.

Thx for your time. 8)

[gosoccer]

I figured it out. Thank you so much. You solution worked!!!!  ???