Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-06-2019, 11:48 AM   #1
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 86
Thanks: 41
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Two Headers on same report page - Possible?

Google didn't have anything on this. So, I'm here asking the forum this
question: Can an Access 2007 db report have two headers on the same page?

My customer has asked me to create a single page report with
two separate headers: one with 6 columns of trucking trip travel data &
one with the trips fuel purchase information.

A 'stream-driven' method that I thought of was to produce the two reports, individually, and export them to a word file.

Thank you, in advance, for even reading this post.

Punice is offline   Reply With Quote
Old 08-06-2019, 11:59 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,135
Thanks: 46
Thanked 970 Times in 951 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Two Headers on same report page - Possible?

Hmm, not sure I understand the question but have you tried using subreports, maybe?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Punice (08-07-2019)
Old 08-06-2019, 12:20 PM   #3
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,967
Thanks: 13
Thanked 1,535 Times in 1,461 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Two Headers on same report page - Possible?

Typically data does not go into a header. A header includes the name of the report, the date, maybe the page number. The detail section of a report includes the data.

As has already been suggested, you might want to use two subreports in the detail section. Or details for one of the types of data and a subreport for the other. I can't really tell from your description but it sounds like both of the sets of data could contain multiple rows and the rows are not related to each other. Maybe the main report should be bound to the truck table and contain the static data about the truck. Then the two subreports would appear on top of each other in the detail section. Side-by-side might work but it depends on how different they are from each other in length.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
Punice (08-07-2019)
Old 08-07-2019, 06:48 AM   #4
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 86
Thanks: 41
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Talking Re: Two Headers on same report page - Possible?

I guess that I wasn't clear. I understand what you said about 'headings'. What I need is, let's say for the column headings that are created be a the top of one report and, below it, another set of column headings for the bottom report. Then, the actual report's data fields will appear under the them in the normal manner.

Meanwhile, I'll investigate what sub-reports are, etc. Thanks Troops

PS: I just saw a post that suggested that one could create a conventional report for the first report and create the second report in the footer.

Don't know if that will work, but it's worth a try.

Last edited by Punice; 08-07-2019 at 06:55 AM.
Punice is offline   Reply With Quote
Old 08-07-2019, 07:38 AM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,967
Thanks: 13
Thanked 1,535 Times in 1,461 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Two Headers on same report page - Possible?

Reports and forms are based on recordsets. A recordset has columns. EVERY row is formatted IDENTICALLY. Column 1 is Rirstname, column 2 is DOB, column 3 is xxx, etc. You can't switch part way through so that Column 1 is now StartDate, column 2, is PartName, etc.

A relational database is VERY different from a spreadsheet. A spreadsheet has the ability to support individual definitions for every "cell" which is the intersection of a row and a column.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
Punice (08-07-2019)
Old 08-07-2019, 09:55 AM   #6
Punice
Newly Registered User
 
Join Date: May 2010
Location: Middletown, VA
Posts: 86
Thanks: 41
Thanked 1 Time in 1 Post
Punice is on a distinguished road
Re: Two Headers on same report page - Possible?

FYI Pat, I created a report where the 'Date' column was in the middle of the report and was able, in design view, to highlight it an move it to the left hand side of the report using the left arrow key on my keyboard. Is that what you said that I could achieve? Maybe I am not understanding all that you stated. Thanks
Punice is offline   Reply With Quote
Old 08-07-2019, 10:47 AM   #7
plog
AWF VIP
 
Join Date: May 2011
Posts: 9,326
Thanks: 10
Thanked 2,264 Times in 2,216 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Two Headers on same report page - Possible?

Punice, words aren't working. Perhaps you can make a mock-up of what you hope the report looks like. Either in Word, Excel or even Paint.


plog is offline   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
Punice (08-08-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouped Report: Page (n of n) and Page Headers Bombshell Disaster Reports 1 01-20-2012 12:23 PM
Diffrent page headers in report dealwi8me Reports 4 08-05-2009 07:49 AM
Displaying headers on a new page within a report Nova_C Reports 4 05-03-2002 06:59 AM
Subreport page headers and page breaks? PaulA Reports 2 11-02-2001 03:15 PM
Group Headers above Page Headers Val Reports 1 05-17-2000 05:45 PM




All times are GMT -8. The time now is 04:00 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World