asked on

Underline last value in list; double underline group total

Hello Crystal experts...

(1) Is it possible to format a field in the detail section in such a way that the LAST value is underlined?
(2) Is it posslbe to double-underline a group total field?

Something like, instead of
2 {detail fields}
2
2
6 {group footer}

this instead
2 {detail fields}
2
2
___
6 {group footer}
___
___

Thanks in advance.
-Jim

ASKER CERTIFIED SOLUTION

bdreed35

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

Try this

Right click on the field
Click FORMAT
Click the BORDER tab
Click the FORMULA Button next to BOTTOM
Formula is
if (OnLastRecord) OR (Next({GroupField}) <> {GroupField}) then
1
else
0

For the double underline
Right click the field in the group footer
Add a double bottom border

mlmcc

Jim Horn

ASKER

I'm following you on the formula, however my CR Formula coding experience is still somewhat new (I'm coming from an Access VBA experience)

if (OnLastRecord) OR (Next(Sum ({spr_single_broker_history_discontinued_breakdown;1.disco_last_status_ndb})) <> Sum ({spr_single_broker_history_discontinued_breakdown;1.disco_last_status_ndb})) then
1
else
0

Returns a 'This field has no previous or next value' error message.

The data source is spr_single_broker_history_discontinued_breakdown, the field I'm trying to sum is disco_last_status_ndb.

I have not re-named any fields; just moved them from field chooser to report design, and added appropriate totals, which appears to have created a field named Sum ({spr_single_broker_history_discontinued_breakdown;1.disco_last_status_ndb})), or at least that is how it is displayed in the Formula Editor, and I'm not certain if my not renaming it to something that is removing the spaces from the names is causing the formula to fail.

bdreed35

Jim: Just wondering if you saw my earlier post. If that would work, you would not need the formulas.

Jim Horn

ASKER

>Just wondering if you saw my earlier post.
Actually, I did but went with the formula instead, but now that I have re-visited it it worked like a charm.

mlmcc - I'll award points to bdreed35 here, but will likely have more formula questions in the near future.

Thanks guys.
-Jim