Forum Community:

I searched the forum quite a bit, and I found some great help; however, I must be missing a step.

My challenge is to create an html file with an unbound parameter called Report Type. Based on user selection, it will populate the report frame with one of three procedures such as New Sales, Used Sales and Service Appointments.

Each fex has the exact same parameters.

Each fex has three sections of code. A DM statement directs WF to a certain section of code based on another parameter which groups Stores like this: All Stores Summary, All Stores Listing and Store x.

So far:

Within the html file, I created an unbound parameter, renamed it Report Type, bound it to a control (changed the control to a dropdown list) and then used the procedures as value names in the settings, changing the fex names to the shorter names of New Sales, Used Sales and Service Appointments instead of the longer procedural names.

My parameters are all chained and look like this:

Report Type - Store Name - Years - Output type

I found some help about setting the tasks to Selection Changed and adding the fex names to the tasks as requests. I tried that, but I did not have much luck. It's almost as if I need a DEFAULT parameter of some kind inside the fexes.

Thoughts?

I can post code tomorrow. I just thought I'd send a quick note, just in case someone out there has an idea.

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

My first thought is: Why are you using "an unbound parameter"? It sounds like it needs to be bound to something, like the report / branching fex? Do you do a -TYPE of these incoming variables and values at the top of you initial fex?

I'm assuming that you're using a 'Submit' button of some sort to execute your initial fex. Am I correct in thinking that?

I look forward to more info in the morning.

Doug:

Thanks for the reply.

Below is the code for one of the fexes. All three fexes are like this with extremely minor differences. If I understand you correctly, you were asking about a submit button. I normally don't use one as we have set up fexes to be dynamic without submit buttons.

Basically, I have three reports: New Sales, Used Sales and Service Calls. Each fex is for a Southwest region and has an option for all stores, all stores listing and a specific store.

If I understand correctly, I need a branching fex with all three types listed in order to direct the parameter correctly, plus I need to use a Submit button.

 -IF &STORE_NAME EQ '_FOC_NULL' OR &STORE_NAME LIKE ' All Stores Summary' THEN GOTO ALL ELSE
-IF &STORE_NAME LIKE 'All Stores Listing' THEN GOTO STORE_LIST ELSE GOTO STORE;

-STORE_LIST
-* EXTRACT SOURCE DATA
DEFINE FILE SALES
SALESSET/I4 = EDIT(SALES_YEAR);
YR /YY = SALESSET;
SORT_SALES_REP/A35V = 
					IF SALES_REP_LEVEL EQ 'TR' THEN '   Trainee' ELSE
					IF SALES_REP_LEVEL EQ 'SA' THEN '   Sales Associate' ELSE
					IF SALES_REP_LEVEL EQ 'AR' THEN '  Area Sales Representative' ELSE
					IF SALES_REP_LEVEL EQ 'RG' THEN ' Regional Sales Representative' ELSE
					IF SALES_REP_LEVEL EQ 'JR' THEN 'Junior Vice President of Sales' ELSE
						 SALES_REP_LEVEL
END

-SET &MAXYR = &YR;
-SET &MINYR = &MAXYR-5;

TABLE FILE SALES
SUM
	 SALES.SALES.UNIT_SOLD
BY  LOWEST SALES.SALES.YR
BY  LOWEST SALES.SALES.MODEL
BY	LOWEST SALES.SALES.SORT_SALES_REP
BY  LOWEST SALES.SALES.STORE_NAME
BY  LOWEST SALES.SALES.REGION_NAME
WHERE ( SALES.SALES.SALES_PERIOD EQ 'Sales Year' )
WHERE SALES.SALES.REGION_NAME EQ 'Southwest'
WHERE (SALES.SALES.YR GE &MINYR);
WHERE (SALES.SALES.YR LE &MAXYR);
ON TABLE HOLD AS AGGHOLD FORMAT FOCUS
END
-RUN

