|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2009, 06:42 PM
posted to microsoft.public.access.reports
|
|||
|
|||
group on first line instead of offset
I have a feature question that I don't know if it exists. In an access 2007
report, I have a group setup to contain a client group and then below it is the individual clients and other information. From a formatting perspective I would like to have that group name be on the same row (or on the same level however it is stated) of the first client in that group. i.e. Group1 Client1 Client2 Group2 Client3 Is that possible? 
|
|
#2
September 21st, 2009, 06:59 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
group on first line instead of offset
icccapital wrote:
I have a feature question that I don't know if it exists. In an access 2007 report, I have a group setup to contain a client group and then below it is the individual clients and other information. From a formatting perspective I would like to have that group name be on the same row (or on the same level however it is stated) of the first client in that group. i.e. Group1 Client1 Client2 Group2 Client3 Add a line of code to the group header's Format event procedu Me.MoveLayout = False -- Marsh MVP [MS Access]
|
|
#3
September 21st, 2009, 07:04 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
group on first line instead of offset
Add the group control to the same line.
Set the control's Hide Duplicates property to yes (property is on the format tab. Now the control will not print when it has the same as the previous record. It MIGHT repeat on the next page. I can't recall. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County icccapital wrote: I have a feature question that I don't know if it exists. In an access 2007 report, I have a group setup to contain a client group and then below it is the individual clients and other information. From a formatting perspective I would like to have that group name be on the same row (or on the same level however it is stated) of the first client in that group. i.e. Group1 Client1 Client2 Group2 Client3 Is that possible?
|
|
#4
September 21st, 2009, 07:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
group on first line instead of offset
Thanks John,
While Marshall's suggestion was a good one as well, this one will work better for my purposes. Thanks to you both, i didn't know about those features. "John Spencer" wrote: Add the group control to the same line. Set the control's Hide Duplicates property to yes (property is on the format tab. Now the control will not print when it has the same as the previous record. It MIGHT repeat on the next page. I can't recall. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County icccapital wrote: I have a feature question that I don't know if it exists. In an access 2007 report, I have a group setup to contain a client group and then below it is the individual clients and other information. From a formatting perspective I would like to have that group name be on the same row (or on the same level however it is stated) of the first client in that group. i.e. Group1 Client1 Client2 Group2 Client3 Is that possible?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
