Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to show the 1st record only of a group Post Reply Post New Topic
Author Message
Yosteevo777
Newbie
Newbie
Avatar

Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
Quote Yosteevo777 Replybullet Topic: How to show the 1st record only of a group
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.


Edited by DBlank - 24 Apr 2012 at 6:58am
IP IP Logged
Yosteevo777
Newbie
Newbie
Avatar

Joined: 23 Apr 2012
Location: United States
Online Status: Offline
Posts: 33
Quote Yosteevo777 Replybullet Posted: 24 Apr 2012 at 6:40am
Thanks DBlank......
Stephen Waichulis
LIMS Database Administrator
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.