Re: Printing Different first page headers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Jeff,

I am going to try and paste in output exported from my problematic report
into Word:

[Page 1 for customer Prints fine like this]

Company Name
Dealer Purchases Report
For the Year 2005
Cust # 1896 Salesperson JEFFREYF
Dealer Customer
Address Street 123
City CitySomewhere
Phon
ST IL
Contac Name
Zip 60436
2005 2006
Actual Projected
Product History by Product Class Q1 Q2 Q3 Q4 TOTAL Q1 Q2 Q3 Q4
105 TR 80% XR FurnTDD040C924F XR80 40BTU 14.5 6 6 2 2 2 2 10 10
105 TR 80% XR FurnTDD060C936F XR80 60BTU 14.5 7 7 4 4 3 3 7 7 21 21
105 TR 80% XR FurnTDD120C960F XR80 120BTU 1 1 1 1
105 TR 80% XR FurnTDD140C960F XR80 140BTU 1 1 1 1 2 2
105 TR 80% XR FurnTDD1B080A9361A XR80 80BTU 20 20 15 15 26 26 12 12 73 73
105 TR 80% XR FurnTDD1B100A9451A XR80 100BTU 2 2 1 1 3 3 6 6
105 TR 80% XR FurnTUD040C924K XR80 40BTU 14.5 1 1 1 1
105 TR 80% XR FurnTUD060C936K XR80 60BTU 14.5 0 0 1 1 2 2 1 1 4 4
105 TR 80% XR FurnTUD080C936K XR80 80BTU 17.5 21 21 35 35 36 36 27 27 119 119
105 TR 80% XR FurnTUD100C948K XR80 100BTU 73 73 132 132 112 112 93 93 410 410


[Page 2 for same customer prints fine like this]
2005 2006
Actual Projected
Product History by Product Class Q1 Q2 Q3 Q4 TOTAL Q1 Q2 Q3 Q4
105 TR 80% XR FurnTUD120C960K XR80 120BTU -1 -1 -1 -1
105 TR 80% XR FurnTUD1B100A9451A XR80 100BTU 1 1 1 1 5 5 3 3 10 10
105 TR 80% XR FurnTUD1C120A9541A XR80 120BTU 46 46 82 82 69 69 36 36 233 233
105 TR 80% XR FurnTUD1D140A9601A XR80 140BTU 24 24 33 33 30 30 23 23 110 110

[Page 3 for new customer is the problem because it looks like this]

I don't} 2005 2006
want } Actual Projected
this to} Product History by Product Class Q1 Q2 Q3 Q4 TOTAL Q1 Q2 Q3 Q4
print }
here }
Company, Inc
Dealer Purchases Report
For the Year 2005
Cust # 9999 Salesperson ISR
Dealer Another new customer
Address Streets somewhere
City CityInUSA
Phon 847-999-9999
ST IL
Contac ME
Zip 60999
2005 2006
Actual Projected
Product History by Product Class Q1 Q2 Q3 Q4 TOTAL Q1 Q2 Q3 Q4
100 TR 80% XB FurnTUE080A936L XB80 80BTU 17.5 1 1 1 1

Jeff, if this still doesn't make sense to you, let me know if there is any
way I can email you the output. I think you will see the problem more
clearly.

Thanks for your persistence in helping me.
Tom
"Jeff Boyce" wrote:

