Can you pass a parameter longer than 255 characters from VB6 to Crystal Reports 8.5?

Question

VB6 closes without an error message on the line below when "strCompany" is longer than 255 characters. Is there some way to make this work?

rptReport.ParameterFields.GetItemByName("@company").AddCurrentValue (strCompany)

"I receive an error" is a bit vague. Just to be thorough, can you edit your question to add the error message you are receiving? — C-Pound Guru, Feb 20 '15 at 13:34

score 1 · Answer 1 · answered Sep 16 '15 at 05:59

Short answer: it doesn't look like it.

Just ran into an issue with this today. When a report was generated with a parameter 281 characters in length and exported to a PDF, the application crashed. When the report was displayed on the screen, the parameter's value was cut-off, but the application did not crash.

Shortening the value to 255 characters solved the immediate problem.

Data fields have the option of being defined as 'Memo', but it does not look like parameters have that data type available as an option.

score 0 · Answer 2 · answered Feb 19 '15 at 21:39

0

I personally have never run into this, but here's how I add data to parameters in Crystal Reports and work's just fine.

  rptReport.SetParameterValue("@company", strCompany)

Of course @company is your parameter name and strCompany is your value (string) to give to the parameter.

answered Feb 19 '15 at 21:39

Trevor

7,777
6
31
50

.SetParameterValue is not an option that i can choose. – JHanz99 Feb 23 '15 at 14:34
Sorry about that, I stand corrected. It's only available in Crystal Reports 10 and up. – Trevor Feb 23 '15 at 14:50
Did you add this parameter through the IDE, not in code right? – Trevor Feb 23 '15 at 14:52
Yes, the parameter was added in Crystal Reports. – JHanz99 Feb 24 '15 at 15:51

Can you pass a parameter longer than 255 characters from VB6 to Crystal Reports 8.5?

2 Answers2