Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Italics and regular text inside formula field? Post Reply Post New Topic
Author Message
brandonboyer
Newbie
Newbie


Joined: 09 Apr 2009
Location: United States
Online Status: Offline
Posts: 1
Quote brandonboyer Replybullet Topic: Italics and regular text inside formula field?
    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."
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
TorLang
Groupie
Groupie


Joined: 13 Jun 2012
Location: United States
Online Status: Offline
Posts: 50
Quote TorLang Replybullet 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 :-)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.045 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.