By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

Report formating problem

P: n/a
I have a report with 2 sub reports on it.
The report is an invoice and the sub reports are dropping data onto the invoice.
This worked fine if generating 1 invoice at a time.
I am trying to create a run of invoices. I would like the appropriate data for
each custid from each sub report to be on the same page. The nearest I can get
is 2 pages for each customer
Any Thoughts
TIA
David B
Hexham UK

Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
1. Put the data for the main report in the report header
2. Put the two subreports in the detail section of the main report
3. Make the height of each subreport control 1" and set the can grow property
to True
4. Put any invoice totals in the footer of the main report

To fit on one page, the total number of lines in the main report and the two
subreports plus any attendant vertical space in the main report and the two
subreports must fit on one page. Do they?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
I have a report with 2 sub reports on it.
The report is an invoice and the sub reports are dropping data onto the invoice. This worked fine if generating 1 invoice at a time.
I am trying to create a run of invoices. I would like the appropriate data for
each custid from each sub report to be on the same page. The nearest I can get
is 2 pages for each customer
Any Thoughts
TIA
David B
Hexham UK

Nov 12 '05 #2

P: n/a
Thanks for the reply. Yep done all your points.
What I am getting is
P1 Cust 1 data from subrep1
P2 Cust 1 data from subrep 2
P3 Cust 2 data from subrep 1
P4 Cust 2 data from subrep 2
etc

I need all Cust 1 data on 1 page. They fit fine if just producing 1 invoice.
I am working on a month end routine where all customers invoices are produced at
once
Reason for 2 reports is that first is from a reservations table.- Use of Arena,
Cross country course etc.
2nd is a sales table. Hay, Straw, Blacksmith etc.
I couldn`t find a way of putting the 2 together
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:JO*****************@newsread2.news.atl.earthl ink.net...
1. Put the data for the main report in the report header
2. Put the two subreports in the detail section of the main report
3. Make the height of each subreport control 1" and set the can grow property
to True
4. Put any invoice totals in the footer of the main report

To fit on one page, the total number of lines in the main report and the two
subreports plus any attendant vertical space in the main report and the two
subreports must fit on one page. Do they?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
I have a report with 2 sub reports on it.
The report is an invoice and the sub reports are dropping data onto the

invoice.
This worked fine if generating 1 invoice at a time.
I am trying to create a run of invoices. I would like the appropriate data for each custid from each sub report to be on the same page. The nearest I can get is 2 pages for each customer
Any Thoughts
TIA
David B
Hexham UK



Nov 12 '05 #3

P: n/a
You don't say anything about data on the main report so I presume there is none
and the main report only houses the two subreports. If you have both subreports
in the detail section, then the only thing that can make subreport 2 go to a new
page after subreport 1 is either subreport 1 takes up a whole page or you have a
page break bretween subreport 1 and subreport 2. Look carefully for this - it's
just three small dots at the left side of the detail section.

Steve
PC Datasheet
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
Thanks for the reply. Yep done all your points.
What I am getting is
P1 Cust 1 data from subrep1
P2 Cust 1 data from subrep 2
P3 Cust 2 data from subrep 1
P4 Cust 2 data from subrep 2
etc

I need all Cust 1 data on 1 page. They fit fine if just producing 1 invoice.
I am working on a month end routine where all customers invoices are produced at once
Reason for 2 reports is that first is from a reservations table.- Use of Arena, Cross country course etc.
2nd is a sales table. Hay, Straw, Blacksmith etc.
I couldn`t find a way of putting the 2 together
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:JO*****************@newsread2.news.atl.earthl ink.net...
1. Put the data for the main report in the report header
2. Put the two subreports in the detail section of the main report
3. Make the height of each subreport control 1" and set the can grow property
to True
4. Put any invoice totals in the footer of the main report

To fit on one page, the total number of lines in the main report and the two
subreports plus any attendant vertical space in the main report and the two
subreports must fit on one page. Do they?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
I have a report with 2 sub reports on it.
The report is an invoice and the sub reports are dropping data onto the

invoice.
This worked fine if generating 1 invoice at a time.
I am trying to create a run of invoices. I would like the appropriate data

for each custid from each sub report to be on the same page. The nearest I can get is 2 pages for each customer
Any Thoughts
TIA
David B
Hexham UK


Nov 12 '05 #4

P: n/a
So where should the force new page be.
Main report has customer details on
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:xs****************@newsread2.news.atl.earthli nk.net...
You don't say anything about data on the main report so I presume there is none and the main report only houses the two subreports. If you have both subreports in the detail section, then the only thing that can make subreport 2 go to a new page after subreport 1 is either subreport 1 takes up a whole page or you have a page break bretween subreport 1 and subreport 2. Look carefully for this - it's just three small dots at the left side of the detail section.

Steve
PC Datasheet
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
Thanks for the reply. Yep done all your points.
What I am getting is
P1 Cust 1 data from subrep1
P2 Cust 1 data from subrep 2
P3 Cust 2 data from subrep 1
P4 Cust 2 data from subrep 2
etc

I need all Cust 1 data on 1 page. They fit fine if just producing 1 invoice.
I am working on a month end routine where all customers invoices are produced
at
once
Reason for 2 reports is that first is from a reservations table.- Use of

