• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1181
  • Last Modified:

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
0
Jim Horn
Asked:
Jim Horn
  • 2
  • 2
1 Solution
 
bdreed35Commented:
You might have a reason for not doing it this way, but have you tried just setting the top border of the field in the group footer instead?
0
 
mlmccCommented:
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
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
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.
0
 
bdreed35Commented:
Jim:  Just wondering if you saw my earlier post.  If that would work, you would not need the formulas.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
>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
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now