473,320 Members | 1,802 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How can I display the group header every time there is a new page of detail records?

I used the Report Wizard to create a report that is generally working
pretty well.

However, it set up the structure as follows:
Report
Page Header
Group 1 Header - Header for the group
Group 2 Header - This has my column headings
for the details.
Details
Group 2 Footer - This has the summary of details.
Page Footer

I want the Group 2 header whenever the Details section starts a new
page. The page header and footer seem to have been put in
automatically and have nothing in them.

How can I get the Group 2 header to print whenever the details start a
new page?

Did I miss something in the wizard that would have accomplished this?

Thanks.

Greg
Cincinnati OH USA
Nov 13 '05 #1
3 26624
Open the report in design mode and right click the title bar for Group 2
Header, choose Properties. On the Format tab set Repeat Section to Yes.

--
Wayne Morgan
MS Access MVP
"Greg Teets" <gt******@yahoo.com> wrote in message
news:06********************************@4ax.com...
I used the Report Wizard to create a report that is generally working
pretty well.

However, it set up the structure as follows:
Report
Page Header
Group 1 Header - Header for the group
Group 2 Header - This has my column headings
for the details.
Details
Group 2 Footer - This has the summary of details.
Page Footer

I want the Group 2 header whenever the Details section starts a new
page. The page header and footer seem to have been put in
automatically and have nothing in them.

How can I get the Group 2 header to print whenever the details start a
new page?

Did I miss something in the wizard that would have accomplished this?

Thanks.

Greg
Cincinnati OH USA

Nov 13 '05 #2
On Wed, 17 Aug 2005 00:18:57 GMT, "Wayne Morgan"
<co***************************@hotmail.com> wrote:
Open the report in design mode and right click the title bar for Group 2
Header, choose Properties. On the Format tab set Repeat Section to Yes.


Thanks.
Nov 13 '05 #3
Greg Teets wrote:
Did I miss something in the wizard that would have accomplished this?


Dunno about the wiz, don't think there's anything there. However, this
is easy to do.

CLick on the grey bar that is the top of your header so that it's
highlighted black.

If the properties window is not open, press Alt-Enter. The top of the
properties window will say something like GroupHeader1 or 2 or 0 or
something. Anyway, on the format tab, Find the property that says
"Repeat Section" and set it to yes.

THen you're all set.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Simone | last post by:
Hello. I am using the code below: ------------------------------------------- Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Section(0).BackColor = vbWhite Then...
6
by: Chuck | last post by:
I have a report with three columns, accross then down, and two groups. Currently the group headers are only one column wide and appear in the left hand column. How can I make the group header be...
2
by: Ross Hamilton | last post by:
Can anyone help me with this small problem. I have a report that is divided into 3 Columns using the page setup, It displays the report fields in 3 separate columns (Desc & Pg Num) but it only...
1
by: David Horowitz | last post by:
Hi folks. I need to create a report that has a Group Header that pulls certain data from the Detail section. It's something like this: +--Report---------------------------------------- |...
1
by: Beowulf | last post by:
I'm having some difficulty and I can't for the life of me figure out why. I have a main report, rptMain, that contains a report header (displays the AppTitle), 3 group headers (one is a header...
3
by: Meena | last post by:
Hi Every Body, I have created a crystal Report and linked to my vb.net forms and working fine, I added more drill drowns in groups everything fine, but What I need is I am not able to display...
0
by: Arnold | last post by:
Hi Everyone; In a report, I've essentially recreated a paper sheet by adding various labels--name, date, problem, year, Progress Notes, etc.--and horizontal lines (people have traditionally...
4
by: LF | last post by:
Hello, I have a database with a table of projects and a table of tasks (each project can have multiple tasks). I have a report that has a group header for the project name, etc., and then the...
4
by: DavidB | last post by:
Im not sure if I am missing something obvious here or not so excuse me if this is a DFU question please... I have a report I am working on that includes the following data. Agency Name Vendor...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.