My FOCEXEC runs just fine using a .mas as the data source for a multi-select parameter list box. WHen I try to put it in Report Caster, to select the 5 Funds, the Advance Task Options screen 1. does not come up very fast and doesn't paint/show very well, and 2. seems to hang.

There are 737 rows in the table.

As I type this the screen kind of came back. The parameter properties shows, 'No Selection' and then a few rows of '00', seems like a lot of rows.

Can Report Caster not handle a parameter based on a MFD? The doc says it can.

I want one report that can run in Report Caster for a select group of Funds and also be an Ad Hoc for the users to select them at run time.

Any help or ideas are appreciated.

Thanks,

This message has been edited. Last edited by: Rick Man,

.mas is not your data source, it is your master file definition (a discription of your data). Are you scheduling Report Caster or launching it from your parameter screen? If you aree scheduling it, you have to click on the Advanced button (on the task) and enter your parameters.

Correct the data source isn't the .mas.
When I click the advance button in Report Caster it 'hangs', like it is trying to load all the fund codes, which it should, so that I can select the 5 I want.

It does not load any parameter values when clicking on the Advanced button. It will simply provide a text box where you can type in the parameter values you wish to use. ReportCaster does not provide ANY of the functionality provided by a launch page, like parm value lookups, chaining, ALL, etc. Additionally, it sounds like you are wanting to do a multi-select on fund code. Be aware that multi-select functionality also is NOT provided the same way. You would have to manually feed the values into each of the indexed parameter slots (&parm0, &parm1,&parm2,&parm3,&parm4,&parm5) or possibly make some tricky use of an OR string of parms.

As to why it seems to "hang", I can't really say, but it's not because it's trying to load any values - there's nothing to load values into in RC.

One other thing, (that may not apply) in the version we are on (716) you must have the "prompt for parameters" property on the fex turned on in order for the "Advanced" button to work properly when clicked in RC. Don't know if that has changed for your version.

Are you trying to load your parameter screen into Report Caster or the fex that loads your drop downs boxes? That won't work. You need to hard code the parameters for your report program. If you have the prompt for parameters set on and it is still hanging up check your program for -TYPE, -EXIT or ECHO. Comment it out while you create your parameters. You can uncomment those lines once you have your report caster job set up.

Rick,

I guess that you have something along the lines of -
WHERE column_name EQ &Variable.(OR(FIND column_name IN table_name))
in the code that you are pointing to within RC?

I set up a similar one with a select that would pull out around 4000 rows. When I went in to RC advance to select the values, RC returned them in pretty good time, in fact quicker than amper autoprompting did when run manually.

Version of RC that is in use here? 7.6.2

T

Exactly, on the WHERE. But my repotr caster won't bring up the list. We are on 7.6.2

Here are links to the screen prints.

RC Screen Print
http://tinypic.com/view.php?pic=2mp9y11&s=3

MRE Auto Prompt
http://tinypic.com/view.php?pic=aylxyw&s=3

Rick,

The source table I used was Oracle, it shouldn't make a difference.

How fast is it when you run using amper autopromt? If it is decidedly slow then try and improve the efficiency of the FIND by extracting a file overnight just containing the values on which you wish to select.

For instance, if you have a table of 6 million rows with 1000 distinct values of the field in which you are interested, run an extract overnight to pick up the latest distinct values and hold it in a file so that when your WHERE clause is evaluated, it doesn't have to read through 6,000,000 rows, only 1000.

T

There are only 723 rows, one per fund, in the table.
Here is the WHERE clause:

WHERE RPRAWRD.RPRAWRD.RPRAWRD_FUND_CODE EQ &RPRAWRD_FUND_CODE.(OR(FIND RFRBASE.RFRBASE.RFRBASE_FUND_CODE IN rfrbase))

quote:

How fast is it when you run using amper autoprompt?

T

A count of one thousand 6. It is even faster using the html created in painter, a count of one thousand 3

I opened a case, 42032554 , with IBI and we finally figured it out. The GUI uses qualified field names in the FIND command and Report Caster can not handle that. If you set up this code in Report Caster and switch the WHEREs you will see the difference. The first WHERE will not work.

TABLE FILE CAR
PRINT CAR MODEL BODYTYPE
BY COUNTRY
WHERE COUNTRY EQ &CNTY.(OR(FIND CAR.COUNTRY IN CAR)).COUNTRY.;
-*WHERE COUNTRY EQ &CNTY.(OR(FIND COUNTRY IN CAR)).COUNTRY.;
END