Drill-Through in Report Author 10.2.1 and Establishing Parameter

[gosoccer]

This is probably simple for many people but,

I have two Reports and need to establish drill down between the master and detail reports.

The reports are based on a query established in Framework Manager to obtain the data for the
last 30 days. I have created both reports from the same exact subject query (from FM) same Query in Report Author.

Now, how do you create parameters in Report Author so when you are creating the
drill down definition, it will show up as a part of the  :)parameters passed?

Thx in advance for your time.

[MFGF]

This is probably simple for many people but,

I have two Reports and need to establish drill down between the master and detail reports.

The reports are based on a query established in Framework Manager to obtain the data for the
last 30 days. I have created both reports from the same exact subject query (from FM) same Query in Report Author.

Now, how do you create parameters  in Report Author so when you are creating the
drill down definition, it will show up as a part of the  :)parameters passed?

Thx in advance for your time.

Hi,

You haven't made it clear if the master and the detail are separate reports? I'm assuming so.

In the detail report you need to add detail filters (or dimensional expressions) that include parameters - ie ?somedesiredname?

If you are using a relational package then the detail filter would be something like

[query item] = ?param?

And if you are using a dimensional package your query calculation would be something like

[level of hierarchy] -> ?param?

If you then run this report standalone, the report prompts for the parameter values, but if you define the report as a drill through target you can pass values from the source to fulfil the parameters.

Cheers!

MF.


Sent from my iPad using Tapatalk HD

[gosoccer]

 :)yes. this answered my question. It is good that it doesn't ask for the prompt.
Thx again.