Am working on a project in vb.net with sql server as my backend database. I have created a report using component one report c1report. I want to filter data so that only a selected data are display on the report.
What I have tried:
C1Report1.DataSource.RecordSource = "SELECT * from Finance"
C1Report1.DataSource.Filter = "DepartmentId = " + "%" + ComboBox1.Text + "%"