Print Page | Close Window

Italics and regular text inside formula field?

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6040
Printed Date: 29 Apr 2024 at 2:33am


Topic: Italics and regular text inside formula field?
Posted By: brandonboyer
Subject: Italics and regular text inside formula field?
Date Posted: 09 Apr 2009 at 11:21am

I have created a forumla field that contains an if statment to display either one sentence or the other, depending on a database flag. Now, I would like to write the word "BreastCare" as "BreastCare" in this formula field, but as of yet can't figure out a way to do it? Can someone help? This appears to be a different situation than "conditional formatting", which is what all the other posts discuss . . .

// Is the client symptomatic?
if({dataset.Symptomatic}) <> "Y" then
    // No.
    "The client has been instructed to bring her BreastCare client ID card to the appointment. ")
else
    // Yes.
   "A denial date or amount of other insurance payment is required at the time you submit the BreastCare claims for women in Plan B."
 


Replies:
Posted By: hilfy
Date Posted: 09 Apr 2009 at 11:52am
There is no way to do this from within the formula, but I have a work-around for you.
 
1.  Create a formula that contains all of the text before "Breast" based on your conditions.
2.  Create another formula that contains all of the text after "Breast" based on your conditions.
3.  Instead of putting the formula directly on the report, put a text box where you want this to appear. 
4.  Drag your first formula into the text box.  Wait until you see a vertical line cursor in the text box before you drop the formula.
5.  Type " Breast" in the text box after the formula.
6.  Drag the section formula into the text box.  Make sure the vertical cursor is at the end of the word "Breast" before you drop it.
7.  Highlight just "Breast" and make it italic.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: TorLang
Date Posted: 04 Mar 2016 at 7:08am
Was actually able to find /replace the italic quotes in the record select formula editor itself.....BUT, there is a limit as to how many items you can shove in there...

Error: "Too many items have been given to this array"

Can't win for loosing :-)


Print Page | Close Window