[SOLVED] Intermittent issue with Composer "Move Items" Control Button

Hi Tansy,

From our technicals: A listbox does not have up and down arrows unless using the Double Listbox. Please open a case for this issue and we can research it. You may have called functions in the ibirls3.js files which you should not do but will need more info to see what you are doing. To open a case, please contact Customer Support Services at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

Kerry Zhan
Focal Point Moderator
Information Builders, Inc.

Posts: 1948 | Location: New York | Registered: November 16, 2004

Ignored post by Kerry posted

Member

posted

With the help of John Kutasz I finally got it to work.

The single listBox does display (on right click)
the option to create a "Move Items" contro. I'm not sure how it got screwed up (it originally worked, but I did move its location on the form a few times, etc.).

John suggested I physically delete the listBox control and then create the "Move Items" control again on the new listBox. He could see that the buttons seemed to be nested at a different level in the DOM than the listBox which was fishy to him. Not wanting to deal with creating and configuring the new control, I first tried just deleting and recreating the "Move Items" control and recreating it. That didn't work, but John's suggestion of a brand new listBox control (as much of a pain as that was due to needing to resetup and fix chaining, etc.) did work perfectly.

Thanks!

WebFOCUS Developer Studio 7702
Windows, all output

Posts: 11 | Registered: November 23, 2011

Ignored post by Tansy posted

David Glick

Guru

posted

Tansy,

I am the Product Manager for Composer, and you can definitely have move items controls for a single listbox. I don't know who told Kerry otherwise. I am glad you got it working.

David Glick
Director WebFOCUS App Studio
and WebFOCUS Developer Studio
WebFOCUS Division
Information Builders, Inc.
Direct (917) 339-5560
Voice Mail (212) 736-6250 x3560
Fax (212) 947-5168
Email david_glick@ibi.com

Posts: 315 | Registered: April 13, 2004

Ignored post by David Glick posted

BarryS

Gold member

posted

Hi

I provided Kerry the information and I must appoligize for not knowing about the "Move Item" control. I am glad that you were able to find a solution. You cannot stop learning the products in WebFOCUS.

Thanks
Barry

WebFOCUS 8103, Windows, App Studio

Posts: 80 | Location: NYC | Registered: November 13, 2008

Ignored post by BarryS posted

Francis Mariani

Expert

posted

Would someone mind explaining how a "Move items" control is used? Page 168 describes what it is (something I've never seen before this thread), but it doesn't really describe what it is used for:

quote:
Select values from the list box and run the report.
4. To reorder the selected values, click the up arrow to move the selected value up in the
list box, or click the down arrow to move the selected value down in the list box.
5. Run the report again to view the results with the selected values.
In the following example, CA is the first value in the By State list box. Select the down
arrow to reorder the location of CA in the list box and rerun the report again.

So, we rearrange options in a list box and rerun the report - what does that do? Does it generate

BY sortfield AS 'coltitle' ROWS value1 [AS 'text1'] 
OVER value2 [AS 'text2']
[... OVER valuen [ AS 'textn']]

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

Member

posted

The "Move Items" control option (right click on a listBox to see it) auto generates an up arrow button and a down arrow button. If, for example you highlight the first item in your list box and press the down arrow the item should move down one level in the list box. The reason I used this is because I am allowing users to choose their own "custom" sort order (BY fields)in my managed report. I am using a multi select listBox... so (this is cool) you can choose multiple items and move them up and down if you want to.

WebFOCUS Developer Studio 7702
Windows, all output

Posts: 11 | Registered: November 23, 2011

Ignored post by Tansy posted

Francis Mariani

Expert

posted

You are

quote:
allowing users to choose their own "custom" sort order

Do you manually code the ROWS and OVER syntax or does the HTML Composer designed page generate the code for you?

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

Member

posted

There could be other ways to do this (I am pretty new to Managed Reporting), but I found that when you bind a Parameter to a multiselect listBox AND mark the Parameter as "MultiSelect AND" or "MultiSelect OR", composer autogenerates the control with a operation attribute equal to "AND" or "OR". This way the composer completely handled my other listBoxes where I allow users to select their "custom" selection criteria. (e.g. Composer is sending the variable parameter to my FEX with the ORs or ANDs automatically).

For the "BY" statement to be generated in the variable BY Parameter passed to the report FEX, I first manually edited the HTML operation to be "BY" (operation="BY"). Then, in my actual FEX I also needed to append a BY to the beginning of the Parameter since the BY is only generated in between the selected fields, not before the first field.

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

WebFOCUS Developer Studio 7702
Windows, all output

Posts: 11 | Registered: November 23, 2011

Ignored post by Tansy posted

Francis Mariani

Expert

posted

Tansy,

Actually, you've given us a very good description of the functionality.

It is MY mistake to assume the ROWS OVER syntax was required here. ROWS OVER is to change the order of the data, not the columns.

I've used double-list boxes for BY columns, where you would automatically have Move Items buttons, but I like this single list box Move Items.

Well done.

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

David Glick

Guru

posted

Tansy,

Multiselect BY is available in the Variable Editor as well and would make your manual edit unnecessary. It is never a good practice to manually edit product generated code since the product may not be able to open the edited file in the UI afterwards.

Posts: 315 | Registered: April 13, 2004

Ignored post by David Glick posted

Member

posted

Great tip!

WebFOCUS Developer Studio 7702
Windows, all output

Posts: 11 | Registered: November 23, 2011

Ignored post by Tansy posted