471,338 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,338 software developers and data experts.

Specified Cast is not Valid (Crystal)

Since upgrading to .Net 2003, when I run report reports within an application
using CrystalReportViewer, I'm getting the error "Specified Cast is not
Valid". A value is being passed into the report.
Jul 21 '05 #1
4 2799
Hi Andy,

How are you defining the parameter that you are passing into the report?
Let us see the code.

Bernie Yaeger

"Oldhandandy" <Ol*********@discussions.microsoft.com> wrote in message
news:C5**********************************@microsof t.com...
Since upgrading to .Net 2003, when I run report reports within an
application
using CrystalReportViewer, I'm getting the error "Specified Cast is not
Valid". A value is being passed into the report.

Jul 21 '05 #2
Hi Bernie

I have an opening form, the variable is populated by a combo box. I produce
the report by pressing a button to open the CrystalReportViewer. The report
is generated using a SQL Stored Procuedure.

Module module1

Public div As Integer

End Module
This is code I’ve input in the CrystalReportViewer

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

Dim parameterfields As CrystalDecisions.Shared.ParameterFields
Dim parameterfield As CrystalDecisions.Shared.ParameterField
Dim spvalue As CrystalDecisions.Shared.ParameterDiscreteValue
parameterfields = New CrystalDecisions.Shared.ParameterFields
parameterfield = New CrystalDecisions.Shared.ParameterField
parameterfield.ParameterFieldName = "@div"
spvalue = New CrystalDecisions.Shared.ParameterDiscreteValue
spvalue.Value = div
parameterfield.CurrentValues.Add(spvalue)
parameterfields.Add(parameterfield)
CrystalCountSheets.ParameterFieldInfo = parameterfields

Andy
"Bernie Yaeger" wrote:
Hi Andy,

How are you defining the parameter that you are passing into the report?
Let us see the code.

Bernie Yaeger

"Oldhandandy" <Ol*********@discussions.microsoft.com> wrote in message
news:C5**********************************@microsof t.com...
Since upgrading to .Net 2003, when I run report reports within an
application
using CrystalReportViewer, I'm getting the error "Specified Cast is not
Valid". A value is being passed into the report.


Jul 21 '05 #3
OK; I've got the code - I'll be out of town a few days but I'll take a look
at it when I return.

Bernie

"Oldhandandy" <Ol*********@discussions.microsoft.com> wrote in message
news:92**********************************@microsof t.com...
Hi Bernie

I have an opening form, the variable is populated by a combo box. I
produce
the report by pressing a button to open the CrystalReportViewer. The
report
is generated using a SQL Stored Procuedure.

Module module1

Public div As Integer

End Module
This is code I've input in the CrystalReportViewer

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

Dim parameterfields As CrystalDecisions.Shared.ParameterFields
Dim parameterfield As CrystalDecisions.Shared.ParameterField
Dim spvalue As CrystalDecisions.Shared.ParameterDiscreteValue
parameterfields = New CrystalDecisions.Shared.ParameterFields
parameterfield = New CrystalDecisions.Shared.ParameterField
parameterfield.ParameterFieldName = "@div"
spvalue = New CrystalDecisions.Shared.ParameterDiscreteValue
spvalue.Value = div
parameterfield.CurrentValues.Add(spvalue)
parameterfields.Add(parameterfield)
CrystalCountSheets.ParameterFieldInfo = parameterfields

Andy
"Bernie Yaeger" wrote:
Hi Andy,

How are you defining the parameter that you are passing into the report?
Let us see the code.

Bernie Yaeger

"Oldhandandy" <Ol*********@discussions.microsoft.com> wrote in message
news:C5**********************************@microsof t.com...
> Since upgrading to .Net 2003, when I run report reports within an
> application
> using CrystalReportViewer, I'm getting the error "Specified Cast is not
> Valid". A value is being passed into the report.


Jul 21 '05 #4
Hi Andy,

I could not duplicate your code in a test app because I do not know what
'crystalcountsheets' is.

Let's see if I can help another way. Here's how I pass parameters to a
crystal report through vb .net:
Dim paramFields As New ParameterFields

Dim paramField As New ParameterField

Dim paramField2 As New ParameterField

Case "f:\imcapps\histdeff.rpt"

paramField.ParameterFieldName = "pstartbox" ' the name of one parameter in
the report

paramField2.ParameterFieldName = "pendbox" ' the name of one parameter in
the report

discreteVal.Value = Me.mmcomment1

discreteVal2.Value = Me.mmcomment2

paramField.CurrentValues.Add(discreteVal)

paramField2.CurrentValues.Add(discreteVal2)

paramFields.Add(paramField)

paramFields.Add(paramField2)

CrystalReportViewer1.ParameterFieldInfo = paramFields

connectionchange()

I first assign the two parameter names in the report to a parameterfield
variable. I then assign values to discreteval and discreteval2. I then
make those the currentvalues of the parameter variables; then they are added
to the parameterfields collection; finally, I add the parameterfields
collection to the viewer's parameterfieldinfo. Connectionchange() simply
changes pwds, logins, etc and run the report document object.

HTH,

Bernie

"Bernie Yaeger" <be*****@cherwellinc.com> wrote in message
news:e6*************@TK2MSFTNGP09.phx.gbl...
OK; I've got the code - I'll be out of town a few days but I'll take a
look at it when I return.

Bernie

"Oldhandandy" <Ol*********@discussions.microsoft.com> wrote in message
news:92**********************************@microsof t.com...
Hi Bernie

I have an opening form, the variable is populated by a combo box. I
produce
the report by pressing a button to open the CrystalReportViewer. The
report
is generated using a SQL Stored Procuedure.

Module module1

Public div As Integer

End Module
This is code I've input in the CrystalReportViewer

#Region " Windows Form Designer generated code "

Public Sub New()
MyBase.New()

'This call is required by the Windows Form Designer.
InitializeComponent()

'Add any initialization after the InitializeComponent() call

Dim parameterfields As CrystalDecisions.Shared.ParameterFields
Dim parameterfield As CrystalDecisions.Shared.ParameterField
Dim spvalue As CrystalDecisions.Shared.ParameterDiscreteValue
parameterfields = New CrystalDecisions.Shared.ParameterFields
parameterfield = New CrystalDecisions.Shared.ParameterField
parameterfield.ParameterFieldName = "@div"
spvalue = New CrystalDecisions.Shared.ParameterDiscreteValue
spvalue.Value = div
parameterfield.CurrentValues.Add(spvalue)
parameterfields.Add(parameterfield)
CrystalCountSheets.ParameterFieldInfo = parameterfields

Andy
"Bernie Yaeger" wrote:
Hi Andy,

How are you defining the parameter that you are passing into the report?
Let us see the code.

Bernie Yaeger

"Oldhandandy" <Ol*********@discussions.microsoft.com> wrote in message
news:C5**********************************@microsof t.com...
> Since upgrading to .Net 2003, when I run report reports within an
> application
> using CrystalReportViewer, I'm getting the error "Specified Cast is
> not
> Valid". A value is being passed into the report.


Jul 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Omavlana | last post: by
3 posts views Thread by PK9 | last post: by
3 posts views Thread by VB Programmer | last post: by
reply views Thread by Alan Z. Scharf | last post: by
4 posts views Thread by Oldhandandy | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.