-DEFAULTH &YRMAX = 0
TABLE FILE AGGHOLD
SUM MAX.YR/I4 AS 'YRMAX'
ON TABLE HOLD AS MAXYR FORMAT BINARY
END
-RUN
-READFILE MAXYR
-SET &YRMAX = &YRMAX;
-TYPE &YRMAX

-DEFAULTH &EXTYR = 0
TABLE FILE AGGHOLD
BY YR/I4 AS 'EXTYR'
ON TABLE HOLD AS YRLIST FORMAT BINARY
END
-RUN

-SET &NBYR = &LINES;

-REPEAT READYR FOR &I FROM 1 TO &NBYR STEP 1
-DEFAULTH &YR.&I = 0
-READFILE YRLIST
-SET &YR.&I = &EXTYR;
-TYPE &YR.&I
-READYR

DEFINE FILE AGGHOLD
SALES_YEAR/A100 =EDIT(YR);
END

TABLE FILE AGGHOLD
SUM
UNITS_SOLD
BY	SORT_SALES_REP
BY SALES_YEAR
BY STORE_NAME
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS INPUT
ON TABLE SET STYLE *
ENDSTYLE
END

-* SET values for small protect processing and -INCLUDE.
-* Some choices are optional.
-SET &input   = 'input';
-SET &output  = 'final';
-SET &dim1    = 'STORE_NAME';
-SET &dim1_id = 'SORT_SALES_REP';
-SET &dim2    = 'SALES_YEAR';
-SET &measure = 'UNITS_SOLD';

-small cell protection file here

TABLE FILE FINAL
SUM
&measure AS 'UNITS_SOLD'
BY	&dim1._SORT NOPRINT
BY	&dim1 AS 'Store'
BY	LOWEST SORT_SALES_REP AS 'Sales Rep Level'
ACROSS &dim2_id AS 'Sales Year'
WHERE &dim2 NE 'Total' AND &dim1 NE 'Total'
ON &dim1 SUBFOOT
" "
ON TABLE SUBHEAD
"Joe's Office Supplies"
"UNITS_SOLD"
"Sales Years &MINYR - &MAXYR"
"All Stores Listing"
ON TABLE SUBFOOT
"Source: Sales Receipts           "
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML Web Document (HTML),HTML>,<Excel XLSX (XLSX),XLSX>).Output type.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
   -INCLUDE STYLESHEET HERE
TYPE=REPORT, TITLETEXT='WebFOCUS Report', ORIENTATION=LANDSCAPE, $
TYPE=FOOTING, LINE=1, ITEM=1, OBJECT=TEXT, JUSTIFY=RIGHT, FONT='Calibri', SIZE=9, COLOR=RGB(0 0 0), STYLE=NORMAL, $
TYPE=FOOTING, JUSTIFY=RIGHT, FONT='Calibri', SIZE=9, COLOR=RGB(0 0 0), STYLE=ITALIC,
$
TYPE=REPORT,
	 HFREEZE=TOP,
$
TYPE=TITLE,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=TITLE,
	 COLUMN=N2,
     JUSTIFY=LEFT,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=TITLE,
	 COLUMN=N3,
     JUSTIFY=LEFT,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=ACROSSVALUE,
     JUSTIFY=CENTER,
	 WRAP=ON,
$
TYPE=DATA,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=LEFT,
	 SQUEEZE=ON,
$
TYPE=DATA,
     COLUMN=N3,
     JUSTIFY=LEFT,
$
TYPE=DATA,
 	 BORDER-TOP=OFF,
	 BORDER-BOTTOM=OFF,
$
TYPE=TABFOOTING,
     BORDER-TOP=OFF,
$
TYPE=TABFOOTING,
     LINE=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=NORMAL,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=ITALIC,
$
TYPE=TABFOOTING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=ITALIC,
$
TYPE=SUBFOOT
	 BORDER-BOTTOM=ON,
	 BORDER-TOP=ON,
