I Have a Report Parameter (single Value)@Path. The Available Values for @Path are from a Dataset.
The Values are like this. \a1\b1 , \a1\b1\c1, \a1\b2, \a1\b2\c1. Now if i select the value \a1\b1 , i will get all of the values for under the path \a1\b1. ie., it selects '\a1\b1%'. The Main dataset of the report has
the query like this. Select Col1,Col2 WHERE path = '@Path+'%' It works fine until now.
Now I want to make this Parameter to select multiple values. So I changed the Properties of the Parameter and the SQL like Select Col1,Col2 Where path IN (@Path). This works fine as i can select multiple values
\a1\b1 and \a1\b2 and also i can get the result correctly covering these two paths. But the problem is , i want to cover the total sub paths also. So if i select \a1\b1 and \a1\b2 i should get the result covering \a1\b1\c1 and \a1\b2\c1 also.
View Complete Post