Filter reportviewer

[petrogeo]

Hi all,

How do I Filter a ReportViewer through a Form?

For example, I would like to choose a Date from a Form and then use this Date to filter the ReportViewer. Do you have any idea?

Many thanks in advance.

[rjv_rnjn]

I assume you want to filter the data in the report (and not the report viewer control). The report viewer is a control that hosts the RDL files. RDL files are where we show the data and do all the formatting. In the scenario you've presented it seems passing the variable as a ReportParameter is the best option and then use this parameter in SP to filter out the data.

[petrogeo]

First, thanks for your cooperation.
I would like to filter by a winform, I have on my report for example:
Group Date1
- 100 kms - $$$ (expenses)
- 120 kms - $$$
Total: 220 kms - $$$

Group Date2 - 120 kms - $$$ expenses
- 200 kms - $$$
Total: 200 kms - $$$

I would like to choose by a windows form the Date number, and display it on the report. Is it possible???????

Best regards in advance.

[rjv_rnjn]

To display anything on the report you need to pass it to the report as its parameter. If you don't want to do the filtering in SP then you can use the filter feature of the dataset. You might like to start here.

[petrogeo]

Thanks, I´ll try to work on it now...