Load parameter values in managed reporting

April 07, 2005, 06:24 PM

<catelinw>

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

April 07, 2005, 07:47 PM

<Joseph Coule>

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

April 07, 2005, 08:34 PM

<catelinw>

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

Catelin

April 08, 2005, 06:40 PM

Jeff Elam

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.

June 28, 2005, 06:40 PM

Maria Tan

I have the same problem.

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

April 06, 2006, 02:35 AM

Omni

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,

April 06, 2006, 11:43 AM

Francis Mariani

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.

April 06, 2006, 12:46 PM

Tony A

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