[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1317
  • Last Modified:

Limit Detail Rows Per Group in a Crystal Report

Hello All,
I have been asked to create a report but to only select the Top1record per group. Example I have grouped by drug and need to restrict the report to only select 1 dr attached to the drug. Any help with this will be greatly appreciated.
Thanks.
0
Star79
Asked:
Star79
1 Solution
 
peter57rCommented:
Do you have a rule for choosing the one record you want or would it be any record in the group?
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Simplest option is to simply drag the info into the Group Header. The group header always shows the info for the 1st record in the group.
Then, suppress the detail section.

You just need to sort the records within the group such that the 1st record is the one you are interested in.

Similar logic applied to the Group Footer (shows the last record in the group.
0
 
mlmccCommented:
Agree with Ido.

There is also an option with groups (GROUP SORT EXPERT) for a TOP N report

mlmcc
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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