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.