Click here to Skip to main content
15,877,857 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hello my friends

how can i filter data from data grid view into my report???
i use table in my report, and i set parameters, by using this code i can show one of my data
(in my data grid view we can search, but if data be a one , or tow or more, this code only show one of them.)

i want to placed this searched data in my data grid view in to my report

thanks alot


VB
'Dim param(0) As ReportParameter
 Dim name(0) As ReportParameter
 Dim fname(0) As ReportParameter
 Dim level(0) As ReportParameter
 Dim from(0) As ReportParameter
 Dim too(0) As ReportParameter
 Dim dur(0) As ReportParameter
 Dim score(0) As ReportParameter
 Dim iss(0) As ReportParameter

 '  param(0) = New ReportParameter("txt", txtrpt.Text)

 name(0) = New ReportParameter("name", TextBox1.Text)
 fname(0) = New ReportParameter("fname", TextBox2.Text)
 level(0) = New ReportParameter("level", TextBox3.Text)
 from(0) = New ReportParameter("from", TextBox4.Text)

 too(0) = New ReportParameter("to", TextBox5.Text)
 dur(0) = New ReportParameter("dur", TextBox6.Text)
 score(0) = New ReportParameter("score", TextBox7.Text)
 iss(0) = New ReportParameter("iss", TextBox8.Text)

 ' Me.rpt3.LocalReport.SetParameters(param)
 Me.rpt3.LocalReport.SetParameters(name)
 Me.rpt3.LocalReport.SetParameters(fname)
 Me.rpt3.LocalReport.SetParameters(level)
 Me.rpt3.LocalReport.SetParameters(from)
 Me.rpt3.LocalReport.SetParameters(too)
 Me.rpt3.LocalReport.SetParameters(dur)
 Me.rpt3.LocalReport.SetParameters(score)
 Me.rpt3.LocalReport.SetParameters(iss)
 Me.rpt3.RefreshReport()
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900