Crystal Reports Parameter Length Limitation

Because Crystal Reports.Net has really poor documentation I’m going to post this here in case any other poor souls are running into this issue.

Basically a String type parameters have a length limitation of 255 Characters. I was passing in some text as a Parameter to be printed in the footer of a complicated report, the text was a reminder of the filtered characteristics of the Report.

The report would usually run fine but in certain situations it would fail with an error that I was missing a parameter.

Of course I knew I was setting all the parameters, I narrowed it down to this Report_Footer param and through some trial and error noticed that it was only when the text count was high that it died like this.

So basically the moral of the story is that

Try
    
ReportToExport.SetParameterValue(“Report_Footer”, ReportSelector.ReportFooter)
Catch ex As Exception
    
Debug.Writeline(ex.Message)
End Try    

Colorized by: CarlosAg.CodeColorizer

Even though the above code doesn’t throw any errors like it should it still fails, quitely. Leading to me wasting time tracking this bug down, and then wasting more time typing this in the hopes that others will not have to suffer.

Sincerely,
Your friendly humanitarian – Joshua Bloom –

Posted: October 27th, 2005
Categories: Code, Technical
Tags:
Comments: 1 Comment.
Comments
Comment from aruna - December 26, 2007 at 2:52 am

crysatl report not even able to show 50 MB xml data file..its a limitaion of Crystal report