Conversion question

[Chubbly Geezer]

Now I've done this before but can't remember how.

I want to pass a string into a procedure and then use that string in a Dim
statement.

i.e.

Public Function PrintReports(By Val strDel As String, ByVal strSQL As String,
ByVal strSelect As String, ByVal ReportName As Object) As Integer

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
ReportName

But I am getting a conversion error in that I cannot convert a string to
this object type.

Any ideas please.?

Chubbly

[Chris]

Chubbly Geezer wrote:

Now I've done this before but can't remember how.

I want to pass a string into a procedure and then use that string in a Dim
statement.

i.e.

Public Function PrintReports(By Val strDel As String, ByVal strSQL As String,
ByVal strSelect As String, ByVal ReportName As Object) As Integer

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
ReportName

But I am getting a conversion error in that I cannot convert a string to
this object type.

Any ideas please.?

Chubbly

You can not convert a string to a ReportDocument. Now in your function
you are passing an object. What type is this object you are passing in.
Where is your Report stored? Is it a file or an embedded resource?

Chris

[Chubbly Geezer]

"Chris" <[e-mail]> wrote in message
news:Ow******** *****@TK2MSFTNG P14.phx.gbl...

Chubbly Geezer wrote:

Now I've done this before but can't remember how.

I want to pass a string into a procedure and then use that string in a
Dim statement.

i.e.

Public Function PrintReports(By Val strDel As String, ByVal strSQL As
String, ByVal strSelect As String, ByVal ReportName As Object) As Integer

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
ReportName

But I am getting a conversion error in that I cannot convert a string to
this object type.

Any ideas please.?

Chubbly

You can not convert a string to a ReportDocument. Now in your function
you are passing an object. What type is this object you are passing in.
Where is your Report stored? Is it a file or an embedded resource?

Chris

I am passing in a string (was initially declared as a string) which equates
to the report name of rhe report that I want to run. i.e. StandardStateme nt
This relates to StandardStateme nt.rpt which is a crystal report which has
been created and resides in my VB 2005 app.

I realise that I can not convert a string to a ReportDocument but do not
know how to use the strings value the way I want.

I am trying to execute a line as below:

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
StandardStateme nt

I previously used

Dim myReport As StandardStateme nt

but now find I need to pass in the report name.

Thanks

Chubbly

[Chris]

Chubbly Geezer wrote:

"Chris" <[e-mail]> wrote in message
news:Ow******** *****@TK2MSFTNG P14.phx.gbl...

Chubbly Geezer wrote:

Now I've done this before but can't remember how.

I want to pass a string into a procedure and then use that string in a
Dim statement.

i.e.

Public Function PrintReports(By Val strDel As String, ByVal strSQL As
String, ByVal strSelect As String, ByVal ReportName As Object) As Integer

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
ReportName

But I am getting a conversion error in that I cannot convert a string to
this object type.

Any ideas please.?

Chubbly

You can not convert a string to a ReportDocument. Now in your function
you are passing an object. What type is this object you are passing in.
Where is your Report stored? Is it a file or an embedded resource?

Chris

I am passing in a string (was initially declared as a string) which equates
to the report name of rhe report that I want to run. i.e. StandardStateme nt
This relates to StandardStateme nt.rpt which is a crystal report which has
been created and resides in my VB 2005 app.

I realise that I can not convert a string to a ReportDocument but do not
know how to use the strings value the way I want.

I am trying to execute a line as below:

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
StandardStateme nt

I previously used

Dim myReport As StandardStateme nt

but now find I need to pass in the report name.

Thanks

Chubbly

If the string is the report name then you are going about this wrong.

There are two ways I know of to load a report.

1. Get it out of an embedded resource
2. Load it from a file

How I do #2 is:

Dim crReportDocumen t As New
CrystalDecision s.CrystalReport s.Engine.Report Document()

crReportDocumen t.Load(ReportNa me)

Hope this helps
Chris

