BusinessObjects Board

Dynamic Query Not Working

other Xcelsius - Crystal Dashboard Design
#1

Hi I would like ask for help with a problem. I have tried to get this to work for the last week without success.

I would like to trigger a query based on the result of a selector. I.e. it would filter the result of the query from input (combo box). So, the query would match all results containing the input value.

I have read that you can do this with prompts but can’t get it to work.

For example the query looks up all car models in the database.

I would like to select the manufacturer, eg ‘Ford’, then run a query from this output, or destination cell, to give me a list of all the models in the inventory.

eg

Select - Ford

Output:

Mondeo - Blue - 2001
Escort - White - 1985
C-Max - Red - 2010
etc.

I have tried to trigger a query using new cell value, and input the data to the query from the cell using a prompt automatically picking up the value from the spreadsheet. However, the value in the prompt never seems to pick up my selection.

Thank you in advance for your help.

WigglyRat (BOB member since 2015-06-22)

#2

To be clear:

You have a combo box with all of the makes listed.
When the user selects a make from the combo box, the value is written to a cell on the spreadsheet.
You have a connection that is triggered when that cell changes.
You have a prompt in the connection that references that cell for its value.
The connection then returns the inventory related to that make.

Things to check for:

Is the combo box actually writing to the correct cell? (The simplest way to tell this is to put a spreadsheet component on your dashboard that displays the value of that cell.)
Is the connection actually firing?
Is the prompt picking up the correct value (Fiddler is the best tool for looking at this)?
Is the connection returning any data at all? Is it returning an error? (Again, use Fiddler.)

Lugh (BOB member since 2009-07-16)