Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
> On Mon, 2005-05-02 at 08:01 -0700, Justin Jones wrote:
> > I have a formula where I am trying to change the format of the field to
> > remove the standard two decimals. I am drawing a Monday morning brain
> > lapse on how to do this. Any help I appreciated.
> >
> >
> >
> > {Item.Quantity} & "@" & {Item.Price} displays 10.00 @ $15.00 and I want
> > it to display as 10 @ $15.00
> >
> >
> >
> > Thank you.
> >
> >
> >
--- In Crystal_Users@yahoogroups.com, Costas Piliotis <cpiliotis@s...>
wrote:
> Personally I don't usually use a formula for simple concatenation
> stuff... Many people don't realize that you can just drop a field onto
> a text box because many people come from MS Access Reports that don't
> have this feature. You might already know this, but just in case:
>
> I would create a text field with " @ " inside of it. Then drag the db
> field somewhere on your report, format it, and then drag it into the
> text box afterwards. IMO that's one of the ultra coolest features of
> CR.
>
> (OTOH if you're doing anything more, I too have a brain fart this
> morning haha and can't remember the function either)
>
In my opinion, the brain fart is in Crystal. Your formula field is a
string, so you can't just format it; you have to format the components
of the string: {Item.Quantity}. Supposebly, truncate(x) will get rid
of the decimal point and trailing zeros, but it don' seema work inside
a formula. (Can anybody say "bug".)
I finally got it to work with ...
Replace (ToText ({FIN_FISCAL_YEARS.FISCAL_YEAR}), ".00", "") & " @ " &
{FIN_FISCAL_YEARS.CLOSING_STATUS}
Maybe Costas has the better approach.