11/25/2024 12:39:48 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Crystal Viewer Error: A string can be at most 254 character long 
Posted: 30 Aug 07 5:16 AM
|
Hi All,
When we are trying to run a report in saleslogix v6.2.6 client, we are getting the following error: "Crystal Viewer Error: A string can be at most 254 character long". we are getting this error only when all the available groups are selected in the Parameters while executing the report, when we are trying with less no. of groups, report is running fine. Can anyone provide any pointers to this..??
Thanks in Advance....
Amit |
|
|
|
Re: Crystal Viewer Error: A string can be at most 254 character long
Posted: 30 Aug 07 7:24 AM
|
Amit,
In your data somewhere is a field/string that is greater than the limit of 254 characters.
Take a look at fields you are using in the report and look for ones where the character length can be greater than 254. Once you have determined which field(s) meet this criteria you will have to work out a formula that truncates the field down to 254 characters. You might be able to create a formula in crystal that uses the LEFT() string function to return the leftmost 254 characters of the database field.
Personally, I would create a view to retrieve data for the report. In that view I would format the data to exactly how I need it to be, like truncating the long fields down to 254 characters and converting any instances of NULL to a usable value.
John G.
|
|
|
|
Re: Crystal Viewer Error: A string can be at most 254 character long
Posted: 31 Aug 07 9:34 AM
|
| Depending on the field that is too long, you can use a series of formulas of Left(), Mid() or Right() to keep the formula length in check. If you then add a text box to the report and drag the formulas into the text box, you will be able to present information greater than 254 characters in a single field. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|