[RESOLVED] Pass params to MS Report from VB.NET, how to add condition to Query based on a Param?

[jcis]

I did this to pass a param to a Report, the report is inside a ReportViewer and it's created using a Dataset, this Dataset connects to a MSACCESS 2007 db using a view (query) in Access.

The link shows how to send params to a Report, but i need to do something else inside the report to make it only select rows where <SomeFieldName> = <@myParamName>. The idea is simply giving the user the ability to set some conditions before running the report, how can i do this using MS Report 2010?

[kleinma]

jcis,

Since you are hooking up the report to a dataset, I will assume you are using a Table or Matrix object to display the dataset data?

If so then all you would need to do is go into the properties of the table or matrix that your dataset is bound to on the report, and go to the filters tab. You can add a filter expression there which will allow you to select the column in your dataset to filter on, and allow an expression to be set using the expression builder. You can just sedt the operator to = and the Value just needs to be [@YourParam]

Like this:

[jcis]

Thank you very much Keinma, solved