Formating single Line 2

[deb9105]

I created a report that lists employee benefits and the cost per benefit. The cost of benefit field has the currency symbol on all costs of benefits. My manager wants only the first record with the currency field. The report pulls
all benefit costs from the same field Name.
Ex:
Joe Smith
999 Summers Lane
Ontario, Canada

Benefit Cost
Health America $50.00
Dental $ 5.00

 

[lupins46]

You can do a conditional currency symbol.
Select the field and right-click and format field.
In the number format tab click customise .
Then on the currency symbol tab you can conditionally enable the symbol with a formula:

if OnFirstRecord then crfloatingcurrencysymbol else crnocurrencysymbol

 

[deb9105]

The formula you suggested worked on the first employee's record, but when the next page of the report came up with another employee's name and benefit cost field, the Currency symbol on the first benefit cost was deleted also.
I need the currency symbol to appear on the first line of the cost and not show on the rest per employee record.

 

[bdreed35]

There is an option to show the currency symbol once per page.

Right click the currency field.
Choose Format Field.
Click the Number Tab and then the Customize button.
Click the Currency Symbol tab.
Remove the conditional formula by clicking the X+2 button and deleting any logic you have in there.
Save and close.
Back in the Currency Symbol tab, choose Enable Currency Symbol and choose either Fixed or Floating.
The next option below that will be "One Symbol per Page".
Select this property and click Ok to close each dialog box.

~Brian