I am new to Xcelsius and i have got a requirement like, there should be drop down list which comtains the employee ID’s and beside to it i need to display the employee details in a table probably Ename, Emp id, Sal. and his contact details in another table.
when user selects a particular employee ID from teh drop down list, teh 2 tables should get changed.
i am not sure how to do this. Will it be possible that through one list box monitoring two tables depending on the value selected in taht list box ? or probably by using a user input textbox ? Please help me on this.
Thanks for the help. But now I am facing an other issue. i.e. In Contact details I have got Multiple rows for Contact Information like Emp can have home address in one row and business address in another row. So when I select the Labels as EMP id’s then the drop down list is showing me teh repeated ID’s. I am not sure how to work with this ?
in the list box properties set the “insertion type” as “filtered rows” after that, set your emp id’s as source data then link the destination to a corresponding cell. that should do it.
but having this, i think you might have a problem since you said that you have multiple address in one employee. let’s say like this:
emp id | address
a1|abc
a1|def
if you select a1, it will only show the first value for the address, like this:
a1|abc
but i hope this won’t be a problem in your requirement.
Thanks for the help, but i want both the address rows to be fetched when they selects “a1”.
and also If anyone can explains me on how to take a user input from the xcelsius and pass it to live office and then to BO to get the required result, that would really helps me. For example i have an Agent ID, and a report on it from BO. I am using a combination of Liveoffice and Xcelsius to present this to user. I have 150000 Agnet ID’s. what I want is when user enters an AgentID on Xcelsius presentaion, it should pick the information related to it.
no offense, i think you should start reading and doing some research on your own. as Andrea’s says, “put in some elbow grease and do a search 8)” here are some useful links:
(BOB member since 2008-06-06)
(BOB member since 2008-10-28)
(BOB member since 2009-06-08)
(BOB member since 2008-10-28)