$
TYPE=SUBFOOT
	 BORDER-BOTTOM=LIGHT,
	 BORDER-TOP=LIGHT,
$
TYPE=DATA,      WHEN = SORT_SALES_REP EQ 'Total', COLOR=RGB(255 226 146), STYLE=NORMAL, $
TYPE=DATA,      WHEN = SORT_SALES_REP EQ 'Total', BACKCOLOR=RGB(0 58 99), STYLE=NORMAL, $
TYPE=DATA,      WHEN = SORT_SALES_REP EQ 'Total', BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(0 58 99),$
TYPE=DATA,      WHEN = SORT_SALES_REP EQ 'Total', BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(0 58 99),$
ENDSTYLE
END
-RUN
-GOTO LBL_END;

-STORE
-* EXTRACT SOURCE DATA
DEFINE FILE SALES
SALESSET/I4 = EDIT(SALES_YEAR);
YR /YY = SALESSET;
SORT_SALES_REP/A35V = 
					IF SALES_REP_LEVEL EQ 'TR' THEN '   Trainee' ELSE
					IF SALES_REP_LEVEL EQ 'SA' THEN '   Sales Associate' ELSE
					IF SALES_REP_LEVEL EQ 'AR' THEN '  Area Sales Representative' ELSE
					IF SALES_REP_LEVEL EQ 'RG' THEN ' Regional Sales Representative' ELSE
					IF SALES_REP_LEVEL EQ 'JR' THEN 'Junior Vice President of Sales' ELSE
						 SALES_REP_LEVEL
END

-SET &MAXYR = &YR;
-SET &MINYR = &MAXYR-5;

TABLE FILE SALES
SUM
	 SALES.SALES.UNITS_SOLD
BY  LOWEST SALES.SALES.YR
BY  LOWEST SALES.SALES.SALES_MODEL
BY	LOWEST SALES.SALES.SORT_SALES_REP
BY  LOWEST SALES.SALES.STORE_NAME
WHERE ( SALES.SALES.SALES_PERIOD EQ 'Sales Year' )
WHERE ( SALES.SALES.REGION_NAME EQ '®ION_NAME.(<Southwest,Southwest>).Region:.' );
WHERE ( SALES.SALES.STORE_NAME EQ '&STORE_NAME.(FIND SALES.SALES.STORE_NAME IN SALES).Store:.' );
WHERE (SALES.SALES.YR GE &MINYR);
WHERE (SALES.SALES.YR LE &MAXYR);
ON TABLE HOLD AS AGGHOLD FORMAT FOCUS
END
-RUN

-* EXTRACT MAXIMUM YEAR IN A VARIABLE
-DEFAULTH &YRMAX = 0
TABLE FILE AGGHOLD
SUM MAX.YR/I4 AS 'YRMAX'
ON TABLE HOLD AS MAXYR FORMAT BINARY
END
-RUN
-READFILE MAXYR
-SET &YRMAX = &YRMAX;
-TYPE &YRMAX

-* EXTRACT ALL INDIVIDUAL YEARS IN A VARIABLE
-DEFAULTH &EXTYR = 0
TABLE FILE AGGHOLD
BY YR/I4 AS 'EXTYR'
ON TABLE HOLD AS YRLIST FORMAT BINARY
END
-RUN

-SET &NBYR = &LINES;

-REPEAT READYR FOR &I FROM 1 TO &NBYR STEP 1
-DEFAULTH &YR.&I = 0
-READFILE YRLIST
-SET &YR.&I = &EXTYR;
-TYPE &YR.&I
-READYR

DEFINE FILE AGGHOLD
SALES_YEAR/A100 =EDIT(YR);
END

TABLE FILE AGGHOLD
SUM
UNITS_SOLD
BY	SORT_SALES_REP
BY SALES_YEAR
BY STORE_NAME
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS INPUT
ON TABLE SET STYLE *
ENDSTYLE
END

