I am curious to know if creating an interactive report using webfocus is possible. What I mean by interactive is this:

I create a typical report with ¶meters using Developer Studio (7.11) (in the managed reporting section). But what I would like to do is create the report in such a way that instead of just prompting the user for the parameter, that the user could just turn the paramater On/Off based on whether they need that ¶meter as criteria for that report.

Is this possible and if so, where could i look to find the information on how to incorporate the interactiveness?

I wonder if adding the 'ALL' option to your parameter would allow to do what you want. Do you use a list or just have them type in what they want?

If a list would work I would use a list, but some would have to be entered.

The idea is that we have many different scholarships...and they all have different criteria. So I would like to make a report that encompasses most of the criteria so that one report would be all that I need to create for a bulk of the reports.

I empathize, you would have to do some behind the scenes branching possibly, I'm still learning all the ins and outs of developer studio myself and we only do to MRE standard reports area here. My suggestion would be to get the most common criteria into one with alterations for the exceptions. Hopefully some of the experts out there will have an example.

Do you mean something like this


TABLE FILE CAR
PRINT *
-IF &INP1 = ALL THEN GOTO CONT1;
WHERE COUNTRY EQ '&INP1'
-CONT1
BY COUNTRY NOPRINT
ON TABLE PCHOLD FORMAT EXL2K
END
-EXIT

That sounds interesting...but what does ALL mean, in the statment:

-IF &INP1 = ALL THEN GOTO CONT1;

It means that I want to evaluate all countries (none are excluded).

1)
-DEFAULT &MYCOUNTRY = 'ALL';
-SET &FILTERCNTRY=IF &MYCOUNTRY EQ 'ALL' THEN ' ' ELSE 'IF COUNTRY IS ' | &MYCOUNTRY ;
(you'll have to do some more work if you want to enclose your parm value in single quotes)
...'IF COUNTRY IS ''' | &MYCOUNTRY | ''' ' ;
then
TABLE FILE CAR
PRINT *
&FILTERCNTRY
END
...cant hurt to stick a .EVAL after it, although i don't seem to need it.
...i find this easier than keeping track of lots of branching.
..or
2.)
-DEFAULT &MYCOUNTRY = '$*';
then IF COUNTRY IS &MYCOUNTRY
seems to work, unless of course your parm size is A1
..or
3.)
-DEFAULT &MYCOUNTRY = 'FOCNONE' ;
is the more modern way to do it, but moi, je suis dinosaur so i use #1; works for me.
So in my drop down lists on my launch page:

<select name="MYCOUNTRY" .... >
<option selected value="ALL">select a country, if you wish</option>
<option...zillions of others>
</select>

any help?

This message has been edited. Last edited by: susannah,

Thanks Susannah.

At first glance I am sure it will help, but won't know more until I dive into this report. It does seem a little confusing to me, but I am sure once I break it down based on my criteria it will all come together.