• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1222
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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