-* SET values for small protect processing and -INCLUDE.
-* Some choices are optional.
-SET &input   = 'INPUT';
-SET &output  = 'FINAL';
-SET &dim1    = 'STORE_NAME';
-SET &dim1_id = 'SORT_SALES_REP';
-SET &dim2    = 'SALES_YEAR';
-SET &measure = 'UNITS_SOLD';

-small cell protection file here

TABLE FILE FINAL
SUM
&measure AS 'UNITS_SOLD'
BY &dim1._SORT NOPRINT
BY &dim1 AS 'Store'
BY LOWEST &dim1_id AS 'Sales Rep Level'
ACROSS &dim2 AS 'Sales Year'
WHERE &dim2 NE 'Total'
ON TABLE SUBHEAD
"Joe's Office Supplies"
"UNITS_SOLD"
"Sales Years &MINYR - &MAXYR"
"&STORE_NAME"
ON TABLE SUBFOOT
"Source: Sales Receipts           "
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML Web Document (HTML),HTML>,<Excel XLSX (XLSX),XLSX>).Output type.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
    INCLUDE=stylesheet here
TYPE=REPORT, TITLETEXT='WebFOCUS Report', ORIENTATION=LANDSCAPE, $
TYPE=FOOTING, LINE=1, ITEM=1, OBJECT=TEXT, JUSTIFY=RIGHT, FONT='Calibri', SIZE=9, COLOR=RGB(0 0 0), STYLE=NORMAL, $
TYPE=FOOTING, JUSTIFY=RIGHT, FONT='Calibri', SIZE=9, COLOR=RGB(0 0 0), STYLE=ITALIC,
$
TYPE=REPORT,
	 HFREEZE=TOP,
$
TYPE=TITLE,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=TITLE,
	 COLUMN=N2,
     JUSTIFY=LEFT,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=TITLE,
	 COLUMN=N3,
     JUSTIFY=LEFT,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=ACROSSVALUE,
     JUSTIFY=CENTER,
	 WRAP=ON,
$
TYPE=DATA,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=LEFT,
	 SQUEEZE=ON,
$
TYPE=DATA,
     COLUMN=N3,
     JUSTIFY=LEFT,
$
TYPE=DATA,
 	 BORDER-TOP=OFF,
	 BORDER-BOTTOM=OFF,
$
TYPE=TABFOOTING,
     BORDER-TOP=OFF,
$
TYPE=TABFOOTING,
     LINE=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=NORMAL,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=ITALIC,
$
TYPE=TABFOOTING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=ITALIC,
$
TYPE=SUBFOOT
	 BORDER-BOTTOM=ON,
	 BORDER-TOP=ON,
$
TYPE=SUBFOOT
	 BORDER-BOTTOM=LIGHT,
	 BORDER-TOP=LIGHT,
$
TYPE=DATA,        WHEN = STORE_NAME EQ 'Total', COLOR=RGB(255 226 146), STYLE=NORMAL, $
TYPE=DATA,        WHEN = STORE_NAME EQ 'Total', BACKCOLOR=RGB(0 58 99), STYLE=NORMAL, $
TYPE=DATA,        WHEN = STORE_NAME EQ 'Total', BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(0 58 99),$
TYPE=DATA,        WHEN = STORE_NAME EQ 'Total', BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(0 58 99),$
ENDSTYLE
END
-RUN
-GOTO LBL_END;

-ALL
-* EXTRACT SOURCE DATA
DEFINE FILE SALES
SALESSET/I4 = EDIT(SALES_YEAR);
YR /YY = SALESSET;
SORT_SALES_REP/A35V = 
					IF SALES_REP_LEVEL EQ 'TR' THEN '   Trainee' ELSE
					IF SALES_REP_LEVEL EQ 'SA' THEN '   Sales Associate' ELSE
					IF SALES_REP_LEVEL EQ 'AR' THEN '  Area Sales Representative' ELSE
					IF SALES_REP_LEVEL EQ 'RG' THEN ' Regional Sales Representative' ELSE
					IF SALES_REP_LEVEL EQ 'JR' THEN 'Junior Vice President of Sales' ELSE
						 SALES_REP_LEVEL
