Hi All

I am using Resourse Layout Painter . I have created a report in that and it takes a parameter REGION and the values are
All, midwest,northeast,West

if i am selecting All total report should display
and
heading as
REGION : ALL(THIS SHOULD DYNAMICALY CHANGE AS THE REPORT CHANGES)

In the report heading i have parameters value as

Heading
Region : <REGION

If i am selecting Midwest in the parameter dropdown it shows

Region : Midwest

Know I am selecting ALL Option in parameter
and the heading should be

Region : ALL

But the report is also not displayed and heading too

So for adding ALL in Heading what should i do

Thanks in Advance

I'm guessing your gui is passing the string 'ALL' when it should be passing a wildcard character like '%'. To get '%' to display as 'ALL' you will need to create a COMPUTEd field with will translate '%' into 'ALL'.

You will need something like this:
COMPUTE DISPLAY/A20 = DECODE REGION('%' 'ALL' ELSE REGION);

Hi CurtisA

NO its not working
thanks for reply

I want the parameter value for ALL so i can display it in the heading

If you're selecting MIDWEST, then the where clause:

WHERE REGION EQ 'MIDWEST'

will work great.

I'm assuming of course that you're doing a where clause in this manner.

To do the 'all' logic, unless the REGION column contains the value 'ALL' then you will not see any data.

Here's just one suggestion:

-SET &HEADLINE = IF ®ION EQ 'ALL' THEN 'REGION: ALL' ELSE 'REGION : <REGION' ;

TABLE FILE ...
HEADING
"&HEADLINE.EVAL"
...
-IF ®ION EQ 'ALL' THEN GOTO SKIP ;
WHERE REGION EQ '®ION' ;
-SKIP
END

Does this help?

Ken

The posting didn't come out too well. The parameter for 'amper region' is incorrect. Use this instead:

-SET &HEADLINE = IF &XREGION EQ 'ALL' THEN 'REGION: ALL' ELSE 'REGION : <REGION' ;

TABLE FILE ...
HEADING
"&HEADLINE.EVAL"
...
-IF &XREGION EQ 'ALL' THEN GOTO SKIP ;
WHERE REGION EQ '&XREGION' ;
-SKIP
END

Ken

Hi k.lane

Thanks its working