Print Page | Close Window

problems with paramaters

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17577
Printed Date: 06 Apr 2025 at 5:08am


Topic: problems with paramaters
Posted By: marcstrong
Subject: problems with paramaters
Date Posted: 16 Sep 2012 at 8:01pm
Hi

I'm completing a tutorial recommended by another user.
I have entered the following code in my project:

Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports System.Collections

Public Class Form1
    Private customersByCityReport As CustomerByCity
    Private Const PARAMETER_FIELD_NAME As String = "City"
  

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ConfigureCrystalReports()
    End Sub

    Private Sub ConfigureCrystalReports()
        Dim myArrayList As ArrayList = New ArrayList()
        myArrayList.Add("Paris")
        myArrayList.Add("Tokyo")
        SetCurrentValuesForParameterField(customersByCityReport, myArrayList)
        customersByCityReport = New CustomerByCity
        myCrystalReportViewer.ReportSource = customersByCityReport
    End Sub

    Private Sub SetCurrentValuesForParameterField(ByVal myReportDocument As ReportDocument, ByVal myArrayList As ArrayList)
        Dim currentParameterValues As ParameterValues = New ParameterValues()
       
        For Each submittedValue As Object In myArrayList
            Dim myParameterDiscreteValue As ParameterDiscreteValue = New ParameterDiscreteValue()
            myParameterDiscreteValue.Value = submittedValue.ToString()
            currentParameterValues.Add(myParameterDiscreteValue)
        Next
        Dim myParameterFieldDefinitions As ParameterFieldDefinitions = myReportDocument.DataDefinition.ParameterFields
        Dim myParameterFieldDefinition As ParameterFieldDefinition = myParameterFieldDefinitions(PARAMETER_FIELD_NAME)
        myParameterFieldDefinition.ApplyCurrentValues(currentParameterValues)
    End Sub


End Class

However, when I run the message the line in red causes the error message: object reference not set to instance of an object

Can anyone help?

Thanks


Replies:
Posted By: hilfy
Date Posted: 17 Sep 2012 at 4:29am
Try changing this:
 
myReportDocument.DataDefinition.ParameterFields
 
to this:
 
myReportDocument.ParameterFields
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: marcstrong
Date Posted: 17 Sep 2012 at 7:41am
Hi Del

I tried doing that but got the following error message:

Value of type 'CrystalDecisions.Shared.ParameterFields' cannot be converted to 'CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions'.    


Posted By: hilfy
Date Posted: 17 Sep 2012 at 8:08am
I work in C#, so I don't have any VB.NET samples, but here's what I do to set the parameters:
 
myRpt.ParameterFields["MyParam"].AllowCustomValues = true;
myRpt.ParameterFields["MyParam"].CurrentValues.Clear();
myRpt.ParameterFields["MyParam"].CurrentValues.AddValue(myValue);
 
I only use the parameter definition stuff when I'm scheduling a report that's in BusinessObjects and I'm dealing with a Report object instead of a ReportDocument object.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window