T
TJBernard
I am sure you have seen this type of question here before,
but I have been searching and not come up with an answer
to what I was looking for. I thought maybe someone on
here has attempted this.
I know you can open a Crystal Report by adding the Crystal
Report Active X control and reference the path for the
report.
What I am looking for is passing the parameters directly
from the form to the Crystal Report (via the stored
procedure) so I don't have to use the Crystal Report
parameter window.
On the access form I can choose the stored proc parameter
and it is passed to the crystal report.
Here is what I have tried:
Dim crrpt As Crystal.CrystalReport
crrpt.ReportFileName = "Report Path"
cboTapeNumber.SetFocus
crrpt.ParameterFields(1) = cboTapeNumber.Value
crrpt.Action = 0
I get an error attempting this on line
crrpt.ReportFileName = "report path". The error I get
is "Run-time error 91", "Object or block variable not set".
If anyone has attempted this or has any ideas of how to
accomplish this, let me know.
Thank you,
TJBernard
but I have been searching and not come up with an answer
to what I was looking for. I thought maybe someone on
here has attempted this.
I know you can open a Crystal Report by adding the Crystal
Report Active X control and reference the path for the
report.
What I am looking for is passing the parameters directly
from the form to the Crystal Report (via the stored
procedure) so I don't have to use the Crystal Report
parameter window.
On the access form I can choose the stored proc parameter
and it is passed to the crystal report.
Here is what I have tried:
Dim crrpt As Crystal.CrystalReport
crrpt.ReportFileName = "Report Path"
cboTapeNumber.SetFocus
crrpt.ParameterFields(1) = cboTapeNumber.Value
crrpt.Action = 0
I get an error attempting this on line
crrpt.ReportFileName = "report path". The error I get
is "Run-time error 91", "Object or block variable not set".
If anyone has attempted this or has any ideas of how to
accomplish this, let me know.
Thank you,
TJBernard