END

-SET &MAXYR = &YR;
-SET &MINYR = &MAXYR-5;

TABLE FILE SALES
SUM
     SALES.SALES.SALES_REP_LEVEL
	 SALES.SALES.UNITS_SOLD
BY  LOWEST SALES.SALES.YR
BY  LOWEST SALES.SALES.SALES_MODEL
BY	LOWEST SALES.SALES.SORT_SALES_REP
BY  LOWEST SALES.SALES.REGION_NAME
WHERE ( SALES.SALES.SALES_PERIOD EQ 'Sales Year' )
WHERE SALES.SALES.REGION_NAME EQ 'Southwest'
WHERE (SALES.SALES.YR GE &MINYR);
WHERE (SALES.SALES.YR LE &MAXYR);
ON TABLE HOLD AS AGGHOLD FORMAT FOCUS
END
-RUN

-* EXTRACT MAXIMUM YEAR IN A VARIABLE
-DEFAULTH &YRMAX = 0
TABLE FILE AGGHOLD
SUM MAX.YR/I4 AS 'YRMAX'
ON TABLE HOLD AS MAXYR FORMAT BINARY
END
-RUN
-READFILE MAXYR
-SET &YRMAX = &YRMAX;
-TYPE &YRMAX

-* EXTRACT ALL INDIVIDUAL YEARS IN A VARIABLE
-DEFAULTH &EXTYR = 0
TABLE FILE AGGHOLD
BY YR/I4 AS 'EXTYR'
ON TABLE HOLD AS YRLIST FORMAT BINARY
END
-RUN

-SET &NBYR = &LINES;

-REPEAT READYR FOR &I FROM 1 TO &NBYR STEP 1
-DEFAULTH &YR.&I = 0
-READFILE YRLIST
-SET &YR.&I = &EXTYR;
-TYPE &YR.&I
-READYR

DEFINE FILE AGGHOLD
SALES_YEAR/A100 =EDIT(YR);
END

TABLE FILE AGGHOLD
SUM
UNITS_SOLD
BY	SORT_SALES_REP
BY SALES_YEAR
BY REGION_NAME
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS INPUT
ON TABLE SET STYLE *
ENDSTYLE
END

-* SET values for small protect processing and -INCLUDE.
-* Some choices are optional.
-SET &input   = 'INPUT';
-SET &output  = 'FINAL';
-SET &dim1    = 'REGION_NAME';
-SET &dim1_id = 'SORT_SALES_REP';
-SET &dim2    = 'SALES_YEAR';
-SET &measure = 'UNITS_SOLD';
-INCLUDE stylesheet here

TABLE FILE FINAL
SUM
&measure AS 'UNITS_SOLD'
BY	&dim1._SORT NOPRINT
BY &dim1 AS 'Region'
BY	LOWEST &dim1_id AS 'Sales Rep Level'
ACROSS &dim2 AS 'Sales Year'
WHERE &dim2 NE 'Total'
ON TABLE SUBHEAD
"Joe's Office Supplies"
"UNITS_SOLD"
"Sales Years &MINYR - &MAXYR"
"All Stores Summary"
ON TABLE SUBFOOT
"Source: Sales Receipts           "
" "
ON TABLE SUBFOOT
"Source: KHEDS Sales Year Collection           "
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML Web Document (HTML),HTML>,<Excel XLSX (XLSX),XLSX>).Output type.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
    INCLUDE=stylesheet file
