I am trying to write report without using HTML composer I want to show ALL option in my parametr. I cant find all option in developer studio. I tried to -DEFUALT = 'FOC_NONE' but its not working out.

Is there a way to bring SELECT ALL option in parameter screen wihtout using HTML composer launchpage?

Arif

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

How many things are wrong with this statement?

-DEFUALT = 'FOC_NONE'

Do you have a select list in your HTML form? If so, add

<option value="FOC_NONE">All</option>

This value is passed to the fex where it can be used in selection criteria

WHERE FRUIT EQ '&FRUIT';

When &FRUIT contains 'FOC_NONE', the line of code is ignored.

I just created this procedure using dev studio.

 DEFINE FILE SPONSORAR_BYPARENT_VIEW
Parentname/A40=SPONSORAR_BYPARENT_VIEW.DIM_PARENT.PARENTFIRSTNAME || ' , ' | SPONSORAR_BYPARENT_VIEW.DIM_PARENT.PARENTLASTNAME;
END

-DEFAULT &DIVISIONNAME = 'FOC_NONE'
-DEFAULT &DISTRICTNAME = 'FOC_NONE'

TABLE FILE SPONSORAR_BYPARENT_VIEW
SUM
     'SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.0TO6/P10.2-'
     'SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.7TO13/P10.2-'
     'SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.14TO20/P10.2-'
     'SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.21TO27/P10.2-'
     'SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.OVER28/P10.2-'
BY HIGHEST 1 'SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.WEEKENDING' NOPRINT
BY 'SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.DIVISIONNAME'
BY 'SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.DISTRICTNAME'
BY 'SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.SCHOOLID'
BY 'SPONSORAR_BYPARENT_VIEW.DIM_PARENT.Parentname'
HEADING
"Learning Care Group AR Report By Parent"
FOOTING
""
WHERE ( SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.DIVISIONNAME EQ &DIVISIONNAME.(AND(FIND DIVISIONNAME,SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.DIVISIONNAME IN sponsorar_byparent_view)).DIVISIONNAME. ) AND ( SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.DISTRICTNAME EQ &DISTRICTNAME.(AND(FIND DISTRICTNAME,SPONSORAR_BYPARENT_VIEW.DIM_SCHOOL.DISTRICTNAME IN sponsorar_byparent_view)).DISTRICTNAME. );
WHERE SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.SCHOOLID EQ '&SCHOOLID.(FIND SCHOOLID,SPONSORAR_BYPARENT_VIEW.FACT_SPONSORAR.SCHOOLID IN sponsorar_byparent_view).SCHOOLID.';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EXPANDABLE ON
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON

So is there a way we can set all option in dev Studio also?

Do you have amper autoprompting turned on or off?

T