Crystal Reports - select individual records in a group

Question

I am trying to figure out how to show individual records in groups in crystal reports. The view I wrote returns something like the following:

Field 1  |  Field 2  |   Field 3
----------------------------------
    10   |   111     |  Record Info 1
    10   |   111     |  Record Info 1
    10   |   222     |  Record Info 2
    20   |   111     |  Record Info 1
    20   |   222     |  Record Info 2

Report groups are based on the first field, and I want different fields 2 and 3 for each group:

Field 1  |  Field 2  |   Field 3
----------------------------------
    10   |   111     |  Record Info 1
    10   |   222     |  Record Info 2
    20   |   111     |  Record Info 1
    20   |   222     |  Record Info 2

Field 2 and 3 are always the same, field 1 acts as an FK link to any records in the view. The choice distinct xxxin the view is not really viable due to the huge number of input columns.

Can this be done in CR?

Greetings

Answer 1

• Create a group for field1, field2
• , field1 field1
• , / 2.

!

Answer 2

Database | Select Distinct Records.