Multi Column Report - show first column only once

[bharlow]

I have multi column report that goes over then down and I need to figure out how to only show the first column once. The first column is the date which is the same for every store so it does not need to repeat with each column.

What I have:
STORE 1 STORE 2 STORE 3
Date TY LY +/- Date TY LY +/- Date TY LY +/-

What I want is:
STORE 1 STORE 2 STORE 3
Date TY LY +/- TY LY +/- TY LY +/-

Thank you for any suggestions.

 

[boblarson]

Go into the report in design view, select the control for the field you just want to see once and go to properties and select YES for the property - HIDE DUPLICATES.

 

[bharlow]

Hi Bob,

That does not appear to work for multi column reporting. I can get that to work fine for regular reports but when I set the property to hide duplicates in the multi column version it does not do anything. Also, I would need the first column of dates to show up on the second page as part of the multi column over then down.

As always, I appreciate your advice.

 

[boblarson]

Hi Bob,

That does not appear to work for multi column reporting. I can get that to work fine for regular reports but when I set the property to hide duplicates in the multi column version it does not do anything. Also, I would need the first column of dates to show up on the second page as part of the multi column over then down.

Well, I think you're moving into some very complex territory there. I'm not sure that it can be done, but if it can it is likely going to take a bit of coding to accomplish. You may not be able to make it do that. Maybe someone else has some ideas.

 

[vbaInet]

You could try setting the visibility of the control in code by counting and making it invisible if it is above 1. Reset the number to 1 at the group header section. The code for counting will go in the detail section:

Me.txtbox1.visible = (counter = 1)

But there will be spaces of course.

Another way would be to create another multicolumn report just for the dates, but you will retrieve only Unique dates. Group the same way too.