July 27, 2009 at 9:55 am
I have a sales report that has a multi-valued parameter labeled 'State'. It is a non-queried value, but I could create a data set if I need to. I was hoping not to. values are below
label value
IL IL
KS KS
OH OH
MI MI
Territory 1 IL,KS,MI
For Territory 1; the states include IL,KS,MI. how can I create a label and value to reflect this??
I have tried setting the value of label Territory 1 to IL,KS,MI <<>>
In the sql statement I have: State in (@state)
Everthing works if I individually select IL,KS,MI....but not if I select the label "Territory 1"
Any ideas, would be a great help. PLEASE, I am stuck
July 27, 2009 at 10:43 am
Duplicate post. Please reply here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply