BusinessObjects Board

Passing Query Prompt Selector Prompts from Excel

other Xcelsius - Crystal Dashboard Design
#1

I currently have a query prompt selector which works fine, allows a user to select a year from the drop down and will update a table with the relevant sales data.

What i want to do is swap the query prompt selector for a push button control.

So that when a user clicks the ‘2013’ button, 2013 is provided to the query and the data updates. I’m able to get the button to pass the date to the excel worksheet but it’s getting the query selector (or query itself) bound to this field.

Any ideas how this could be done? And if it can’t be done directly anyone know of a creative work around?

Thanks

Hagbard (BOB member since 2013-09-23)

#2

I’m not sure of what is your problem, but in the query panel there should be the option to bound a prompt to a cell.

Then you have to put in the query that it has to reload each time your cell is changed. Or you can put an invisible reload query button linked to that cell.

Fratty (BOB member since 2013-06-25)

#3

Thanks for the reply.

This is what i’ve tried doing but just won’t work

I have a Radio Button selector at the moment with each year listed. The Destination is cell A4 (i have a text label linked and it shows the selected year so i know the year is being passed to the worksheet).

My prompt (in the Query Browser) has Selected Values linked to cell A4 and i have a spreadsheet table linked to the display data (which should change when a user selects a year). I have the query set to trigger when cell A4 is changed. But the display data remains unchanged.

Still no luck, not sure what i’m missing.

Thanks

Hagbard (BOB member since 2013-09-23)

#4

Did you check if the data in A4 changes?

edit: I’m sorry I missread, you said that the cell A4 is loaded.
Dunno, it is weird. Have you tried to bound the query prompt to a cell that is pre-loaded? Does the query works?

Fratty (BOB member since 2013-06-25)

#5

Yeah i have a label bound to that cell, when i change the selection on the radio buttons the label updates on the screen to show the date so i know the date is being passed to the cell, just not picked up by the query.

Edit: Yeah i’ve tried typing in a date and binding the query to that but just nothing. The query works but just returns all data instead of the sales in the selected year.

Edit: Unbelievably - it was working, but it literally takes 10 minutes to refresh the data in the spreadsheet. So now just got to work out how to add a loading component and try to cut down the query.

Thanks for your help anyway!

Hagbard (BOB member since 2013-09-23)

#6

can you try the SAP Netweaver BW connection…rather than the query browser. I had the same issue.

kraf (BOB member since 2013-06-25)