Arena,
Cross country course etc.
2nd is a sales table. Hay, Straw, Blacksmith etc.
I couldn`t find a way of putting the 2 together
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:JO*****************@newsread2.news.atl.earthl ink.net...
1. Put the data for the main report in the report header
2. Put the two subreports in the detail section of the main report
3. Make the height of each subreport control 1" and set the can grow

property to True
4. Put any invoice totals in the footer of the main report

To fit on one page, the total number of lines in the main report and the two subreports plus any attendant vertical space in the main report and the two subreports must fit on one page. Do they?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
> I have a report with 2 sub reports on it.
> The report is an invoice and the sub reports are dropping data onto the
invoice.
> This worked fine if generating 1 invoice at a time.
> I am trying to create a run of invoices. I would like the appropriate

data for
> each custid from each sub report to be on the same page. The nearest I
can get
> is 2 pages for each customer
> Any Thoughts
> TIA
> David B
> Hexham UK
>



Nov 12 '05 #5

P: n/a
Remove the force new page. Put the customer details of the main report at the
top of the main report'd detail section. Then below that put your two
subreports. Below the bottom subreport put a page break.

Steve
PC Datasheet
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
So where should the force new page be.
Main report has customer details on
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:xs****************@newsread2.news.atl.earthli nk.net...
You don't say anything about data on the main report so I presume there is none
and the main report only houses the two subreports. If you have both

subreports
in the detail section, then the only thing that can make subreport 2 go to a

new
page after subreport 1 is either subreport 1 takes up a whole page or you have a
page break bretween subreport 1 and subreport 2. Look carefully for this -

it's
just three small dots at the left side of the detail section.

Steve
PC Datasheet
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
Thanks for the reply. Yep done all your points.
What I am getting is
P1 Cust 1 data from subrep1
P2 Cust 1 data from subrep 2
P3 Cust 2 data from subrep 1
P4 Cust 2 data from subrep 2
etc

I need all Cust 1 data on 1 page. They fit fine if just producing 1

invoice. I am working on a month end routine where all customers invoices are produced
at
once
Reason for 2 reports is that first is from a reservations table.- Use of

Arena,
Cross country course etc.
2nd is a sales table. Hay, Straw, Blacksmith etc.
I couldn`t find a way of putting the 2 together
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:JO*****************@newsread2.news.atl.earthl ink.net...
> 1. Put the data for the main report in the report header
> 2. Put the two subreports in the detail section of the main report
> 3. Make the height of each subreport control 1" and set the can grow

property
> to True
> 4. Put any invoice totals in the footer of the main report
>
> To fit on one page, the total number of lines in the main report and the

two > subreports plus any attendant vertical space in the main report and the two > subreports must fit on one page. Do they?
>
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> re******@pcdatasheet.com
> www.pcdatasheet.com
>
>
> "David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
> news:bp**********@news8.svr.pol.co.uk...
> > I have a report with 2 sub reports on it.
> > The report is an invoice and the sub reports are dropping data onto the > invoice.
> > This worked fine if generating 1 invoice at a time.
> > I am trying to create a run of invoices. I would like the appropriate data for
> > each custid from each sub report to be on the same page. The nearest I can get
> > is 2 pages for each customer
> > Any Thoughts
> > TIA
> > David B
> > Hexham UK
> >
>
>


Nov 12 '05 #6

P: n/a
Got it. Thanks for your help.
DB

PC Datasheet <sp**@nospam.spam> wrote in message
news:Kz****************@newsread1.news.atl.earthli nk.net...
Remove the force new page. Put the customer details of the main report at the
top of the main report'd detail section. Then below that put your two
subreports. Below the bottom subreport put a page break.

Steve
PC Datasheet
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
So where should the force new page be.
Main report has customer details on
David B

PC Datasheet <sp**@nospam.spam> wrote in message
news:xs****************@newsread2.news.atl.earthli nk.net...
You don't say anything about data on the main report so I presume there is

none
and the main report only houses the two subreports. If you have both

subreports
in the detail section, then the only thing that can make subreport 2 go to a
new
page after subreport 1 is either subreport 1 takes up a whole page or you have
a
page break bretween subreport 1 and subreport 2. Look carefully for this -

it's
just three small dots at the left side of the detail section.

Steve
PC Datasheet
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:bp**********@news8.svr.pol.co.uk...
> Thanks for the reply. Yep done all your points.
> What I am getting is
> P1 Cust 1 data from subrep1
> P2 Cust 1 data from subrep 2
> P3 Cust 2 data from subrep 1
> P4 Cust 2 data from subrep 2
> etc
>
> I need all Cust 1 data on 1 page. They fit fine if just producing 1

invoice.
> I am working on a month end routine where all customers invoices are

produced
at
> once
> Reason for 2 reports is that first is from a reservations table.- Use
of Arena,
> Cross country course etc.
> 2nd is a sales table. Hay, Straw, Blacksmith etc.
> I couldn`t find a way of putting the 2 together
> David B
>
>
>
> PC Datasheet <sp**@nospam.spam> wrote in message
> news:JO*****************@newsread2.news.atl.earthl ink.net...
> > 1. Put the data for the main report in the report header
> > 2. Put the two subreports in the detail section of the main report
> > 3. Make the height of each subreport control 1" and set the can grow
property
> > to True
> > 4. Put any invoice totals in the footer of the main report
> >
> > To fit on one page, the total number of lines in the main report and

the two
> > subreports plus any attendant vertical space in the main report and
the two
> > subreports must fit on one page. Do they?
> >
> >
> > --
> > PC Datasheet
> > Your Resource For Help With Access, Excel And Word Applications
> > re******@pcdatasheet.com
> > www.pcdatasheet.com
> >
> >
> > "David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
> > news:bp**********@news8.svr.pol.co.uk...
> > > I have a report with 2 sub reports on it.
> > > The report is an invoice and the sub reports are dropping data onto the > > invoice.
> > > This worked fine if generating 1 invoice at a time.
> > > I am trying to create a run of invoices. I would like the

appropriate data
> for
> > > each custid from each sub report to be on the same page. The nearest
I can
> get
> > > is 2 pages for each customer
> > > Any Thoughts
> > > TIA
> > > David B
> > > Hexham UK
> > >
> >
> >
>



Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.