Pass where clause to Reporting Services dataset

[plsh]

Hi there,

Does anyone know how to or if it is possible to pass a where clause as a parameter to a dataset for a Reporting Services report? I have a case where depending on what is selected the where clause needs to be based on a different fields. Or otherwise if an if statement can be used in the dataset to overcome this problem.

Thanks

 

[Nuovo2004]

Not sure if I totally understand your question yet, but there is a filter property that can be assigned to a dataset that works like a where clause.
If this isn't helpful, elaborate a bit on what you're trying to do

 

[plsh]

Hi Nuovo2004,

Sorry about being so unclear. I have actually managed to sort the problem out, passing parameters and using some if statements in my dataset. Thank you though, sorry for the inconvenience.

 

[Nuovo2004]

Nothing inconvenient in posting your questions on this site. I encourage you to post more reporting services questions so they can start a separate forum soon.