Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
320 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 200 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
New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

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. …
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 …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

704 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