[AccessD] Brain Fart on Report grouping

[Dan Waters]

Hi Ryan,

I don’t know of a non-code way to solve this but your code solution looks elegant to me!

Nice work,
Dan

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Ryan W<mailto:wrwehler at gmail.com>
Sent: Wednesday, January 24, 2018 09:58
To: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com>
Subject: [AccessD] Brain Fart on Report grouping

I have a report that's grouped by Client name, each grouping has a footer
that draws a line (thickness 1) to help break the report up between clients.

At the end of the report, I have a REPORT footer that draws a line
(thickness 2) with some statistics under it.


Right now, when the last group footer prints a line, and the report footer
prints it's line they're stacked on top of each other. I could have sworn
there was some magic wizardry I've done in the past to not draw that last
grouped footer line relatively easily.  I have a solution that works NOW
but it feels like kludge.


Basically I have a global report variable defined at the top "strClient"


In Report_Open event I set that variable using:

strClient =  DMax("ClientName", "Table")

For GroupFooter1_Print event I have :

Me.LineName.visible = not (Me.ClientName = strClientName)

It works but as I said feels Kludgy.

Thoughts?
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com