afternoon all hope someone can help,

i want to populate a report and print it directly without the user
hitting the print button.

i have this working in a diffrent project but for some reason it wont work in this one.

i get the error missing parameter, on the last line of my code
hope someone can help

Dim paramFields As New ParameterFields
    Dim paramField As New ParameterField
    Dim discreteVal As New ParameterDiscreteValue
    Private Sub IndlabelRep_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim rpt As New IndLabel() 'The report you created.
        Dim myConnection As SqlConnection
        Dim MyCommand As New SqlCommand()
        Dim myDA As New SqlDataAdapter()
        Dim myDS As New DataSet1() 'The DataSet you created


        paramField.ParameterFieldName = "BatchID"
        discreteVal.Value = indPrintIDV
        paramField.CurrentValues.Add(discreteVal)
        paramFields.Add(paramField)


        Try
            myConnection = New SqlConnection("Data Source=" & serverV & ";Initial Catalog=" & DatabaseV & ";Persist Security Info=True;User ID=" & UsernameV & ";Password=" & PasswordV & "")
            MyCommand.Connection = myConnection
            MyCommand.CommandText = "SELECT * FROM BatchDetail"
            MyCommand.CommandType = CommandType.Text
            myDA.SelectCommand = MyCommand
            myDA.Fill(myDS, "BatchDetail")

            rpt.SetDataSource(myDS)
            CrystalReportViewer1.ParameterFieldInfo = paramFields

            CrystalReportViewer1.ReportSource = rpt



            
        Catch Excep As Exception
            


        End Try
        rpt.PrintOptions.PrinterName = "HP Officejet Pro K850 Series"
        rpt.PrintToPrinter(1, False, 0, 0)
This article has been dead for over six months. Start a new discussion instead.