TYPE=REPORT, TITLETEXT='WebFOCUS Report', ORIENTATION=LANDSCAPE, $
TYPE=FOOTING, LINE=1, ITEM=1, OBJECT=TEXT, JUSTIFY=RIGHT, FONT='Calibri', SIZE=9, COLOR=RGB(0 0 0), STYLE=NORMAL, $
TYPE=FOOTING, JUSTIFY=RIGHT, FONT='Calibri', SIZE=9, COLOR=RGB(0 0 0), STYLE=ITALIC,
$
TYPE=REPORT,
	 HFREEZE=TOP,
$
TYPE=TITLE,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=TITLE,
	 COLUMN=N2,
     JUSTIFY=LEFT,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=TITLE,
	 COLUMN=N3,
     JUSTIFY=LEFT,
	 BORDER-BOTTOM=ON,
	 BORDER-BOTTOM-COLOR=RGB (0 58 99),
$
TYPE=ACROSSVALUE,
     JUSTIFY=CENTER,
	 WRAP=ON,
$
TYPE=DATA,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=LEFT,
	 SQUEEZE=ON,
$
TYPE=DATA,
     COLUMN=N3,
     JUSTIFY=LEFT,
$
TYPE=DATA,
 	 BORDER-TOP=OFF,
	 BORDER-BOTTOM=OFF,
$
TYPE=TABFOOTING,
     BORDER-TOP=OFF,
$
TYPE=TABFOOTING,
     LINE=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=NORMAL,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=ITALIC,
$
TYPE=TABFOOTING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     STYLE=ITALIC,
$
TYPE=SUBFOOT
	 BORDER-BOTTOM=ON,
	 BORDER-TOP=ON,
$
TYPE=SUBFOOT
	 BORDER-BOTTOM=LIGHT,
	 BORDER-TOP=LIGHT,
$
TYPE=DATA,        WHEN = REGION_NAME EQ 'Total', COLOR=RGB(255 226 146), STYLE=NORMAL, $
TYPE=DATA,        WHEN = REGION_NAME EQ 'Total', BACKCOLOR=RGB(0 58 99), STYLE=NORMAL, $
TYPE=DATA,        WHEN = REGION_NAME EQ 'Total', BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(0 58 99),$
TYPE=DATA,        WHEN = REGION_NAME EQ 'Total', BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(0 58 99),$
ENDSTYLE
END
-RUN
-LBL_END;
 

Julie

I think you are on the right track now. I agree with Doug that the unbound parameter does need to be tied to an object on the html form for this to work.

So, this is just to confirm: Are you saying I need a branching fex and a Submit button?

I've not written a branching fex previously, so I'll try to find one on the forum or in the documentation.

Thank you.

Julie

Yes the submit button will run a fex which will have logic to evaluate that parameter and do a -INCLUDE of the appropriate fex. Something like this except with your path to the fex's in the repository.


-IF &STORE_NAME EQ '_FOC_NULL' OR &STORE_NAME LIKE ' All Stores Summary' THEN GOTO ALL ELSE
-IF &STORE_NAME LIKE 'All Stores Listing' THEN GOTO STORE_LIST ELSE GOTO STORE;
-ALL
-INCLUDE /WFC/Repository/folder/all.fex
-GOTO FINISH
-STORE_LIST
-INCLUDE /WFC/Repository/folder/store_list.fex
-GOTO FINISH
-STORE
-INCLUDE /WFC/Repository/folder/store.fex
-FINISH


Thanks for the reply, Chuck.

I'm not sure if I am misunderstanding something or if I did not make my question as clear as I should have earlier. I guess I have written tons of branching statements. I didn't realize the terminology. We usually call them IF-THEN or Dialog Manager statements.

To restate my question:

I have three procedures.

Each procedure has three sections each.

The branching statement at the top directs the code to one of three sections based on user selection.

I need to add another user selection dropdown called Report Type.

The types will be for each of the three procedures: New Sales, Used Sales, and Service Calls.

In theory, I believe your solution should work, but I'll have to write the branching a little differently.

