Click here to Skip to main content
12,071,956 members (54,623 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB SQL-Server ADO.NET , +
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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 26 Mar 2013
Copyright © CodeProject, 1999-2016
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