Skip to Content
Author's profile photo Ganesh Bothe

How to restrict Distinct data records in report level Crystal Report

Purpose: In report show only unique record at report level.

Scenario:  I have sub report which will retrieve data from table based on Manager from main report.

Table can have multiple entry form same manger because its employee table. It can be achieved using command also but at table level also it is possible.

Just want to share real time experience using this blog.

Following is the report output  which will show the all the records form table..


We want to show distinct records for that go to section expert.


Write the following formula


Save and execute the report.


In this way we can achieve the requirement.

Hope it will helpful for beginners.


Ganesh Bothe

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      I am very new to crystal reports.  I have tried what you stated above, except in my details section, I want to show only the last entry in my table for this group.  In following your instructions, I put it in the footer.  I still get two records.  If I put the fields in the header, I still get two records.  I really just want to hide any accounts that have a certain entry, but not making much progress.  I don't understand what I am doing wrong.

      Any patience you can have with me to help understand this better would be appreciated!

      Author's profile photo Former Member
      Former Member