Crystal Report: Load Report gives no error, but ParameterFields are empty

T

Trips

Well-known member
Joined
Aug 7, 2010
Messages
2,788
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt Hi experts,
<p style="margin:0cm 0cm 0pt <span lang="EN-US <span style="font-family:Times New Roman; font-size:small
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt I am using the ReportDocument.Load() method to load an existing crystal report. I do not get any error while loading it (which I assume is successful).
<p style="margin:0cm 0cm 0pt <span lang="EN-US <span style="font-family:Times New Roman; font-size:small
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt However, when I try to execute the SetParameterValue() method, it throws the following error:
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt >> Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt Upon further investigation, I found that it is not because of a mismatch of parameter names, but instead the report document did not recognize the crystal
reportâs parameters. <span style="font-family:Verdana This error only occurs on a specific machine . All other machines that Ive tested works fine. I have confirmed that the reports being loaded are the same.
<p style="margin:0cm 0cm 0pt <span lang="EN-US <span style="font-family:Times New Roman; font-size:small
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt Below is a snippet of my code:
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt --------------------------------------
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:#2b91af; font-size:8pt ReportDocument<span style="font-family:Verdana; color:black; font-size:8pt estimateReport =
<span style="font-family:Verdana; color:blue; font-size:8pt new<span style="font-family:Verdana; color:black; font-size:8pt
<span style="font-family:Verdana; color:#2b91af; font-size:8pt ReportDocument<span style="font-family:Verdana; color:black; font-size:8pt ();
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt estimateReport.Load(srcReportPath);
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:green; font-size:8pt // Trace information
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:blue; font-size:8pt if<span style="font-family:Verdana; color:black; font-size:8pt (crystalSwitch.Enabled)
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt {
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span>
<span style="font-family:Verdana; color:#2b91af; font-size:8pt Trace<span style="font-family:Verdana; color:black; font-size:8pt .WriteLine(<span style="font-family:Verdana; color:#a31515; font-size:8pt "Display parameter list:"<span style="font-family:Verdana; color:black; font-size:8pt ,
<span style="font-family:Verdana; color:#2b91af; font-size:8pt DateTime<span style="font-family:Verdana; color:black; font-size:8pt .Now.ToString(<span style="font-family:Verdana; color:#a31515; font-size:8pt "g"<span style="font-family:Verdana; color:black; font-size:8pt ));
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span>
<span style="font-family:Verdana; color:blue; font-size:8pt int<span style="font-family:Verdana; color:black; font-size:8pt fields = estimateReport.DataDefinition.ParameterFields.Count;
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:blue; font-size:8pt <span>
for<span style="font-family:Verdana; color:black; font-size:8pt (<span style="font-family:Verdana; color:blue; font-size:8pt int<span style="font-family:Verdana; color:black; font-size:8pt i = 0; i < fields; i++)
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span>
{
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span>
<span style="font-family:Verdana; color:#2b91af; font-size:8pt Trace<span style="font-family:Verdana; color:black; font-size:8pt .WriteLine(<span style="font-family:Verdana; color:#a31515; font-size:8pt "PARAM["<span style="font-family:Verdana; color:black; font-size:8pt
+ i + <span style="font-family:Verdana; color:#a31515; font-size:8pt "] - "<span style="font-family:Verdana; color:black; font-size:8pt + <span style="font-family:Verdana; color:black; font-size:8pt estimateReport.DataDefinition.ParameterFields.Name.ToString(), <span style="font-family:Verdana; color:#2b91af; font-size:8pt DateTime<span style="font-family:Verdana; color:black; font-size:8pt .Now.ToString(<span style="font-family:Verdana; color:#a31515; font-size:8pt "g"<span style="font-family:Verdana; color:black; font-size:8pt ));
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span>
}
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt }
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span style="font-family:Verdana; font-size:8pt estimateReport.SetParameterValue(<span style="color:#a31515 "as_company", companyCode);
<span style="font-family:Verdana; color:green; font-size:8pt // Throws error on this line
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt <span style="font-family:Verdana; color:green; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt --------------------------------------
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt On a working PC, I will get the following trace results:
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:green; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; color:black; font-size:8pt 9/6/2010 5:05 PM: Display parameter list:<br/>
9/6/2010 5:05 PM: PARAM[0] - as_company<br/>
9/6/2010 5:05 PM: PARAM[1] - as_user<br/>
9/6/2010 5:05 PM: PARAM[2] - as_report<br/>
9/6/2010 5:05 PM: PARAM[3] - ad_manr
<p style="margin:0cm 0cm 0pt <span lang="EN-US <span style="font-family:Times New Roman; font-size:small
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt But on the problem PC, we can see that there is no paramater:
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt 6/9/2010 5:06:43 PM: Display parameter list:<br/>
6/9/2010 5:06:43 PM: Error: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt Does anyone have any clue what is missing on that PC?
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt Why is the Load() method not working properly?
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt Thanx in advance.
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt
<p style="margin:0cm 0cm 0pt <span style="font-family:Verdana; font-size:8pt YJ

View the full article
 
Back
Top