Re: Help with Report Viewer
When I did this, I filtered on the bindingsource. I was not using datasets, I was using LINQ2SQL, but I don't see why the same would not apply. That isn't to say you can't filter somewhere else along the line, but filtering the bindingsource should work for you.
Re: Help with Report Viewer
kleinma am assuming your talking about using the filter property of the binding source. i tried to create an expression but it didnt see to work.
can you give me example expression for displaying only memberID matching a given input from user. how would i make it dynamic at runtime i.e. memberID supplied at runtime from textbox into the expression???
---------
alternativily i been trying to filter using queries. i.e. supply the table adapter with filtering query using dynamic values supplied at runtime.
Code:
Dim attendanceTable As DataTable
Public Function PopulateQueryData(ByVal memberID1In As Integer, ByVal memberID2In As Integer, ByVal dateStartIn As Date, ByVal dateEndIn As Date)
attendanceTable = AttendancesTableAdapter.GetAttendanceNoTypeReport(memberID1In, memberID2In, dateStartIn, dateEndIn)
Me.AttendancesTableAdapter.Fill(attendanceTable)
Me.ReportViewer1.RefreshReport()
End Function
The above method returns a data table, using query that filters between 2 member id's and date range. I know the query is ok as ive tested it but the the report viewer does not display any records. I have stopped execution and can see just before i refresh the reportviwer, attendanceTable has the correct rows in store.
Can anyone see what am doing wrong. am guessing something to do with the fill method of the adapter.
Thanks in advance
Re: Help with Report Viewer
No in my situation I was setting the binding source to an already filtered table of my data.
Re: Help with Report Viewer
anyone else with any insight can help? :sick:
or can someone point me to a decent article on report building for begginers? how do the rest of you make reports with .net??? crystal? :confused: