Hi all,
I’m building a dashboard using Xcelsius 2008 SP1.
I need to select multiple values from a column and send the resultset to a new table.
So, I know that I can use the “list builder” component, but this component has a limitation, in a few words there’s not a filtered rows option in its property sheet.
Does someone know some workarounds to select multiple values from a column at the same time??
Thanks in advance for your help.
Luca
Luca Spinelli 
(BOB member since 2008-08-27)
Hello Luca,
From what i have understood from your question, i think the below post can help you to get some ideas to play with. Hope this helps:
http://ryangoodman.net/blog/index.php/2008/04/15/using_insert_filtered_rows_in_xcelsius_2008
MyXcelsius 
(BOB member since 2008-07-18)
Hi MyXcelsius…
so I’ve just seen the link you posted, but I’m sorry it can’t help me.
I attached an image in which I show what I need…maybe it’s more clear.
Thank you so much.
Luca - ClearPeaks - www.clearpeaks.com
Luca Spinelli (BOB member since 2008-08-27)
Hello Luca,
Now i understand. Unfortunately the listbox does not pass multiple parameters. I think we need to wait for a custom component from someone. Alternatively you can try and use check boxes, im not sure whether you can acheive what you wanted using that, however its worth a try.
Will update you if i figure out something.
MyXcelsius (BOB member since 2008-07-18)
Hiii,
I’m trying to build this component from scratch but it’s not easy…
Do you have some actionscripts in which there’s a listbox code?? I can extend the code but I don’t have the know-how to build it from scratch…
thank you!!
have a good time!!
Luca - ClearPeaks BI Consultant - www.clearpeaks.com
Luca Spinelli (BOB member since 2008-08-27)
Hi Admin,
I’ve figured out the solution and now I’m working on it. So, the only issue I have is that I cannot use the ChangeWatcher and the ChangeHandler functions if I use a List… so do you know which functions I can use to send my selected Items to my defined excel destination??
Thank you so much!
Luca - ClearPeaks BI Consultant - www.clearpeaks.com
Luca Spinelli (BOB member since 2008-08-27)
Hello Luca,
Its not easy to build a Flex Component unless you have some experience in OO Programming. Specially in AS3 and FLEX. The CX 2008 SDK tutorials gives a good description about the design, however its not going to help if you are a beginner in designing FLEX components. The below link might help you with a source code for a check box list. Checkout the preview and download the source files. Play with it, you might find this helpful. Remember that this is not CX source code, this is only the flex component source code, if you want to make it into a CX component, you need to use CX and FLEX SDKs and also the CX Property Sheet.
http://www.sephiroth.it/file_detail.php?id=151#
MyXcelsius (BOB member since 2008-07-18)
Hi all,
I’m going to finish my multiselect listbox component, but there’s one last issue to solve.
I can establish a comunication from propertysheet to the actionscript but I’m not able to establish a comunication from the actionscript to the propertysheet. In other words, I can change the title and the labels in my listbox, but when I select some labels (one or more), I cannot see them in my destination excel cells. Does someone know the way to fix this??
What’s the right way to send my selectedItems to the excel cells??
Thank you in advance!
Luca - ClearPeaks BI Consultant - www.clearpeaks.com
Luca Spinelli (BOB member since 2008-08-27)
Hello Luca,
Good to know that you already designed your own component. I think you will get a quick response if you post this question on any of the Flex Forums. Below are some of the links:
http://www.nabble.com/Flex-Component-Development-f17526.html
http://vadexfx.com/forumdisplay.php?f=10
http://www.afcomponents.com/forum/
Hope this helps.
MyXcelsius (BOB member since 2008-07-18)
Hi Luca,
I have also run into the problem of passing multiple parametrs from a list box component…could you throw some light in building this component or some references that will help in building something like this…
Thanks
zephyrous (BOB member since 2007-01-12)
Hi Luca,
Do you have any update for the multiselect list box?
vijesh.chandra 
(BOB member since 2009-05-29)