Can anyone help me with column-sorting on the fly where the user can click on a hyperlink on any column on the report(html) to re-generate the same report based on the field they click??
Appreciate ur help
If you have subscribed to the OLAP option of WebFocus , then the absolute easiest way to sort any column of a displayed report is to just add the line ...
as the first non-comment line of the Focexec
You can also use the "self-drilldown" technique:
-* sort.fex file:
-* Sort order: HIGHEST or LOWEST:
-* Previous sort column:
-* The SORTCOL column is used for sorting:
-* Set up the sort order appropriately:
-SET &SORTORD= IF &PREVSRT NE &SORTCOL THEN 'LOWEST' ELSE
- IF &SORTORD EQ 'LOWEST' THEN 'HIGHEST' ELSE 'LOWEST';
TABLE FILE CAR
BY &SORTORD TOTAL &SORTCOL NOPRINT
ON TABLE SET STYLE *
TYPE=TITLE, COLUMN=P1, FOCEXEC=SORTS ( \
TYPE=TITLE, COLUMN=P2, FOCEXEC=SORTS ( \
It is not so effortless like OLAP (especially in the real-life cases), but is more flexible and completely customizable.
I agree with Gregorz.
I use this technique, and along with it, i put a mouseover on the column title
SUM DOLLARS AS
'[span title="click to sort by">Dollars[/span>'
and then the user knows what to do.
Thank you guys for all ur suggestions! I got it working now.
|Powered by Social Strata|