keithfearnley
asked on
Crystal Reports 10 from C# vs2008: error "missing parameter values" but all parameters have values?
We have converted a project from using .NET 1.1 to .NET 3.5 (to run nicely on a new server) and all works fine except for the Crystal Reports.
We were using CR 9 and now have to use CR10, since there seems to be no way to reference CR9 DLLs under this project now.
When a report is generated we are getting the error "missing parameter values". We have changed the order and the manner in which we assign values. We are also checking so we know that immediately before the call to generate the report, all parameters do have values. We have run with our usual situation (some parameters have a null or blank value) and with every param having a non-null, non-blank value. All get the same error.
We have tried a dummy report with no parameters and that works fine, so it does look like a parameters problem of some kind.
In brief, without boring with code, we:
- load the report
- set up the database connection
- set the parameters (values from web page)
- for debug purposes check if all the report's parameters have a value
- export to PDF
The full error text is
CrystalDecisions.CrystalRe ports.Engi ne.Paramet erFieldCur rentValueE xception was caught
Message="Missing parameter values."
Source="CrystalDecisions.R eportAppSe rver.DataS etConversi on"
StackTrace:
at CrystalDecisions.ReportApp Server.Con vertDotNet ToErom.Thr owDotNetEx ception(Ex ception e)
at CrystalDecisions.ReportSou rce.EromRe portSource Base.Expor tToStream( ExportRequ estContext reqContext)
at CrystalDecisions.CrystalRe ports.Engi ne.FormatE ngine.Expo rtToStream (ExportReq uestContex t reqContext)
at CrystalDecisions.CrystalRe ports.Engi ne.FormatE ngine.Expo rt(ExportR equestCont ext reqContext)
at CrystalDecisions.CrystalRe ports.Engi ne.FormatE ngine.Expo rt()
at CrystalDecisions.CrystalRe ports.Engi ne.ReportD ocument.Ex port()
at TARN.Report.ExportCrystal( ) in C:\Inetpub\wwwroot\TARN200 8\TARN\Cla sses\Repor t.cs:line 917
InnerException: System.Runtime.InteropServ ices.COMEx ception
Message="Missing parameter values."
Source="Analysis Server"
ErrorCode=-2147217394
StackTrace:
at CrystalDecisions.ReportApp Server.Con trollers.R eportSourc eClass.Exp ort(Export Options pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSou rce.EromRe portSource Base.Expor tToStream( ExportRequ estContext reqContext)
This needs to go live 1st April and we didn't expect to have problems upgrading Crystal versions so it is pretty urgent now, any help gratefully acccepted.
We were using CR 9 and now have to use CR10, since there seems to be no way to reference CR9 DLLs under this project now.
When a report is generated we are getting the error "missing parameter values". We have changed the order and the manner in which we assign values. We are also checking so we know that immediately before the call to generate the report, all parameters do have values. We have run with our usual situation (some parameters have a null or blank value) and with every param having a non-null, non-blank value. All get the same error.
We have tried a dummy report with no parameters and that works fine, so it does look like a parameters problem of some kind.
In brief, without boring with code, we:
- load the report
- set up the database connection
- set the parameters (values from web page)
- for debug purposes check if all the report's parameters have a value
- export to PDF
The full error text is
CrystalDecisions.CrystalRe
Message="Missing parameter values."
Source="CrystalDecisions.R
StackTrace:
at CrystalDecisions.ReportApp
at CrystalDecisions.ReportSou
at CrystalDecisions.CrystalRe
at CrystalDecisions.CrystalRe
at CrystalDecisions.CrystalRe
at CrystalDecisions.CrystalRe
at TARN.Report.ExportCrystal(
InnerException: System.Runtime.InteropServ
Message="Missing parameter values."
Source="Analysis Server"
ErrorCode=-2147217394
StackTrace:
at CrystalDecisions.ReportApp
at CrystalDecisions.ReportSou
This needs to go live 1st April and we didn't expect to have problems upgrading Crystal versions so it is pretty urgent now, any help gratefully acccepted.
ASKER
Thanks for the reply...
Sorry, I should have been clearer with my version numbers - we are indeed using the version of 10 that comes with VS2008 - I was distinguishing that from v9 that we had used before when the project had been built under VS2003.
Yesterday we made a break-through in that we discovered how to referecce the old Crystal v9 dlls so that the project is back up and running again. So our panic is over, but it would still be useful to know about this, in case it hits our next built-from-scratch project to use Crystal 10.5 from VS2008.
Do you know if attempting to use a standalone Crystal would cause that error message (maybe we inadvertently referenced our standalone DLLs when we thought we were using the VS version)?
Sorry, I should have been clearer with my version numbers - we are indeed using the version of 10 that comes with VS2008 - I was distinguishing that from v9 that we had used before when the project had been built under VS2003.
Yesterday we made a break-through in that we discovered how to referecce the old Crystal v9 dlls so that the project is back up and running again. So our panic is over, but it would still be useful to know about this, in case it hits our next built-from-scratch project to use Crystal 10.5 from VS2008.
Do you know if attempting to use a standalone Crystal would cause that error message (maybe we inadvertently referenced our standalone DLLs when we thought we were using the VS version)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Difficult to determine accuracy... we tried something different and it worked - we hadn't the time to investigate too much further.
Help appreciated
Help appreciated
https://forums.sdn.sap.com/thread.jspa?threadID=1331234
mlmcc