Solved How to let repeated date information show only once in report?

[yunhsuan]

Hello~
I want to make the table group by Date in the report. But I hope the information of Date shows next to the Item column, and the same date only show once(the result should look like right one below).
I just know how to let the result shows like left one, and both of Date and Item were put in detail section now. How can I make it like right one?
Thanks in advance!

 

[theDBguy]

Check out the Hide Duplicates property.

 

[CJ_London]

use the report wizard and choose the block layout style - which will apply the hide duplicates property to your date column

 

[oleronesoftwares]

Use the report wizard, choose the fields you want, with date field first, then item next

Under group by, choose the date field, choose Normal under grouping intervals.

 

[yunhsuan]

Check out the Hide Duplicates property.

I turned on the Hide Duplicates property. The repeated dates disappeared successfully, but their grids also disappeared. This make my report look weird like this:

Can the grids show when the dates in its cell are hide?

 

[Pat Hartman]

I don't see any way to control this. I tried both the grid layout and the Border properties. Looks like Access makes the control invisible and so that removes the grid lines also.

If you want to retain the gridlines, you would have to turn off the hide duplicates feature and write your own code in the format event of the detail section to change the value of the field to "". You would define a variable, then in the format event, compare the current value to the variable value. If they are the same, then you can change the current value of the field to ""

If Me.SomeField = vSomeField Then
    Me.SomeField = ""
Else
    vSomeField = Me.SomeField
End If

 

[theDBguy]

I turned on the Hide Duplicates property. The repeated dates disappeared successfully, but their grids also disappeared. This make my report look weird like this:
View attachment 96584
Can the grids show when the dates in its cell are hide?

Hi. I didn't know about that. You could try what @Pat Hartman suggested. Another possibility is drawing the borders yourself using the Line control.

 

[Pat Hartman]

I didn't try drawing the lines myself, you might want to post the code you used.

 

[theDBguy]

I didn't try drawing the lines myself, you might want to post the code you used.

Hi. Sorry for the confusion. I drew them manually (no code needed - I just used four lines).

 

[Pat Hartman]

OK, that makes sense. Since the lines are a separate control, they would not be impacted by the control they are surrounding having its visible property set to no. yunshun would only have to draw lines manually around the controls that are set to hide duplicates. I guess I never noticed this because I don't normally enclose fields in boxes.