Solved

How to pass a value that is more than 254 characters, to a formula field in crystal reports.

Posted on 2002-06-03
8
314 Views
Last Modified: 2010-05-18
hi,
Iam trying to pass a value to a formula field in my crystal reports from my VB form. When the value contains more than 254 characters, which CR doesn't accept, it throws an error. When I try to split the formula into two to accept upto 500 characters, the sentence looses continuity.
Can anyone suggest me in achieving this.

Thanx in advance.
0
Comment
Question by:vramkri
  • 3
  • 2
  • 2
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 7051336
Unfortunately, as best I can tell you can't.

Perhaps you could write it to the database before calling up the report.  Another idea is to put n a text file and have the report pull it from there.

I tried various ideas and kept running across the CR limitation of 254 characters in a string.

The only other idea i have is to write some code to parse the string into pieces that are approximately 1 line long (number will vary based on font and size) and then have 10 or 12 formulas you fill as needed.

I'll see what I can come up with.

mlmcc
0
 
LVL 2

Expert Comment

by:perfittl
ID: 7058921
you could break up the strings before sending them to crystal then have crystal tie 'em back together again.  Depends on your database as to how you split them up. In sql SUBSTRING functions work good for that.  Let me know if this is enough info to get you going.

Hope this helps

Larry
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 50 total points
ID: 7059179
I tried that but unfortunately you cannot tie them back together in CR since it doesn't allow strings longer than 254 characters even in formulas.

mlmcc
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 2

Expert Comment

by:perfittl
ID: 7059290
Could be affected by the connection or Version. I'm working in version 8.0 and have no problem with doing this.  I am using a native SQL connection, not ODBC.  Are you connecting to a SQL Server db, Oracle, Access?
0
 
LVL 7

Expert Comment

by:mnye
ID: 9346766
This question has been classified abandoned. I will make a recommendation to the moderators on its resolution in a week or two. I appreciate any comments that would help me to make a recommendation.
 

Unless it is clear to me that the question has been answered I will recommend delete. It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.

 
If the user does not know how to close the question, the options are here:
http://www.experts-exchange.com/help/closing.jsp 

mnye
EE Cleanup Volunteer
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9350998
What he wanted can't be done.  I believe I provided that answer.

mlmcc
0
 
LVL 7

Expert Comment

by:mnye
ID: 9827901


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/No Refund, resolved by mlmcc

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

mnye
EE Cleanup Volunteer
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question