Hi thanks for taking a look.

I need some insight into MS Report Viewer and how I can make it work for what I need. I have looked and trawled through many articles but still cant make it work.

-----
I have a form, on it I have added Report Viwer component. I select 'Design New Report' from Reportviewer tasks. I use the wizard to create a basic report by selecting all fields in my payments table from sql.
I tell report viwer to use the newly created report and VS adds the dataset, table adapter and binding source for me. when i run it, it displays all the records from the payments table. All ok.

Now i want to know how to modify/create a report so as to filter the data to only show payments from a certain MemberID. MemberID is also a field in the payments table.

Do I need to filter the datatable, binding source or table adapter?
I keep reading about passing a parameter to the report but am not sure how to do this? I noticed i can change the query the table adapter is using to a custom one, is this the correct way to go?

My end aim is to have a textbox on my form, user enters the memberID, presses search, and up pops a report with only payments from that member.

Any help would be greatly appreciated as I have admitted defeat on my own strengths. One example, step by step would be enough to get me going.


Thanks again!