Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to avoid repeating records in queries

I have in my report this report result:

A.......B........C

____________

1.......3..........1

1........4..........2

2........5..........3

1.......3...........1

1........4..........2

I would like in the result to list only one time the same rows. For example here this will be the right result:

1.......3..........1

1........4..........2

2........5..........3

How can i suppress the second or third repeated rows.

I have here CR 8.0 and data from SServer.

Kind regards

Arnaud

Edited by: Arnaud on May 19, 2011 1:58 PM

Former Member replied

Actually, to keep with the example you would need to do the following...

1) Create a formula that concatenates A & B

ToText({TableName.A}, "0") & ToText({TableName.B}, "0")

2) Group by this formula.

3) When the group is created, delete the that is automatically generated.

4) Place all of your fields in the group header... not the group footer.

HTH,

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question