[Chubbly Geezer]

"Chris" <[e-mail]> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Chubbly Geezer wrote:

"Chris" <[e-mail]> wrote in message
news:Ow******** *****@TK2MSFTNG P14.phx.gbl...

Chubbly Geezer wrote:

Now I've done this before but can't remember how.

I want to pass a string into a procedure and then use that string in a
Dim statement.

i.e.

Public Function PrintReports(By Val strDel As String, ByVal strSQL As
String, ByVal strSelect As String, ByVal ReportName As Object) As
Integer

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
ReportNam e

But I am getting a conversion error in that I cannot convert a string to
this object type.

Any ideas please.?

Chubbly

You can not convert a string to a ReportDocument. Now in your function
you are passing an object. What type is this object you are passing in.
Where is your Report stored? Is it a file or an embedded resource?

Chris

I am passing in a string (was initially declared as a string) which
equates to the report name of rhe report that I want to run. i.e.
StandardStateme nt
This relates to StandardStateme nt.rpt which is a crystal report which has
been created and resides in my VB 2005 app.

I realise that I can not convert a string to a ReportDocument but do not
know how to use the strings value the way I want.

I am trying to execute a line as below:

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
StandardStateme nt

I previously used

Dim myReport As StandardStateme nt

but now find I need to pass in the report name.

Thanks

Chubbly

If the string is the report name then you are going about this wrong.

There are two ways I know of to load a report.

1. Get it out of an embedded resource
2. Load it from a file

How I do #2 is:

Dim crReportDocumen t As New
CrystalDecision s.CrystalReport s.Engine.Report Document()

crReportDocumen t.Load(ReportNa me)

Hope this helps
Chris

That'll load a report from a specific drive location won't it. What I was
hoping to do was just use an instance of the report without loading an
external file/report from another location.

[Chris]

Chubbly Geezer wrote:

"Chris" <[e-mail]> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Chubbly Geezer wrote:

"Chris" <[e-mail]> wrote in message
news:Ow***** ********@TK2MSF TNGP14.phx.gbl. ..
Chubbly Geezer wrote:
>Now I've done this before but can't remember how.
>
>I want to pass a string into a procedure and then use that string in a
>Dim statement.
>
>i.e.
>
>Public Function PrintReports(By Val strDel As String, ByVal strSQL As
>String, ByVal strSelect As String, ByVal ReportName As Object) As
>Integer
>
>Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
>ReportNa me
>
>
>
>But I am getting a conversion error in that I cannot convert a string to
>this object type.
>
>Any ideas please.?
>
>
>
>Chubbly
>
>

You can not convert a string to a ReportDocument. Now in your function
you are passing an object. What type is this object you are passing in.
Where is your Report stored? Is it a file or an embedded resource?

Chris
I am passing in a string (was initially declared as a string) which
equates to the report name of rhe report that I want to run. i.e.
StandardStat ement
This relates to StandardStateme nt.rpt which is a crystal report which has
been created and resides in my VB 2005 app.

I realise that I can not convert a string to a ReportDocument but do not
know how to use the strings value the way I want.

I am trying to execute a line as below:

Dim myReport As CrystalDecision s.CrystalReport s.Engine.Report Document =
StandardStat ement

I previously used

Dim myReport As StandardStateme nt

but now find I need to pass in the report name.

Thanks

Chubbly

If the string is the report name then you are going about this wrong.

There are two ways I know of to load a report.

1. Get it out of an embedded resource
2. Load it from a file

How I do #2 is:

Dim crReportDocumen t As New
CrystalDecisi ons.CrystalRepo rts.Engine.Repo rtDocument()

crReportDocum ent.Load(Report Name)

Hope this helps
Chris

That'll load a report from a specific drive location won't it. What I was
hoping to do was just use an instance of the report without loading an
external file/report from another location.

You can do it as an embedded resource. Then you load it straight from
inside your dll. There are examples of that around and you can
reference the resouce from a string then.

Chris