Are you saying I should use the same branching statement at the top and add all three fexes under each section?

 -IF &STORE_NAME EQ '_FOC_NULL' OR &STORE_NAME LIKE ' All Stores Summary' THEN GOTO ALL ELSE
-IF &STORE_NAME LIKE 'All Stores Listing' THEN GOTO STORE_LIST ELSE GOTO STORE;
-ALL
-INCLUDE /WFC/Repository/folder/new_sales.fex
-INCLUDE /WFC/Repository/folder/used_sales.fex
-INCLUDE /WFC/Repository/folder/service_calls.fex

-GOTO FINISH
-STORE_LIST
-INCLUDE /WFC/Repository/folder/new_sales.fex
-INCLUDE /WFC/Repository/folder/used_sales.fex
-INCLUDE /WFC/Repository/folder/service_calls.fex
-GOTO FINISH
-STORE
-INCLUDE /WFC/Repository/folder/new_sales.fex
-INCLUDE /WFC/Repository/folder/used_sales.fex
-INCLUDE /WFC/Repository/folder/service_calls.fex

-FINISH
 

quote:

Are you saying I should use the same branching statement at the top and add all three fexes under each section?
-IF &STORE_NAME EQ '_FOC_NULL' OR &STORE_NAME LIKE ' All Stores Summary' THEN GOTO ALL ELSE
-IF &STORE_NAME LIKE 'All Stores Listing' THEN GOTO STORE_LIST ELSE GOTO STORE;
-ALL
-INCLUDE /WFC/Repository/folder/new_sales.fex
-INCLUDE /WFC/Repository/folder/used_sales.fex
-INCLUDE /WFC/Repository/folder/service_calls.fex

-GOTO FINISH
-STORE_LIST
-INCLUDE /WFC/Repository/folder/new_sales.fex
-INCLUDE /WFC/Repository/folder/used_sales.fex
-INCLUDE /WFC/Repository/folder/service_calls.fex
-GOTO FINISH
-STORE
-INCLUDE /WFC/Repository/folder/new_sales.fex
-INCLUDE /WFC/Repository/folder/used_sales.fex
-INCLUDE /WFC/Repository/folder/service_calls.fex

-FINISH

If your condition's result is the same no matter the condition, there is no need to have a condition.
Your ReportType parameter must be used somewhere in the process.

What change will occurs according to selection of ReportType ?

Apparently I'm struggling to communicate what is needed in this case. Let me try again a different way.

I have three procedures.

Each procedure has three sections (All Stores Summary, All Stores Listing, Specific Store).

The summary provides aggregated data for all the stores in the region.
The listing provides detail data for each store in one big list.
The store just provides data for one store.

In my html file, I need four dropdown boxes from which users can make their selections:

1. Report Type (in this case, New Sales, Used Sales or Service Calls). Each report type is in a completely different fex, and I tried to use the procedures as value names yesterday without any success.

2. After Report Type is chosen, the user selects the detail level: All Stores Summary, All Stores Listing or a Specific Store.

3. Users select a year range

4. Users select an Output type.

I have no issue with items 2-4. I am just struggling with #1.

In summary, a user can select one of nine (9) different combinations for the first two selections (and the results change) as follows:

New Sales (procedure) for All Stores Summary (section)
Used Sales (procedure) for All Stores Summary (section)
Service Calls (procedure) for All Stores Summary (section)

New Sales (procedure) for All Stores Listing (section)
Used Sales (procedure) for All Stores Listing (section)
Service Calls (procedure) for All Stores Listing (section)

New Sales (procedure) for a Specific Store (section)
Used Sales (procedure) for a Specific Store (section)
Service Calls (procedure) for a Specific Store (section)

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

Can the ReportType only be a parameter to the three sections (kind of report: Stores Summary, Stores Listing, Specific Store) ?

It seems to me that you only have three kind of reports (Sum, List, Spec) with a filter on a "type of record" to include in it.
It's look like you making it to much complicated for nothing. You don't need 9 fex, at worst 3, but only 1 should have do the trick.

