I am trying to create a drop down to allow the user to decide the sort order of a specific column. I was able to get the drop down with the column choices and the separate drop down with highest and lowest. However, when I run the report it does not understand the highest and lowest values being passed. Both values were created as report variables. I have searched on here to find an answer, but have not come across it. Does anyone know how to?

The salerank.fex in the ibinccen directory has an example of that.

What happens if you put a -TYPE at the beginning of your program to see what the contents of the selected variables are? You can put a -EXIT right after that. Once you determine what is coming back, you can figure out the problem.

What I guess I am saying is that we don't have enough information to help you. You could also post your code between the code tags.

TABLE FILE WEBFOCUS_REPORT_AGENCY_DATA
SUM
&Filter.(<2005,SALESPREV3>,<2006,SALESPREV2>,<2007,SALESPREV1>,,,,,).Sort Report By. NOPRINT
BY TOTAL &Order.(,).Order By. NOPRINT
SUM
&Order.(,).Order By. NOPRINT
&Filter.(<2005,SALESPREV3>,<2006,SALESPREV2>,<2007,SALESPREV1>,,,,,).Sort Report By. NOPRINT
SALESPREV3/P10CM AS '2005'
SALESPREV2/P10CM AS '2006'
SALESPREV1/P10CM AS '2007'
SALESCURYTD/P10CM AS 'YTD'
SALESYTDLY/P10CM AS 'YTD LY'
COMPUTE Variance/D12CM = SALESCURYTD - SALESYTDLY; AS 'YOY,Change'
SALESCURMTH/P10CM AS 'Current,Month'
SALESCURMTHLY/P10CM AS 'Current,Month LY'
MAX.LASTYRMTH/I6 AS 'Last Report'
BY TOTAL &Order.(,).Order By. NOPRINT
BY SUPPLIERID AS 'ID'
BY Top100 AS ''
BY SUPPLIERNAME AS 'Name'
BY SUPPTYPE AS 'Type'
ON TABLE SUBHEAD
"Supplier Rank For Given Product Type"
"Supplier Type: <+0>&SUPPTYPE"
"Membership Status: <+0>&MEMBERSHIPSTATUS"
"Territory: <+0>&TERRITORY<+0> "
ON TABLE SUBFOOT
"Run Date: <+0>&DATEtrMDYY <+0> "
WHERE SUPPTYPE EQ &SUPPTYPE.(OR(,,,,,,,)).Choose Type.;
WHERE MEMBERSHIPSTATUS EQ &MEMBERSHIPSTATUS.(OR(,,)).MEMBERSHIPSTATUS.;
WHERE TERRITORY EQ &TERRITORY.(OR(<00,00>,<11,11>,<12,12>,<13,13>,<21,21>,<22,22>,<23,23>,<51,51>,<52,52>,<95,95>)).TERRITORY.;
WHERE TOTAL ( SALESCURYTD GT 0 ) OR ( SALESPREV1 GT 0 );
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV3 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV2 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV1 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURYTD WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESYTDLY Variance WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTH WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTHLY AS 'TOTAL'
ON TABLE PCHOLD FORMAT &WFFMT.(,,).Select type of display output.
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.055556,
BOTTOMMARGIN=0.055556,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
$
TYPE=DATA,
COLUMN=N6,
SIZE=8,
JUSTIFY=LEFT,
FOCEXEC=app/agency_list_standard(SUPPLIERID=N5 MEMBERSHIPSTATUS=&MEMBERSHIPSTATUS.QUOTEDSTRING TERRITORY=&TERRITORY.QUOTEDSTRING),
$
TYPE=DATA,
COLUMN=N16,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
SIZE=8,
JUSTIFY=LEFT,
FOCEXEC=app/agency_list_custom(SUPPLIERID=N5),
$
TYPE=DATA,
COLUMN=N19,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
SIZE=8,
JUSTIFY=LEFT,
FOCEXEC=NONE,
$
TYPE=DATA,
COLUMN=N11,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N13,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N14,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N15,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N17,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N18,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N20,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N16,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N19,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
STYLE=BOLD+UNDERLINE,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N11,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N17,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N18,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N20,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=11,
STYLE=BOLD+UNDERLINE,
$
TYPE=TABHEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
SIZE=9,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=5,
SIZE=9,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=6,
SIZE=9,
$
TYPE=TABHEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
SIZE=8,
BACKCOLOR='NONE',
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=1.305556,
$
ENDSTYLE
END

