Print Page | Close Window

Adding Parentheses Around a Figure

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13500
Printed Date: 19 May 2024 at 11:15am


Topic: Adding Parentheses Around a Figure
Posted By: CKrzacz
Subject: Adding Parentheses Around a Figure
Date Posted: 15 Jun 2011 at 4:56am
Hello, I am pretty green at Crystal Reports, and I am wanting to put parentheses around a figure that is being subtracted from the subtotal. I'm not sure entirely how to do this, would I just put them around my filler text which says "PREVIOUS_PAID_VALUE"? Or is there another way for me to do this?

Thanks,

Chris


Replies:
Posted By: DBlank
Date Posted: 15 Jun 2011 at 5:14am
if it is just a matter of display then (assuming the field is numeric)
right click on the field
format field
number tab
select then desired () version from the list
click on customize
mark the "reverse sign for display" as true
OK
OK

Posted By: CKrzacz
Date Posted: 15 Jun 2011 at 5:49am
Hmm, I don't have a number tab to select. I do have the following "Common, Border, Font, Paragraph, and Hyperlink".

Going through them, I did not see anything relative to placing () around the result figure.

Posted By: Keikoku
Date Posted: 15 Jun 2011 at 6:01am
Paragraph


I'm not sure entirely how to do this, would I just put them around my filler text which says "PREVIOUS_PAID_VALUE"? Or is there another way for me to do this?


The Number tab only shows up for number type fields.
Is this filler text necessary?

Posted By: CKrzacz
Date Posted: 15 Jun 2011 at 6:07am
It's telling me where it is pulling the information from. The document I am editing is a pre-made document for a program. The filler text is not editable as it's just displaying what text will be filled in there when the data is sufficient.

Edit: I'm wondering if it would just be easier to put 2 small text boxes on the outside of the desired field and have them anchored to it, so they would always shrink and/or expand to the size of the field as needed.

Posted By: Keikoku
Date Posted: 15 Jun 2011 at 6:22am
The filler text is not editable as it's just displaying what text will be filled in there when the data is sufficient.


That is odd. It sounds like a formula field or a DB field.

Edit: I'm wondering if it would just be easier to put 2 small text boxes on the outside of the desired field and have them anchored to it, so they would always shrink and/or expand to the size of the field as needed.


I'm not sure if I understand what you mean.


Print Page | Close Window