when I use the managed reporting to create a paramater that load data in a list bix, but when I run the report, the data in list box look different, it seems there are space between values.

I am new to webfocus/ developer studio,thanks for the help.

Catelin

Catelin,

Are you trying to create a parameter that dynamically looks up the values? If so, you will likely need to incorporate the FEX into a launch page using the resource layout.

The way MR handles (static) parameters is slightly different than dynamic parameters.

Thnaks , I will try it.

Problems I have with resource layout are :
1. I can print whole page very well the last line of the report always got cut off.

2. when use dynamic, I checked the resource button. after I input parameters for for couple times, the data loaded in the list box(or drop down box) are gone, I have to report run the report, it won't allow me to put parameters again and again.

Thanks,
Catelin

Can you post the FEX of the report that contains the parameters. Also, what versions of WebFOCUS are you using?

Webfocus 5.3.2 . Thanks

-* Default Mode: ResourceLayout
DEFINE FILE P21_VIEW_OPENORDER_CEM
name/A50=FIRST_NAME | ' ' | LAST_NAME;
Profit/D12.2%=((CC_TOTAL_PRICE - CC_ESTIMATED_COST) / CC_TOTAL_PRICE) *100;
END
SET EMPTYREPORT = ON

TABLE FILE P21_VIEW_OPENORDER_CEM
PRINT
ORDER_NO AS 'Order No'
ORDER_DATE/HMDY AS 'Date'
CUSTOMER_ID AS 'Cust'
ADDRNAME AS ' '
NAME AS 'Taker'
LOCATION_ID AS 'Location'
name AS 'Sales Rep'
CC_LINES AS 'Line Item'
CC_TOTAL_PRICE/F9.2 AS 'Total Value'
CC_OPEN_VALUE/F9.2 AS 'Open Value'
CC_ESTIMATED_COST/F9.2 AS 'Est Cost'
Profit
VALIDATION_STATUS AS 'Status'
PDA_ORDER AS 'PDA Order'
HEADING
" "
" Order Report By Location"
" "
" "
WHERE ( LOCATION_ID EQ &Location.(OR(<60,60>,<65,65>,<400123,400123>).Location. );
WHERE ORDER_DATE GE DT(&OrderDate.Begin Date. ) AND ORDER_DATE LT DT(&EndDate.End Date. );
ON TABLE SET PAGE-NUM OFF
ON TABLE SET FORMULTIPLE ON
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
COLUMN=N12,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N1,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N7,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N8,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N9,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N10,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N11,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N13,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N14,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N3,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N2,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N4,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N5,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=DATA,
COLUMN=N6,
FONT='ARIAL',
SIZE=7,
BACKCOLOR=( RGB(204 255 255) 'WHITE' ),
STYLE=-UNDERLINE,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N12,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N1,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N7,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N8,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N9,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N10,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N11,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N13,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N14,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N2,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N4,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N5,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TITLE,
COLUMN=N6,
FONT='ARIAL',
SIZE=8,
STYLE=BOLD+UNDERLINE,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=4,
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,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
ON TABLE HOLD AS ITEM1 FORMAT HTMTABLE
END
-HTMLFORM openorderrlp

Well, the first thing that comes to mind that if you are trying to "dynamically" populate the list with values, the syntax is wrong.

Note this:

-* File Dynamic_Launch
-* Default Mode: ResourceLayout
-* File Dynamic_List.fex
-* File Dynamic_List.fex
TABLE FILE CAR
SUM
SALES
BY
COUNTRY
WHERE ( COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY IN CAR)).Country. );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML

........


The main difference between yours and mine is the WHERE test. Note the FIND command that looks up the values for COUNTRY.

Does that help?

Thanks for reply.
In MRE, I couldn't load data to paramer, not mater dynamicly or not. What I dide is , in DATA SERVERS area I created a procedure in resource layour painter, then I created a push button to display the report, all the data loaded correct for the parameter.

It seesm to me therev are bugs to save parameter data in MRE.

Catelin

Any possibility of adding a spell-checker to the forum?

If you can, try to repro the problem using the CAR files that come with the product. If you are able to repro the issue, I would suggest either posting the FEX's here, or better yet, opening a case with IBI.

I have created MANY parameterized applications, both as MRE apps as well as self service apps, with no problems. Note that there may be cases where you cannot create dynamic parameter lists under certain conditions. IBI tech support would be better able to help you with that.

IBI tech support was going to help me with a remote session, I cancelled it since I've made it work right.
I have been struggling with webfocus/developer studio, it seems that something just not working right with my developer studio.