Skip to Content
0
Former Member
Jan 11, 2007 at 09:09 PM

Tie Multiple Characteristics to Inputed Values in Variable entry screen?

30 Views

I am writing a report against a custom product that has an unknown amount of characteristics to it. The characteristics describe the attributes and parts required to construct the product.

For example: product is a car. The characteristics can include color, model, weight, year, lighting, tires, etc.

In the report, I will need to allow the user to select any number of characteristics and assign values. They could do the following:

Characteristics:

weight

length

price

tires

Then they could enter in the Characteristic values they want the report to run against.

Characteristic values:

2000

15

24500

Firestone

What this means is this:

weight = 2000

length = 15

price = 24500

tires = Firestone

I **never** know what characteristics they will enter, and I have to trust they enter the values in the proper order to match the characteristics they entered.

My problem is now the query will run like this

Select * FROM Cube

Where (Characteristic = weight OR length OR price OR tires)

AND (Characteristic value = 2000 OR 15 OR 24500 OR Firestone)

What I'd like the query to do is this

Select * FROM Cube

Where (weight = 2000) OR (length = 15) OR (price = 24500) OR (tires Firestone)

That's just pseudo code, don't delve to much in to the SQL statements. It's just an example of what I'm trying to do.

Does anyone have a suggestion?