Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hello,
I have a vb net application connected to an sql sever database, I use a query to search records and display them to a datagridview, I use crystal reports to print, I can't make it print the selected rows of the datagridview, it prints all the result records, how can I pass multiple number values to a crystal report selection formula?
VB
Dim rpt1 As New CrystalReport1()
       rpt1.SetDataSource(DataSet31)
       rpt1.ParameterFields.Item("ID").CurrentValues.AddValue(Me.DataGridView1.SelectedRows(0).Cells(0).Value)
       Form6.CrystalReportViewer1.ReportSource = rpt1
       Form6.Show()

dataset31 the query dataset, rpt1 the crystal report .rpt
even if I add a single value prints all
VB
rpt1.ParameterFields.Item("ID").CurrentValues.AddValue(11)
Posted
Comments
Prasad Khandekar 26-Mar-13 9:24am    
Please have a look at this link. (http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-string-parameter.htm) It provides the necessary information.

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