Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Parameters do work right in manager repoting

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Parameters do work right in manager repoting
 Login/Join
 
<catelinw>
posted
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
 
Report This Post
Gold member
posted Hide Post
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.
 
Posts: 55 | Registered: May 22, 2003Report This Post
<catelinw>
posted
Thnaks , I will try it.
 
Report This Post
<catelinw>
posted
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
 
Report This Post
Gold member
posted Hide Post
Can you post the FEX of the report that contains the parameters. Also, what versions of WebFOCUS are you using?
 
Posts: 55 | Registered: May 22, 2003Report This Post
<catelinw>
posted
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>Wink).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
 
Report This Post
Gold member
posted Hide Post
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?
 
Posts: 55 | Registered: May 22, 2003Report This Post
<catelinw>
posted
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
 
Report This Post
<Pietro De Santis>
posted
Any possibility of adding a spell-checker to the forum? Smiler
 
Report This Post
Gold member
posted Hide Post
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.
 
Posts: 55 | Registered: May 22, 2003Report This Post
<catelinw>
posted
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.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Parameters do work right in manager repoting

Copyright © 1996-2020 Information Builders