Newbie writing SRS reports

[trav0870]

Hello,
I'm a newbie to writing SRS reports. I've mainly wrote simple queries and even messed around with some very basic SSIS packages. I'm in the process of writing my first SRS report. My issue is with setting parameters...I've built a table to house the choices and I need a way to choose these choices from a drop down. I was told to use charindex to compare these choices...this is where I'm stumped...Anyone have any ideas???

Thanks for the Help!!!
Travis

 

[markros]

Try this forum forum1462

PluralSight Learning Library

 

[SQLSister]

What I do is create a variable for each thing I want to have a pull down menu for. Then create a data set to pull the values. Then in the properties for the variable, you go to available values and set it to get values from query and choose the dataset you created with the query to get the values form your table.

"NOTHING is more important in a database than integrity." ESquared