Andrew2009
Well Known Member
Here are my fields
Car, Brand, Color, Units
Here's my data. I have max of 6 records
1) Honda, Civic, White, 1
2) Honda, Civic, Black, 2
3) Honda, Civic, Silver, 3
4) Honda, Civic, Green, 4
5) Honda, Civic, Blue, 5
6) Honda, Civic, Gray, 6
As you can see, Car and Model fields are the same. The only differences are Color and Units. I'm planning to have 4 "Set User Selection" statements for each record (24 total). I don't know if there's a limit to number of conditions in data selection or not. For example
Car Equal Honda And
Brand Equal Civic And
Color Equal White And
Units Equal 1 OR
Car Equal Honda And
Brand Equal Civic And
Color Equal Black And
Units Equal 2 OR
Car Equal Honda And
Brand Equal Civic And
Color Equal Silver And
Units Equal 3 OR
etc....
The last record will end with None instead of OR since it's the last one.
Basically I want to return all those 6 records from a business view in a UBE using those criteria. Do you have a better way to do it? I have to use Set User Selection in my report because those data were passed in dynamically.
Thanks
Car, Brand, Color, Units
Here's my data. I have max of 6 records
1) Honda, Civic, White, 1
2) Honda, Civic, Black, 2
3) Honda, Civic, Silver, 3
4) Honda, Civic, Green, 4
5) Honda, Civic, Blue, 5
6) Honda, Civic, Gray, 6
As you can see, Car and Model fields are the same. The only differences are Color and Units. I'm planning to have 4 "Set User Selection" statements for each record (24 total). I don't know if there's a limit to number of conditions in data selection or not. For example
Car Equal Honda And
Brand Equal Civic And
Color Equal White And
Units Equal 1 OR
Car Equal Honda And
Brand Equal Civic And
Color Equal Black And
Units Equal 2 OR
Car Equal Honda And
Brand Equal Civic And
Color Equal Silver And
Units Equal 3 OR
etc....
The last record will end with None instead of OR since it's the last one.
Basically I want to return all those 6 records from a business view in a UBE using those criteria. Do you have a better way to do it? I have to use Set User Selection in my report because those data were passed in dynamically.
Thanks
Last edited: