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...
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...
I created a subreport that pulls company cost for certain medical benefits as of certain date.
I then put the subreport into the main report as directed in a footer section. The main report pulls data from other benefit information. I then have a formula to combine the subreport total of company...
I have created a report that is pulling data for a benefit ending date for a select group for their medical benefits then another report with another ending date for the remaining benefits.
I tried an if statement on the main report, but it pulls the data for all benefit end dates.
Ex: If...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.