Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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?
 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
rpt1.ParameterFields.Item("ID").CurrentValues.AddValue(11)
Posted 26-Mar-13 0:04am
Comments
Prasad Khandekar at 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)

  Print Answers RSS
0 Kornfeld Eliyahu Peter 275
1 Maciej Los 214
2 Sergey Alexandrovich Kryukov 200
3 King Fisher 185
4 OriginalGriff 163
0 OriginalGriff 6,223
1 DamithSL 4,724
2 Maciej Los 4,196
3 Kornfeld Eliyahu Peter 3,894
4 Sergey Alexandrovich Kryukov 3,496


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 26 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100