MartinY:

Thanks for the note.

I am aware I could combine it all into one fex. For particular business reasons we want to keep them as three separate fexes instead of one.

At this point, I only have three fexes not nine as mentioned earlier. I was listing the various data combinations in response to a question someone raised about the data changing based on user selection.

That being said, I am still trying to figure out how to get the Report Type (each of the three fexes) to work in a dropdown for users to select from.

According to the documentation I read yesterday, I should be able to:

• Create a static unbound parameter.
  
• Use values are procedure names.
  
• Change the display name to be a word or two instead of the big file name.
  
• Bind the parameter to either Submit or Selection Changed.

What ends up happening in my case is that the first fex populates no matter what Report Type I choose.

Clearly I do not understand something in its entirety or have not programmed something correctly.

Thanks for the help.

Hi Julie,

Here how I understand it and see the resolution of your issue.

First, no need to chain the control together since there is no relation between each other as far as I can understand.
Second, below are the control definition as I thought they should be (or similar to that).
Third, each control will be passed to a main fex that will branch to the proper sub-query. So at the end, only one iframe that will display the proper result

Report Type control :

Value  Display
1      New Sales
2      Used Sales
3      Service Calls

Store Name control : this control has the store number list where two "global" option have been added

Value      Display
ALL        All Stores Summary
LST        All Stores Listing
<store#1>  <store#1>
<store#2>  <store#2>
<store#3>  <store#3>
...

Year control :

Value Display
2015  2015
2016  2016
2017  2017
2018  2018
...

Output Type control :

Value Display
HTML  Web Document (HTML)
XLSX  Excel

The main fex (since you mentioned : Each report type is in a completely different fex):

-IF &REPORT_TYPE EQ '1' THEN GOTO NEW_RPT;
-IF &REPORT_TYPE EQ '2' THEN GOTO USED_RPT;
-GOTO SRV_RPT

-NEW_RPT
-INCLUDE new_sales_rpt.fex
-GOTO XEND

-USED_RPT
-INCLUDE used_sales_rpt.fex
-GOTO XEND

-SRV_RPT
-INCLUDE service_calls_rpt.fex
-GOTO XEND

-XEND

new_sales_rpt.fex

-IF &STORE_NAME EQ 'ALL' THEN GOTO ALL;
-IF &STORE_NAME EQ 'LST' THEN GOTO STORE_LIST;
-GOTO STORE;

<your code as already provided or whatever else you need>

used_sales_rpt.fex

-IF &STORE_NAME EQ 'ALL' THEN GOTO ALL;
-IF &STORE_NAME EQ 'LST' THEN GOTO STORE_LIST;
-GOTO STORE;

<your code as already provided or whatever else you need>

service_calls_rpt.fex

-IF &STORE_NAME EQ 'ALL' THEN GOTO ALL;
-IF &STORE_NAME EQ 'LST' THEN GOTO STORE_LIST;
-GOTO STORE;

<your code as already provided or whatever else you need>

I personally not have done it that way but it seems the way that you've defined your fex.
For me it seems that each report type will branch to the same report fex (All, List, Store).
So no need to have three ReportType fex, only need to pass a parameter (filter on type of sales : new, used, service call) to existing report fex (All, List, Store).
But I may miss some part of your request.

Thank you, MartinY, for your solution. It's very similar to what we finally ended up with as a solution.

How our solution differed from yours is that:

1. We chained the Report Type to our other controls. If we hadn't, we would not have been able to utilize the dynamic functionality of selecting one of three report types and having the frame automatically load with the correct type.

2. We used LBLEND instead of XEND.

Thanks to you and all those who offered solutions. It was in reading a few of the last posts that we realized what we were doing incorrectly on this secondary solution. Our first solution was to utilize the values are procedure names, but we never got that one going in totality.

Thank again everyone!