Hi Guru's,
Been struggling with this the past couple of days. I have a rpt w/ drill-down rpt. The calling report passes several needed variables to this called report:

-DEFAULT &BeginDisDate = '2009-01-01 00:00:00'
-DEFAULT &EndDisDate = '2009-12-31 23:59:00'
TABLE FILE ...
PRINT
...
WHERE IntervenID EQ '&IntervenID';
WHERE QueryID EQ '&QueryID';
WHERE DischargeDateTime GE DT(&BeginDisDate);
WHERE DischargeDateTime LE DT(&EndDisDate);
WHERE QryResp EQ &QryResp.(OR(FIND Name IN GrpRespFields WHERE GrpRespID EQ '&GrpRespID')).QryResp.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT TABT
END

The calling report passes these variables:
&InterenID
&QueryID
&GrpRespID

so when the report above gets called, it throws up auto-prompting allowing adjustment of the dates, but more importantly I needs to produce a dynamic multi-select list based on which GrpRespID is passed to the called report.

The above called report doesn't work because the WHERE clause is not allowed with the FIND stmt.

Next, my thought was to populate a HOLD file first with the selections for the drop-down and code the WHERE stmt as follows:
WHERE QryResp EQ &QryResp.(OR(FIND Name IN GRPHOLD)).QryResp.;

My problem is getting the HOLD file populated before the auto-prompting happens

I went so far as to setting up a called report so it populates the HOLD file in dialog manager, then uses the -INCLUDE to call the real called report, but even in this scenario, it throws up the autoprompting for the -INCLUDE rpt before it processes the HOLD file.

I'm stumped now.

The drill-down in the calling report at the detail, row level. I'm thinking maybe you could build the HOLD file in the calling report first??? but you'd have to reassess the HOLD file for each row because it could change from row to row.

sorry for the length of this post, but wanted you to know where I'm at with it.

Any suggestions?
THANKS, Mark

Oh, I should mention I'm doing this stuff in Managed Reporting..

thx/Mark

Here is a recent post with a similar theme:
http://forums.informationbuild...71057331/m/491102472
Most of us are not fond of using the auto-prompt screen for a 'production' report. It is better to use the HTML Layout Painter to create the page and also prompt for everything you need before running the parent report if you can do that.

Cool, thanks Ginny.

I read that post yesterday

I'm with you and want to give this a try.

But I need some guidance on how to code it to retrieve a dynamic list. The example is hard coding a country list.

Can you give me an example of making that section dynamic?

THANKS

WHERE ( COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY IN CAR)).COUNTRY. )

Is this what you are looking for?

looking for this actually:
WHERE ( COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY IN CAR WHERE CONTINENT EQ &CONT)).COUNTRY. )

I need that where stmt in the FIND and the amper variable &CONT would get passed in from the calling rpt.
but i don't think you can have where's in the FIND stmt.