Solved

crystal report 4.6 - apostrophe in formula

Posted on 2004-08-12
7
967 Views
Last Modified: 2012-06-22
how do I handle apostrophes in formula to be passed to a report without causing an error. I tried replace ' with '' but still wont work.
0
Comment
Question by:tsluu
[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
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 11790517
What are you trying to do?

Crystal formulas can use " " or ' ' for string data.  I would think you could use " " for the strings and a ' would then simply be a character.

mlmcc
0
 

Author Comment

by:tsluu
ID: 11790634
crpt.Formulas(0) = "ReportTitle='MacDonald's Burger'"
the above will give an error.

So I tried
crpt.Formulas(0) = "ReportTitle='MacDonald''s Burger'"
and still give an error.

How do I solve the apostrophe problem?


0
 
LVL 100

Expert Comment

by:mlmcc
ID: 11791862
Try
crpt.Formulas(0) = "ReportTitle='MacDonald""s Burger'"

That is a double double quote in Mconald's

mlmcc
0
 

Author Comment

by:tsluu
ID: 11798089
crpt.Formulas(0) = "ReportTitle='MacDonald""s Burger'" works fine but my report title will display:

MacDonald"s Burger

instead of :

MacDonald's Burger
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 50 total points
ID: 11798250
Try

crpt.Formulas(0) = "ReportTitle='MacDonald' + chr(27) + "'s Burger'"

chr(27) is the '

mlmcc

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …

730 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