Dynamic Trigger of XML as per request

other Xcelsius - Crystal Dashboard Design
1

Hi All,

I have 3 XML components as:

Region
Product
Agent

I have a label based menu from there he can select Region, Product and Agent.

As per his selection corresponding XML should trigger and data should come into dashboard. I have 3 Different charts for 3 different selection. and I am using dynamic visibility to show accordingly.

But the problem is when I am clicking on any selection two XML runs. This causes performance issue.

Any help.

Rakesh_K :india: (BOB member since 2007-12-11)

2

Are the triggers “on change” or “= a value”

dmanTX :us: (BOB member since 2006-10-30)

3

Are the triggers based on “on change” or “= a value”

dmanTX :us: (BOB member since 2006-10-30)

4

I am getting only two options.
Trigger on Any Insert
Trigger on Any Change

I am not able to see Trigger = Value.

I am using Xcelsius 4.5.

Rakesh_K :india: (BOB member since 2007-12-11)

5

Triggers can sometimes be a pain - and not using 2008 which provides the connection components makes it even more painful. I know the issue you are talking about - fact is, a “change” is also detected when resetting the value back to it’s original state - hence the two queries running when a selection is made.

In this instance, I’d use a seperate web service return for my selection. Something like returning the datetime from the database in number format ddmmHHss and use a max() function to determine the actual selection. Kinda gimpy but it’s all smoke and mirrors when you’re done anyway…

dmanTX :us: (BOB member since 2006-10-30)