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..

6.JPG

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

7.JPG

Write the following formula

8.JPG

Save and execute the report.

9.JPG

In this way we can achieve the requirement.

Hope it will helpful for beginners.

Regards,

Ganesh Bothe

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Bobbi Rowlett

    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!

    (0) 

Leave a Reply