Print Page | Close Window

How to show the 1st record only of a group

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16264
Printed Date: 03 May 2024 at 4:27am


Topic: How to show the 1st record only of a group
Posted By: Yosteevo777
Subject: How to show the 1st record only of a group
Date Posted: 23 Apr 2012 at 3:49pm
I am trying to only show the first instance of a Method Name for each group of Tests. I cannot use the "Suppress If Duplicated" feature because other Test groups sometimes use the same Method name and will be hidden.

Here is the crystal syntax I tried to use:
----------------------------------------------------------------

If Previous ({method.method_name}) = ({method.method_name})
Then
' '
Else
    {method.method_local_name}

----------------------------------------------------------------

Here is a link to a screen shot of what I'm talking about:
https://docs.google.com/open?id=0B2mUAbTW2Ei1Rkw5WVZ2ODFJbmc

Any help would be great!

Thanks
Stephen




-------------
Stephen Waichulis
LIMS Database Administrator


Replies:
Posted By: DBlank
Date Posted: 24 Apr 2012 at 3:58am
in the section expert, select the detail section and the the suppress no drill down formula option
drop the if-then part and use your formula as this just want a boolean evalaution
 
Previous ({method.method_name}) = ({method.method_name})
 
A word of warning that suppression of data does not exlcude it from the report or from summary calculations.

Posted By: Yosteevo777
Date Posted: 24 Apr 2012 at 6:40am
Thanks DBlank......

-------------
Stephen Waichulis
LIMS Database Administrator


Print Page | Close Window