> Tom
>
> I'm not there, so this is just a thought...
>
> Could you do your "detail" report as a subreport, with it's own headers,
> then embed that under your Customer section?
>
> --
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Cat's Meow" <CatsMeow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:7C26FD70-C81A-4F75-A79E-4182E7632DC4@xxxxxxxxxxxxxxxx
> > Jeff,
> >
> > That is where it is. It is included within the Customer Header section of
> > the report, but the problem comes in when the data is longer than will fit
> on
> > one page and spills over to page 2, 3, etc. On page 2, 3, etc within the
> > same customer, I want their to be column headings over the detail. When a
> > new customer occurs, I don't want the Page Header to print, just the
> Customer
> > Header (which includes the column labels for page 1).
> >
> > I will look forward to your response. Thanks Jeff.
> > Tom
> >
> > "Jeff Boyce" wrote:
> >
> > > Tom
> > >
> > > If you want your "Q" headers to only print when there's a product
> > > (underneath a customer), could you put it underneath the customer
> > > information in the customer header?
> > >
> > > --
> > > Regards
> > >
> > > Jeff Boyce
> > > <Office/Access MVP>
> > >
> > > "Cat's Meow" <CatsMeow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:CCD3BF15-2DA5-408E-A7D2-6C667F257886@xxxxxxxxxxxxxxxx
> > > > Jeff,
> > > >
> > > > Let me try this again. This is really important and I'm trying to
> figure
> > > > out if it something I have to do in VBA or if it something that can
> easily
> > > be
> > > > done within the Report program within Access. The hierarchy of my
> report
> > > is:
> > > >
> > > > Sort By: Customer - Product Group - Product
> > > > Group By: Customer - Product Group
> > > >
> > > >
> > > > This is how my report prints right now:
> > > >
> > > > {No Report Header
> > > >
> > > > Customer Name {Customer Header Fields
> > > > Address
> > > > City, State zip
> > > > Phone
> > > >
> > > > Product Q1 Q2 Q3 Q4 {Customer Header Labels
> > > > ProductX xx xx xx xx {Detail Records
> > > >
> > > >
> > > > [Page 2, Same Customer]
> > > >
> > > > Product Q1 Q2 Q3 Q4 {Page Header
> > > > ProductX xx xx xx xx {Detail Records
> > > >
> > > > [Page 3, New Customer]
> > > >
> > > > Product Q1 Q2 Q3 Q4 {Page Header
> > > >
> > > > Customer Name {Customer Header Fields
> > > > Address
> > > > City, State zip
> > > > Phone
> > > >
> > > > Product Q1 Q2 Q3 Q4 {Customer Header Labels
> > > > ProductX xx xx xx xx {Detail Records
> > > >
> > > > And therein is my problem. Because the page header prints on the new
> page
> > > > AND my Customer Header prints because it is a new customer, my column
> > > > headings print twice. I want my page three to look like this for a
> new
> > > > customer:
> > > >
> > > > [Page 3, New Customer]
> > > >
> > > >
> > > > Customer Name {Customer Header Fields
> > > > Address
> > > > City, State zip
> > > > Phone
> > > >
> > > > Product Q1 Q2 Q3 Q4 {Customer Header Labels
> > > > ProductX xx xx xx xx {Detail Records
> > > >
> > > > Thanks for your quick response.
> > > > Tom
> > > >
> > > >
> > > >
> > > > "Jeff Boyce" wrote:
> > > >
> > > > > Sorry, but I'm still confused. Your example of how you want it to
> look
> > > when
> > > > > the customer changes:
> > > > >
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > > >
> > > > > >
> > > > > > Customer Information
> > > > > >
> > > > > >
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > >
> > > > > includes what I would describe as "detail" info BEFORE your (new)
> > > customer
> > > > > information. How does that work?
> > > > >
> > > > > <see additional comments in-line below>
> > > > >
> > > > > Regards
> > > > >
> > > > > Jeff Boyce
> > > > > <Office/Access MVP>
> > > > >
> > > > > "Cat's Meow" <CatsMeow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > > news:41206A2E-A643-45DC-BABD-F01FE8B33796@xxxxxxxxxxxxxxxx
> > > > > > Thanks Jeff for your fast response!
> > > > > > To preserve printing space on the report, here is the hierarchy of
> my
> > > > > report.
> > > > > >
> > > > > > Sort By: Customer - Product Group - Product
> > > > > > Group By: Customer - Product Group
> > > > > >
> > > > > > Within the Customer Header, I have the first page of column
> headings
> > > > > defined:
> > > > > >
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > >
> > > > > I don't see the customer information here, in what you've described
> as
> > > the
> > > > > Customer Header.
> > > > >
> > > > > >
> > > > > > If the detail spills over to a second page, I just want the fields
> > > > > > identified above to print on pages 2, 3 etc.
> > > > > >
> > > > > > When the customer changes, then a new page prints and my Page
> Header
> > > and
> > > > > my
> > > > > > customer Header print. It looks something like this:
> > > > > >
> > > > >
> > > > > I don't understand ... what information are you placing in the Page
> > > Header?
> > > > >
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > > >
> > > > > >
> > > > > > Customer Information
> > > > > >
> > > > > >
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > > >
> > > > > > On the new customer information page, I want it to look like this:
> > > > >
> > > > > Is this a repeat of what you just said above?
> > > > >
> > > > > >
> > > > > > Customer Information
> > > > > >
> > > > > >
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > > >
> > > > > > <New page continuation within same customer>
> > > > > > Product Q1 Q2 Q3 Q4
> > > > > > Detail Records XX XX XX XX
> > > > > >
> > > > > >
> > > > > > "Jeff Boyce" wrote:
> > > > > >
> > > > > > > I may not fully understand your report design. If you have
> changing
> > > > > > > customer, plus details for each customer, couldn't you put the
> > > customer
> > > > > > > "header" information in the Customer header? This assumes you
> have
> > > > > grouped
> > > > > > > by Customer.
> > > > > > >
> > > > > > > What am I missing?
> > > > > > >
> > > > > > > --
> > > > > > > Regards
> > > > > > >
> > > > > > > Jeff Boyce
> > > > > > > <Office/Access MVP>
> > > > > > >
> > > > > > > "Cat's Meow" <CatsMeow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message
> > > > > > > news:26C28C58-F57A-4A27-A112-A3ACBCF97E31@xxxxxxxxxxxxxxxx
> > > > > > > > I have an Access report that provides information by customer
> and
> > > a
> > > > > number
> > > > > > > of
> > > > > > > > pages of detail that will follow. I want to create a common
> look
> > > to
> > > > > the
> > > > > > > > first page, but on the second pages and following I want to
> > > display
> > > > > the
> > > > > > > > column headings that I've defined within my Page header
> section of
> > > the
> > > > > > > > report. Every time the customer chages, I want the customer
> > > header to
> > > > > > > > display, but not the page header. Access indicates that there
> is
> > > only
> > > > > 3
> > > > > > > > groupings that control the Page Header -- Print With Report
> > > header,
> > > > > Print
> > > > > > > > with Report Footer, and don't print with either. How do I do
> > > this?
> > > > > Thank
> > > > > > > > you in advance.
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
>
.

Relevant Pages

  • Subreport not working right
    ... header and created the groupheader as you'd suggested. ... with the relevant data in the subreport. ... all the individual customer reports ... How can I force the report for each customer to show on ...
    (microsoft.public.access.reports)
  • Re: Report Problem
    ... create a Problem header and place the ... check Allen Browne's report tips. ... >>> particular customer. ... I want to display the problem once and all the ...
    (microsoft.public.access.reports)
  • Report detail col heading problems
    ... The query contains multiple ... I want the report to print a header page for each customer. ...
    (microsoft.public.access.reports)
  • Re: Printing Different first page headers
    ... same customer, I want their to be column headings over the detail. ... new customer occurs, I don't want the Page Header to print, just the Customer ... "Jeff Boyce" wrote: ... >> done within the Report program within Access. ...
    (microsoft.public.access.reports)
  • Re: Subreport not in sync with Main Report
    ... In report design view, right-click the grey bar over the CustomerID Header ... > suggested that I should create a customer ID groupheader ... >>> I created a Subreport within a Main Report and the links ...
    (microsoft.public.access.forms)