Refresh Xcelsius report data based on the trigger cell

other Xcelsius - Crystal Dashboard Design
1

Hi,

I have an Xcelsius 2008 report which usines 7 queries(QaaWS) as the datasource. The output of all the 7 queries is re-directed to the same set of cells in the excel sheet. I need to pass a flash variable as input to the Xcelsius report, based on which only ONE of the 7 queries will be fired. Hence the excel would only contain the data for one of the queries, depending on the flash variable that i have passed.

For all the 7 queries, I cannot check the “Refresh on Load” option, as i DO NOT want the queries to refresh on load, instead i want them only to be refreshed/triggered based on the flash variable that i pass.
The problem i am facing is: Since i have not checked the “Refresh on Load” option, none of the queries are getting refreshed while the report loads. Hence the report shows NO Data. I have given a trigger cell for all 7 queries, saying that when the Trigger cell becomes 1, load Query 1; when it becomes 2, load query 2, etc etc…
How can i overcome this issue and load the report based on the variable that i pass. I do not want to use any filters/drop down boxes in the report. I need to achieve this by passing a flash variable only.
Please help asap.

Thanks,
Fathima.

Fathima (BOB member since 2009-04-06)

2

Hi,

Try using a tool called Fiddler to see what is being passed to your queries during run time.

You can download it here - http://www.fiddler2.com/Fiddler2/version.asp

Just install and run before previewing your .swf and then take a look at the ‘Text Version’ on the right to see what is really going in and out of your .swf.

It is a techie, nerdy tool but it may provide some insight as to what is going on.

Also, make you are at least on Service Pack 1 Fix Pack 2 for Xcelsius 2008.

EverythingXcelsius :us: (BOB member since 2008-06-17)