i would like to make a webfocus dynamic dropdown list in frontpage. everything works well, but the value to be dynamic is the year. my problem is that i get as many years as there are datasets :-( but i only want one occurance per year...
how can i solve this.. maybe there is a simple and quick solution, but i don�t have an idea about it...
would be great to get some hints from you...
greets from sunny autria!
I'm not a pro at drop-downs but are you doing a SUM and BY on your YEAR field.....
I'm sure there are other ways but here is a
code example of one of our year drop-downs
TABLE FILE BU01TB06
COMPUTE YEARVAL/A8 =
IF CD_YEAR EQ '&TRANS' THEN 'SELECTED' ELSE ' ' ; NOPRINT
COMPUTE OPC/A128 =
ON TABLE SET HOLDLIST PRINTONLY
BY CD_YEAR NOPRINT
ON TABLE HOLD AS YEARIS FORMAT ALPHA
-RUNThis message has been edited. Last edited by: <Mabel>,
Hi and thanks for your suggestion..
Hmm, sorry i really don�t know how to use ist...
i am working with frontpage and there i create a dynamic dropdown with the field "year"... but as i mentioned before i get hundreds of the same year.. and i only want one per year.. maybe i can manipulate the year in the fex using distinct or smthg like that, but i don�t know how to make this work or which tool to use...
i read about SQL statements in webfocus:
her you can use SELECT DISTINCT .....
is there a possibility to use this for my problem?
i would like to make a dynamic dropdown in frontpage with only one row for each year of my database.
...or are there any other suggestions and ideas?
|<Pietro De Santis>|
How are you creating the drop down list - can you please show us the fex?
hi! found a solution myself... just one thing.. i need date format and in the example is alfanumeric.. but if i fix this, it will probably work..
sorry pietro didn�t see your answer till now..
in my fex there is the missing variable/field. so fex would be useless four you..
|Powered by Social Strata|