Xcelsius-content linking with many prompts

other Xcelsius - Crystal Dashboard Design
1

Hi,

Right now in xcelsius, I have a calendar only with the year and month displaying. I did hide the dates with the background. And I have a list box and a push button.

When I select the date,year and the values from the listbox, and the hit the push button only then I want my content linking to happen. That is right now, when I select the date, content linking happens and populates the report. I want it to wait till I select values from all the widgets and only when I hit the push button, it should populate the report.

What are the steps? Please let me know!

Thanks

kbalak3 (BOB member since 2011-06-15)

2

Try to read this blog…

which i read and able to do at the client place.

rizwan syed :us: (BOB member since 2010-07-08)

3

Thanks for the link. I have seen this already but I am not sure how to do it if there are more than one prompt in my query and have like more 2-3 widgets in xcelsius.

Please let me know!

Thanks

kbalak3 (BOB member since 2011-06-15)

4

Hi,

You can insert selected value of all components in excel cell and use push button to insert those cells into cells which is used in URL

bo_user123 :uk: (BOB member since 2010-09-22)

5

Yes I know the idea but I am not getting results when I implement it. Can you please give me the syntax. say there are three prompts like &lsSYear, &lsSDate and &lsSCity, how do I concatenate them. What is the exact syntax?

Thanks

kbalak3 (BOB member since 2011-06-15)

6

Any information on this would really help! Please throw in your inputs.

Thanks!

kbalak3 (BOB member since 2011-06-15)

7

kbalak3,

there are plenty of post already on this topic, refine your search. Here’s the syntax you need to execute your opendoc;

&lsSYear="&A1&"&lsSDate="&A2&"&lsSCity="&A3&"
  1. make sure you operators & operands match EXACTLY
  2. your excel cell (A1, A2, A3 etc) should get highlighted

Also, if certain prompts are executing improperly, you need to check your trigger cells & or component properties & check to make sure you dont have all components on refresh on load.

katullus :us: (BOB member since 2009-08-21)

8

Hi Katullus,

Thanks! But I have a few more questions, Say the following are my three cells A1,A2 and A3

&lsSYear=
&lsSMonth=
&lsSDeptCity=

Each widget has a destination column. Where should I point the 3 destination to?. And the concatenation open doc syntax, where should that be placed at? in A3?

Thanks!

kbalak3 (BOB member since 2011-06-15)

9

I searched quite a bit of posts relating to this topic. But found no proper answers. If someone could post their Xcelsius file involving more than two prompts and the open doc syntax, that would be great!

Thanks.

kbalak3 (BOB member since 2011-06-15)