Learn how to a build a cloud-first strategyRegister Now


Crystal Reports - Show first field value in each group

Posted on 2014-08-12
Medium Priority
Last Modified: 2014-08-12

I have a grouping set up to group by Name. In the details section I have a field that should only display the first record. I'm not sure how to set up a formula to say something like...

Suppress field value if a new group is started and current record is greater than 1.
Question by:nightshadz
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 40255512
You could put it in the group header.  It will display only the values from the first record.

You can also suppress with a formula like

Not OnFirstRecord
Previous({Groupfield}) = {GroupField}

LVL 23

Expert Comment

by:Ido Millet
ID: 40255515
If this is a value that stays the same for all details within the group, then simply turn on the option of 'Suppress if Duplicated' (Format Field, Common tab)

Author Closing Comment

ID: 40255542
IdoMillet, it's not a duplicate value, I only need to show the first record for this field.  

mlmcc, I used your formula and it displayed only the first record for this field in a group and suppressed the rest. Thanks!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month20 days, 23 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question