How to restrict Distinct data records in report level Crystal Report

[former_member183012]

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.

Regards,

Ganesh Bothe