HideDuplicates property in Reports 1

[jlmeek]

I have duplicate data in a table, but when I run a report I would like to hide the duplicate data. When I click Yes to HideDuplicates in the text field property and run my report - a blank space remains where the duplicate data is hidden. How can I both hide the duplicate records and remove the blank spaces from my report? Any suggestions would be most helpful.

Thanks,
jess

 

[kathryn]

OK, the idea behind HideDuplicates is to change this:

Monday Project1
Monday Project3
Monday Project4
Tuesday Project1
Tuesday Project2

into this:

Monday Project1
Project3
Project4
Tuesday Project1
Project2

Now it sounds like you are saying that you have duplicates in ALL fields. If so, then you need to look at the query underlying the report. From the menu, choose View and SQL...

Edit the SQL to read SELECT DISTINCT instead of SELECT.

This will eliminate duplicate rows.

Hope this helps.

Kathryn

 

[kathryn]

OK, the idea behind HideDuplicates is to change this:

Monday Project1
Monday Project3
Monday Project4
Tuesday Project1
Tuesday Project2

into this:

Monday Project1
Project3
Project4
Tuesday Project1
Project2

It sounds like you are saying that you have duplicates in ALL fields. If so, then you need to look at the query underlying the report. From the menu, choose View and SQL...

Edit the SQL to read SELECT DISTINCT instead of SELECT.

This will eliminate duplicate rows.

Hope this helps.

Kathryn

 

[jlmeek]

Kathryn -

Thank you, Thank you, Thank you!!! Your fix worked and it was so easy.

Regards,
jess