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
318 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
8 Comments
 
LVL 101

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 101

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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 101

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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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 this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

632 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