Filtering data on a report
-
I'm using a table in the report design to display child records on a report. The data table the report table is using has many records in it, however, I only want the report table to display certain records from this data table. How can I go about doing this? Thanks for any help on this matter.
-
I'm using a table in the report design to display child records on a report. The data table the report table is using has many records in it, however, I only want the report table to display certain records from this data table. How can I go about doing this? Thanks for any help on this matter.
hi, have you tried using a dataview? you can create a dataview and link that to the datatable. set the rowfilter property of the dataview.
example dim DV as new dataview DV.table = MyTable DV.rowfilter = " field1 = 'something'"you can assigne simple criteria to the rowfilter property. then you can set the reports datasource to the viewMyReport.setdatasource(DV)hence the new report source will have a filtered set of record.U Xux
-
hi, have you tried using a dataview? you can create a dataview and link that to the datatable. set the rowfilter property of the dataview.
example dim DV as new dataview DV.table = MyTable DV.rowfilter = " field1 = 'something'"you can assigne simple criteria to the rowfilter property. then you can set the reports datasource to the viewMyReport.setdatasource(DV)hence the new report source will have a filtered set of record.U Xux
No I have not. I'm using the reportviewer control. My report has 2 datasources. Would adding a third one work? Also in the Init of the form with the reportviewer control I tried using the bindingsource.filter but it does not seem to work. All I want to do on my report is list the persons name along with all of the detail records that are related to that name. Thanks for any help you can provide.