WebFocus 7.6.4
SQL
HTML and Excel

When I put in the -TYPE and EXIT
EDA NO DATA comes up....

Thanks...

Use this code instead...

JOIN
WEBFOCUS_REPORT_AGENCY_DATA.WEBFOCUS_REPORT_AGENCY_DATA.AGENCYID IN
WEBFOCUS_REPORT_AGENCY_DATA TO MULTIPLE
WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.AGENCYID
IN WEBFOCUS_REPORT_SALES_BY_SUPPLIER AS J0
END
JOIN
WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SUPPLIERID
IN WEBFOCUS_REPORT_AGENCY_DATA TO MULTIPLE
WEBFOCUS_REPORT_SUPPLIER_DATE_LAST.WEBFOCUS_REPORT_SUPPLIER_DATE_LAST.SUPPLIERID
IN WEBFOCUS_REPORT_SUPPLIER_DATE_LAST AS J1
END
DEFINE FILE WEBFOCUS_REPORT_AGENCY_DATA
Top100/A10='Top 100';
END
TABLE FILE WEBFOCUS_REPORT_AGENCY_DATA
SUM
&Filter.(<2005,SALESPREV3>,<2006,SALESPREV2>,<2007,SALESPREV1>,,,,,).Sort Report By. NOPRINT
BY TOTAL &Order.(,).Order By. NOPRINT
SUM
&Order.(,).Order By. NOPRINT
&Filter.(<2005,SALESPREV3>,<2006,SALESPREV2>,<2007,SALESPREV1>,,,,,).Sort Report By. NOPRINT
SALESPREV3/P10CM AS '2005'
SALESPREV2/P10CM AS '2006'
SALESPREV1/P10CM AS '2007'
SALESCURYTD/P10CM AS 'YTD'
SALESYTDLY/P10CM AS 'YTD LY'
COMPUTE Variance/D12CM = SALESCURYTD - SALESYTDLY; AS 'YOY,Change'
SALESCURMTH/P10CM AS 'Current,Month'
SALESCURMTHLY/P10CM AS 'Current,Month LY'
MAX.LASTYRMTH/I6 AS 'Last Report'
BY TOTAL &Order.(,).Order By. NOPRINT
BY SUPPLIERID AS 'ID'
BY Top100 AS ''
BY SUPPLIERNAME AS 'Name'
BY SUPPTYPE AS 'Type'
ON TABLE SUBHEAD
"Supplier Rank For Given Product Type"
"Supplier Type: <+0>&SUPPTYPE"
"Membership Status: <+0>&MEMBERSHIPSTATUS"
"Territory: <+0>&TERRITORY<+0> "
ON TABLE SUBFOOT
"Run Date: <+0>&DATEtrMDYY <+0> "
WHERE SUPPTYPE EQ &SUPPTYPE.(OR(,,,,,,,)).Choose Type.;
WHERE MEMBERSHIPSTATUS EQ &MEMBERSHIPSTATUS.(OR(,,)).MEMBERSHIPSTATUS.;
WHERE TERRITORY EQ &TERRITORY.(OR(<00,00>,<11,11>,<12,12>,<13,13>,<21,21>,<22,22>,<23,23>,<51,51>,<52,52>,<95,95>)).TERRITORY.;
WHERE TOTAL ( SALESCURYTD GT 0 ) OR ( SALESPREV1 GT 0 );
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV3 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV2 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESPREV1 WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURYTD WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESYTDLY Variance WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTH WEBFOCUS_REPORT_SALES_BY_SUPPLIER.WEBFOCUS_REPORT_SALES_BY_SUPPLIER.SALESCURMTHLY AS 'TOTAL'
ON TABLE PCHOLD FORMAT &WFFMT.(,,).Select type of display output.
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.055556,
BOTTOMMARGIN=0.055556,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='VERDANA',
SIZE=9,
$
TYPE=DATA,
COLUMN=N6,
SIZE=8,
JUSTIFY=LEFT,
FOCEXEC=app/agency_list_standard(SUPPLIERID=N5 MEMBERSHIPSTATUS=&MEMBERSHIPSTATUS.QUOTEDSTRING TERRITORY=&TERRITORY.QUOTEDSTRING),
$
TYPE=DATA,
COLUMN=N16,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
SIZE=8,
JUSTIFY=LEFT,
FOCEXEC=app/agency_list_custom(SUPPLIERID=N5),
$
TYPE=DATA,
COLUMN=N19,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
SIZE=8,
JUSTIFY=LEFT,
FOCEXEC=NONE,
$
TYPE=DATA,
COLUMN=N11,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N13,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N14,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N15,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N17,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N18,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N20,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=8,
$
TYPE=TITLE,
COLUMN=N16,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N19,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
STYLE=BOLD+UNDERLINE,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N11,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N17,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N18,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N20,
STYLE=BOLD+UNDERLINE,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=11,
STYLE=BOLD+UNDERLINE,
$
TYPE=TABHEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
SIZE=9,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=5,
SIZE=9,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=6,
SIZE=9,
$
TYPE=TABHEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
STYLE=NORMAL,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
SIZE=8,
BACKCOLOR='NONE',
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=1.305556,
$
ENDSTYLE
END

WebFocus 7.6.4
SQL
HTML and Excel

Where are you setting your variable &Order and &Filter and what are the values supposed to be? There would normally be some -SET statements to set these up from the parameters you pass. What &var is handling the HIGHEST or LOWEST value that you are wanting to control? Also it seemed a little strange that you would DEFINE Top100 to a literal value and then sort on that value - even though it is the same for every record.

And, unless the stylesheet is part of the issue here, you can leave that part off when posting. Just makes it harder to get to the bottom of things.

Thanks....

The syntax is

BY HIGHEST/LOWEST TOTAL fieldname

I don't see that in your code at all.

Also if you don't see the selected items from your web page when you do the -TYPE and the -EXIT (make sure your output format is HTML for this), then there is something wrong with your launch page. Or are you using the default autoprompt page?

I am using the default lunch page. I do not know why it is not displaying in the code. However, I think I have found a work around it.

thanks,

kfr, sounds like a perfect use of Active Reports. Did your company buy that?

No they did not.

Thanks,

Check out the following code where I do what it seems that you are attempting (I left out much of the extraeous code):


-* File JaguarReport.fex

Get the dates used in the extract
-INCLUDE reportdates
-INCLUDE EXTRACT1

-* 20080805 DL : Added &SortOrder so that we can combine the two versions into one procedures
-* &SortOrder values are: EXCESS and PERCENT which are used in the HEADING
-* The -DEFAULT &SortOrder is used and picked up in the GUI for the Launch Page creation.
-DEFAULT &SortOrder = 'EXCESS' ;
-TYPE *** &|SortOrder (IN): &SortOrder

TABLE FILE RANKING5
PRINT DEALER_# AS 'DEALER#DEALER_NAME AS 'DEALER NAME'
COUNTOFVIN AS 'VINS'
TOTALS/P10M AS 'TOTAL'
EXCESS
DLR_CPVS/P5M AS 'CPVS'
PERCENT

RANKED BY HIGHEST &SortField NOPRINT

HEADING
"USA - ALL VEHICLES EXCESS COST RANKING ~ BY &SortOrder"
"For Six Months Ending &ReportEndMonth &ReportEndDay, &ReportEndYear"
FOOTING BOTTOM
"Ran On : &DATEMtrDYY @ &ReportTime"
"Prog ID: &FOCFOCEXEC <60>PageofON TABLE PCHOLD FORMAT PDF
-*ON TABLE HOLD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
TYPE=Report, GRID=Off, SQUEEZE=ON, UNITS=Inches,$
TYPE=REPORT, IMAGE=jaguar.jpg, POSITION=( .25 .25), SIZE=(.86 .55),$
TYPE=REPORT, IMAGE=jaguar.jpg, POSITION=(7.39 .25), SIZE=(.86 .55),$
TYPE=DATA, FONT='COURIER', SIZE=8,$
TYPE=TITLE, FONT='COURIER', SIZE=8,$
TYPE=HEADING, JUSTIFY=CENTER, STYLE=BOLD+ITALIC, SIZE=10,$
TYPE=FOOTING, LINE=2, STYLE=BOLD+ITALIC, SIZE=8,$
TYPE=FOOTING, LINE=1, JUSTIFY=LEFT, STYLE=BOLD+ITALIC, SIZE=9,$
TYPE=SUBFOOT, FONT=TIMES, SIZE=9,$
ENDSTYLE
END

Current Client: WebFOCUS 7.1.4 Client: Windows, Reporting Server: Unix, Data: Oracle, Teradata
Local Laptop: WebFOCUS 7.6.5 on Vista/Apache/Tomcat, Data: FOCUS, MS Access

Thanks for the code!