Solved Delete a grouping in an access report (1 Viewer)

[zelarra821]

Hello, I have a report that I have structured as follows:

I would like to remove the grouping "Mes1" using VBA.

I have tried this code but it doesn't work:

Me.Section(0).Visible = False

Does anyone have any idea how I can get it? I could create another report, and have one for the annual reports, and another for the monthly reports, but if I can have it all in one, well, I save space.

Thank you.

 

[theDBguy]

Hi. See if you could start here.

Report.GroupLevel property (Access)

Office VBA reference topic

docs.microsoft.com

 

[zelarra821]

i got it this way:

Reports("ReportName").GroupLevel(0).ControlSource = "Año"
Reports("ReportName").GroupLevel(1).ControlSource = "Estado"
Reports("ReportName").EncabezadoMes.Visible = False

you can check this article

MS Access Report – dynamically collapse groups

jkafer.com

Thanks a lot.

 

[theDBguy]

i got it this way:

Reports("ReportName").GroupLevel(0).ControlSource = "Año"
Reports("ReportName").GroupLevel(1).ControlSource = "Estado"
Reports("ReportName").EncabezadoMes.Visible = False

you can check this article

MS Access Report – dynamically collapse groups

jkafer.com

Thanks a lot.

Hi. Glad to hear you got it sorted out. Good luck with your project.