Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Dynamic List of Values
Go
New
Search
Notify
Tools
Reply
  
Dynamic List of Values
 Login/Join
 
Gold member
posted
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?
 
Posts: 62 | Location: New York City | Registered: December 29, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 391 | Location: California | Registered: April 14, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
In fact, I tried your code, and it works for me.
 
Posts: 391 | Location: California | Registered: April 14, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
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.
 
Posts: 62 | Location: New York City | Registered: December 29, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
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.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I'm having the same results with 5.3.2. Do we know if this is a bug??
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
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?
  •  
    Posts: 55 | Registered: May 22, 2003Reply With QuoteReport This Post
    Gold member
    posted Hide Post
    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?
     
    Posts: 55 | Registered: May 22, 2003Reply With QuoteReport This Post
    Virtuoso
    posted Hide Post
    Yes the extra parenthesis...was the trick.

    Thanks,
     
    Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
      Powered by Social Strata  
     

    Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Dynamic List of Values

    Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.