I am trying to use TITLE as the Parameter to get the dropdown box at the top of the Report.
WHERE TITLE EQ '&TITLE.(,).TITLE.';

But I am getting an error &TITLE not Found.

Please help me.

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

quote:

WHERE TITLE EQ '&TITLE.(,).TITLE.';

Please check out the use of -DEFAULT (for &TITLE) before you go any further... Post your code, sample code using an IB file (like CAR), as well

TABLE FILE COMPPLAN
SUM
TITLE
MAX.PLAN_TYPEC AS 'PLAN_TYPE'
MAX.PLAN_COMPONENT AS 'PLAN_COMPONENT'
MAX.PLAN_KEYC AS 'PLAN_KEY'
MAX.BASE_OBJ AS 'BASE_OBJ'
MAX.EFF_YM
MAX.VARP01
MAX.VARP02
MAX.VARP03
MAX.VARP11
MAX.VARP12
MAX.VARP13
MAX.VARP14
BY TITLE NOPRINT
BY PLAN_TYPEC NOPRINT
BY PLAN_COMPONENT NOPRINT
BY PLAN_KEYC NOPRINT
IF PLAN_TYPEC EQ 'TN$$' OR 'T5$$' OR 'CN$$' OR 'PB$$' OR 'PR$$' OR 'TQ$$'
IF PLAN_COMPONENT CONTAINS 'NSR' OR 'PROD' OR 'PRD' OR 'RETN'
WHERE TITLE EQ '&TITLE.(FIND TITLE IN COMPPLAN).TITLE.';
END

This is the command I am trying to execute.

This example leaves too much work and guesswork for us to do (imho), like what's in the COMPPLAN file and what's the format of that / those fileds in the COMPPLAN file, so that we can help you arrive at a solution.

Please provide an example using a common IB file, such as the CAR File.

PS: Wrap your code in the [ code ] and [ /code ] (without the associated spaces within the brackets).

TABLE FILE CAR
SUM
TITLE
STATE
WHERE TITLE EQ '&TITLE.(FIND TITLE IN CAR).TITLE.';
END

I am trying to use TITLE as Dynamic Parameter in Webfocus.

There are two ways to accomplish this kind of automatic prompting.
The first is to create your own htm file to ask for the params and have the dropdown lists populate automatically. The other way is to activate autoprompt. From the description of your entry I conclude that you do not have autoprompt enabled.

-SET &ECHO='ALL';
-*SET &T='';
TABLE FILE CAR
PRINT
CAR
COUNTRY
WHERE CAR EQ '&T.(FIND CAR IN CAR).CAR.';
END 

This way It works... I enabled autoprompt... It fetchced me the right output with List of CARS.

Where do I do that in WebFocus?

Where do I set the AutoPrompt??

1) Ask you admin which setting is being used for autoprompting (I'm not sure that autopromopting will be an accetapbe production solution ~ imho).

2) Are you using "-DEFAULT" with your variables?