Load parameter values in managed reporting

I have posted these questions before and did not get answer, so I posted again.

In managed reporting, I was trying to create a new procedure which load parameter values in to a listbox , so users can pick one or more value from the list box, but for some reasons the values I put in the list box looked strange. both dynamic or static did not work right.I could make report work good on the Data Servers /application area. when I copy the procedure to managed reporting /standar report , the parameter with loaded data looked strange again.

I also like users have options to pick ALL from the listbox,In Report Layout Painter, I check dynamic , added 'ALL' in the listbox, but after I run the report once, going back to put parameters again, the list box became empty, no data there to pick.

Thanks for the help.

Catelin

posted

Yo, Catelin,

This forum is for users helping out other users. If none of us happens to have answers to your question, you might not get a response. Asking again isn't necessarily going to help anything.

Some IBI people monitor the forum but nothing "official" so if this is impacting development of a production app, your best off opening a case with IBI tech support.

Their web site is here: http://techsupport.informationbuilders.com

phone number is 800-736-6130.

Be ready with your site code becuz you won't make it past the guards w/o it.

JC

posted

Thanks, I am going to open a case, it is like a bug there to load parameter values.

Catelin

Jeff Elam

Silver Member

posted

Hide Post

Catelin, I've seen a similar problem with 533. Can't get dropdowns to work in MRE. They work fine outside of MRE. I've reported it and IBI is investigating.

Posts: 44 | Location: St. Louis | Registered: September 17, 2004

Ignored post by Jeff Elam posted

Show Post

Maria Tan

Gold member

posted

Hide Post

I have the same problem.

The workaround is to edit fex file and delete the special character ">".

Posts: 52 | Registered: June 28, 2005

Ignored post by Maria Tan posted

Show Post

Omni

Member

posted

Hide Post

I think I got similiar problem:

I've created procedure with dynamic lists which let user pick parametres, it works fine!

BUT, the problem appeared when I imported the procedure to html launch page - dynamic lists load empty (however static lists worked well)!

when I shared my procedure with my colegue, the same launch page worked well on his computer.

I am not advanced user of WF, but I can swear dynamic lists used to work on my machine before...

The assigned mas file is from ODBC ASA datasource.

any updates on this problem?..

fex file:

 
-* File regionai.fex
TABLE FILE REGION
PRINT
     REGIONID
     REGIONTITLE
WHERE REGIONID EQ '&XREGID.(FIND REGIONID IN REGION).Regiono ID.';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML

Launch page html:

 <HTML>
<HEAD>
<TITLE>HtmlPage
</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
function button1_OnClick(ctrl) {
// TODO: add validation code here
OnExecute(ctrl)
}
</SCRIPT>
</HEAD>
<BODY>
<IFRAME id=report1 title=regionai.fex style="Z-INDEX: 1; LEFT: 20px; WIDTH: 580px; POSITION: absolute; TOP: 168px; HEIGHT: 260px" tabIndex=1 name=report1 elementtype="2" autoExecute="False" requests_list="0" executebuttonId="button1">
</IFRAME>
<SPAN id=text1 style="Z-INDEX: 2; LEFT: 20px; WIDTH: 102px; POSITION: absolute; TOP: 40px; HEIGHT: 16px" tabIndex=2>Regiono ID 
</SPAN>
<SELECT id=combobox1 style="Z-INDEX: 3; LEFT: 20px; WIDTH: 150px; POSITION: absolute; TOP: 76px" tabIndex=3 name=XREGID sourcetype="typeMaster" datafieldtype="VARCHAR" datatype="1" datasource="REGION.mas" datafield="REGIONID" displayfield="REGIONID" operation="NONE" accept="0" addalloption="0" labelid="text1">
</SELECT> 
<INPUT language=javascript id=button1 style="Z-INDEX: 4; LEFT: 20px; WIDTH: 120px; POSITION: absolute; TOP: 118px; HEIGHT: 30px" onclick=button1_OnClick(this) tabIndex=4 type=button value="Run report1" name=button1 requests_list="0"> 
<xml id=ibi_requests>
<requests>
	
<request requestid="0" targettype="0" targetname="report1" sourcetype="typeFex" ibif_ex="regionai.fex" ibic_server="EDASERVE" ibiapp_app="LBFINANCE baseapp">
		
<variables>
			
<variable field="REGIONID" file="REGION.mas" desc="Regiono ID" datatype="1" operation="" name="XREGID" accept="0" type="unresolved" select="0"> 
</variable>
</variables>
	
</request>
</requests>
</xml>
</BODY>
</HTML>

This message has been edited. Last edited by: Omni,

WF 7.1. Excel 2k, Excel Pivot, HTML

Posts: 9 | Location: Vilnius, Lithuania | Registered: August 12, 2005

Ignored post by Omni posted

Show Post

Francis Mariani

Expert

posted

Hide Post

My solution to all this is to not use Dev Studio to create your HTML launch page and dynamic lists.

This of course means you need to know HTML and JavaScript, but you have more control how the dynamic lists are built and how the html page behaves.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Tony A

Expert

posted

Hide Post

Catelin,

Edit your HTML and check out the attributes for the SELECT control. Do you have IBIC_server, IBIAPP_app and/or IBIF_ex specified in there?

When you develop in Dev Studio, these attributes get added and are not used in MRE. The IBIAPP_app is the main culprit, escpecially if the APP in which you develop is not in the APP PATH.

Post your HTML code (between a pair of tags - [ code ] and [ /code ] without the spaces), but split it over several lines otherwise MaryEllen gets a call due to line length(?). We'll (the Forum) see if we can assist you then.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Tony A

Expert

posted

Hide Post

Omni,

Is your master file in your APP PATH? and what version are you running?

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Omni

Member

posted

Hide Post

quote:
Originally posted by Tony A:
Omni,

Is your master file in your APP PATH? and what version are you running?

T

all files, including procedure and mas file physically are located in the same app folder.

I am running WF 7.1

edited: I solved my problem by reinstalling WF.

This message has been edited. Last edited by: Omni,

WF 7.1. Excel 2k, Excel Pivot, HTML

Posts: 9 | Location: Vilnius, Lithuania | Registered: August 12, 2005

Ignored post by Omni posted

Show Post

TexasStingray

Master

posted

Hide Post

I could be wrong, but if you are populating a drop-down from a procedure I think the procedure has to be in MRE if the Layout page is in MRE.

Scott