How to fix Crystal Reports Bug that causes Buffer too small for string or missing null byte error?
Posted on 2008-10-24
Details of my Page:
I have an aspnet listbox that allows multiple selects. ListBox something like this: All, House, Mechanical, Comfort, Noise, Electrical. <--small example...maybe 50 options. User can select as many options as needed. Then these options are passed through a string as parameter Issues to a stored procedure variable @Issues. However that all works.
When i pass the querystring to CrystalReportsViewer, I get the above error.
I have a field on the the report called:
report.SummaryInfo.ReportComments = Request.QueryString("Comments1") & Request.QueryString("Comments2") & Request.QueryString("Comments3")
Comments1 = ReportTitleName <--not too big
Comments2 = selections from List which can be up to 50 words
Comments3 = EnteredByInformation <--not too big...
and depending on size of Comments2, I will get the error: Buffer too small for string or missing null byte error.
Is there anyway to make report.SummaryInfo.ReportComments size limitless?
otherwise how would I fix?