Passing values between reports using Report Author 10.2.1

[gosoccer]

Folks,

I'm trying to identify the simplest way to pass a constant value i.e. 'A' from
a parent report to a Drill Down Report. If someone knows a quick and smart way
of performing this trick, please let me know at your convenience.

I'm familiar with the Drill Down Parameters and passing it to the child report but need
some hints if you could.

Thx so much!!
:D

[CognosPaul]

Create a value prompt in the header of your source report. Set the parameter name to "A". Give it a static value, use: "A" display: "The letter A". Set the default value to "A". Set the box type to none. Now in your drill through definition simply select the "A" parameter in the dropdown. By using this method Cognos will correctly pass the use and display values.

[gosoccer]

Thank you Paul! I'll try it and return with good news hopefully!!

[gosoccer]

OK,well. The value prompt is created as a Drop Down List. I gave it the Static Value (A) and the Default Selection A.
Something tells me I'm not taking the right path on this?
Thx,

[CognosPaul]

That's fine. By setting the default value in the prompt, you're explicitly assigning a value to the parameter. Just set the box type on the prompt to none, then use that parameter in your drillthrough definition.

[bi4u2]

gosoccer - if you are trying to pass this into a drill through, you can create the static value 'A' in a data item that you might call 'Drill Parameter', then on your drill through definition select to send the data item value to the parameter. You do not have to create a prompt to send it as a parameter value.

[gosoccer]

Well,

I'm trying to use the Data Item Approach. My Query as a part of the Target (Child Report) has the following,
[BUSINESS_VIEW].[SHA_QUERY].[RPT_ORG_ID] in (?Parameter1?)

My Drill Down Def is attached.

[gosoccer]

Here is the attachment.
Thank you for your time.

[bi4u2]

It looks good so far, under 'property to pass' can you leave it as 'default'?

Also, on the parent report on the List Properties you might want to add a check mark next to the dummy data item of the Properties under Data. This is when you have to reference a data item in the query but not in the layout.

[gosoccer]

OK,
changed 'property to pass' as 'default'?

My apologies but the parent report is OLAP (Dimensional H.) and the Target Report is "Relational"

If I run the Target report by itself, I get the attached prompt caused by the Query,

[BUSINESS_VIEW].[SHA_QUERY].[RPT_ORG_ID] in (?Parameter1?)

I don't get it, shouldn't the prompt's title be Paramter1 and not RPT_ORG_ID?

See attached prompt raised snapshot.

Thx again

[gosoccer]

I hardcoded the following in the Query Filter of the Target Report and the Target Report works just fine without prompt,

[BUSINESS_VIEW].[SHH_QUERY].[RPT_ORG_ID] = 'A'

I'm hitting out (Eastern Time) but please let me know if you have any suggestion and I'll
try it tonight!!

Thx a lot!!!