I am attempting to create a report with a Dynamic List of Values. I am using the demo database CENTORD.FOC. This database is located in C:\ibi\apps\ibinccen of my Windows XP WebFOCUS 5.3.2 installation.

When I attempt the following code, I get an empty drop down box, and I am not able to run the report. The code I am using is:

TABLE FILE CENTORD
PRINT ORDER_DATE ORDER_NUM
BY STORE_CODE
WHERE STORE_CODE EQ '&STORE.(FIND STORE_CODE IN CENTORD).STORE CODE.'
END

When I attempt another report against the CAR.FOC database (in the same folder), the report works correctly. The code I use against the CAR database is:

TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
WHERE COUNTRY EQ '&COUNTRY.(FIND COUNTRY IN CAR).COUNTRY.'

Since the Dynamic List of Values technique works against the CAR database and not against the CENTORD database, I suspect there is something wrong about the CENTORD database, but I don't know what the problem is.

Does anyone have any idea why a Dynamic List of Values cannot be generated against the CENTORD demo database?

I get a populated dynamic list of values from CENTORD.
TABLE FILE CENTORD
ON TABLE SET PAGE-NUM OFF
SUM QTY_IN_STOCK
BY STATE
BY SNAME
BY PRODNAME
ON TABLE SUBHEAD
"Inventory Report"
"For State= &STATE, Store Name= &SNAME, and Product Name= &PRODNAME "
" "
WHERE STATE EQ '&STATE.(FIND STATE IN CENTORD).2-3 letters for US State.'
WHERE SNAME EQ '&SNAME.(AND(eMart,TV City,Web Sales)).Store Name.'
WHERE PRODNAME EQ '&PRODNAME.(FIND PRODNAME IN CENTORD).Product Name.'
END

We are on 5.21

In fact, I tried your code, and it works for me.

I tried the suggested code with my WebFOCUS 5.3.2 Windows XP installation, and it still fails to populate a drop down list with values from the database. Since the suggested code was able to be run on a prior release of WebFOCUS, I think this must be a bug with version 5.3.2 of WebFOCUS. If anyone is able to run the suggested code with version 5.3.2, then please let me know.

John, i tried your Car example in 525, and it didn't work. hmmm?
and.NSelph, i tried your code, and it doesn't work either, 525, servlet.

I'm having the same results with 5.3.2. Do we know if this is a bug??

Here's the code I used and it works:

TABLE FILE CENTORD
PRINT
ORDER_DATE
ORDER_NUM
BY
STORE_CODE
WHERE ( STORE_CODE EQ &STORE.(OR(FIND STORE_CODE IN CENTORD)).Store Code. );


A couple of things to notice:

CENTORD and CAR both work for me under 5.32, Windows XP. That has been pretty stable for some time now.

[LIST]

Note that in my code there are extra parenthesis. That might do the trick.

Does that help?

Here's the code I used and it works:

TABLE FILE CENTORD
PRINT
ORDER_DATE
ORDER_NUM
BY
STORE_CODE
WHERE ( STORE_CODE EQ &STORE.(OR(FIND STORE_CODE IN CENTORD)).Store Code. );


A couple of things to notice:

CENTORD and CAR both work for me under 5.32, Windows XP. That has been pretty stable for some time now.

• Note that in my code there are extra parenthesis. That might do the trick.
  
• Also, there are TWO STORE_CODE fields in the database; make sure they match.
  

Does that help?

Yes the extra parenthesis...was the trick.

Thanks,