LostInCode
Programmer
Is there another way to pass a string of text to a crystal formula, from a VB program, when the text is longer than 255 chars? Otherwise I get an error that the text for the formula is too long.
Do not wonder at the length.
I am passing as text the selected/current criteria in readible format() that the user sees on a grid, as a parameter, so they see in the report the current filter.
The reason i am doing this is because the table and field names, and the formatting do not tell the user a whole lot (some field names or abrreviations), and the user is not aquainted with the database. So I pass to the report the formated criteria using predefined field captions.
Sometimes the user selects many individual fields for criteria, rather that using > and < operands, so the criteria can easily be larger than 255 chars.
The only solutions I have thought of is to break the string apart and pass using two formulas - but that really isn't a solution as what happens if the text is 3 x 255 or 4 x 255? - or to send the formated criteria text to a db field and have CR pull from there.
Any other possibilities? I am using a CRPEAuto wrapper.