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 6 2699
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******@pcdata sheet.com www.pcdatasheet.com
"David B" <da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:bp******** **@news8.svr.po l.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
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.sp am> wrote in message
news:JO******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com www.pcdatasheet.com
"David B" <da***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.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
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***@marleyco tenospam.fsnet. co.uk> wrote in message
news:bp******** **@news8.svr.po l.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.sp am> wrote in message news:JO******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com www.pcdatasheet.com
"David B" <da***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.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
So where should the force new page be.
Main report has customer details on
David B
PC Datasheet <sp**@nospam.sp am> wrote in message
news:xs******** ********@newsre ad2.news.atl.ea rthlink.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***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.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.sp am> wrote in message news:JO******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com www.pcdatasheet.com
"David B" <da***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.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 >
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***@marleyco tenospam.fsnet. co.uk> wrote in message
news:bp******** **@news8.svr.po l.co.uk... So where should the force new page be. Main report has customer details on David B
PC Datasheet <sp**@nospam.sp am> wrote in message news:xs******** ********@newsre ad2.news.atl.ea rthlink.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***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.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.sp am> wrote in message news:JO******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com > www.pcdatasheet.com > > > "David B" <da***@marleyco tenospam.fsnet. co.uk> wrote in message > news:bp******** **@news8.svr.po l.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 > > > >
Got it. Thanks for your help.
DB
PC Datasheet <sp**@nospam.sp am> wrote in message
news:Kz******** ********@newsre ad1.news.atl.ea rthlink.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***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.co.uk... So where should the force new page be. Main report has customer details on David B
PC Datasheet <sp**@nospam.sp am> wrote in message news:xs******** ********@newsre ad2.news.atl.ea rthlink.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***@marleyco tenospam.fsnet. co.uk> wrote in message news:bp******** **@news8.svr.po l.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.sp am> wrote in message > news:JO******** *********@newsr ead2.news.atl.e arthlink.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******@pcdata sheet.com > > www.pcdatasheet.com > > > > > > "David B" <da***@marleyco tenospam.fsnet. co.uk> wrote in message > > news:bp******** **@news8.svr.po l.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 > > > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave Smithz |
last post by:
Hi there,
A client of mine wants to start generating some reports from their PHP /
MYSQL database.
They were previously gathering data from the screen and cutting and pasting
it into a Word document template. They now just want to generate it.
My initial thoughts are to just format the information in a table and then
they print it out. But due to the dynamic nature of the reports and what is
|
by: Lee |
last post by:
As the subject states, I have been playing in the system trying to
figure out a method of using a report as the email body text.
So far, the closest I have come is the acFormatHTML. However, when
the report is more than one page, it autoformats the report to
multiple pages. I need one document.
Reason for doing this as text vs. attachment is in order to make the
message easier to view for the reader/receipent.
|
by: jaYPee |
last post by:
I have a report created in crystal report. My problem is on how can I
remove the decimal point without converting the value.
say for example if I have this data:
Unit
2
1.5
2
3
|
by: vp |
last post by:
Hi all,
I need to create a report by extracting data from a table. I am using
the utility EXPORT to pull data from table to a file.
I will need to get the column heading and also if I want to add some
text and report date ..etc
can you please let me know how to create a report..
|
by: BrianDH |
last post by:
Hi
I am working on a C# Windows Application that builds an invoice (CR)
converts to PDF and attach to email one at a time.
This works untill my invoice count get over 40 to 50 invoices then I start
getting errors. The errors vairy. sometimes IO sometime "unable to load
report".
Has anyone here had a need to creat reports in mass?
| |
by: pv1 |
last post by:
Hello,
I am somewhat new to Access and vba, but am trying to complete a request that has been made of me. Access version 2002 WindowsXP.
At this point these text boxes are bound to the table memo field. I have located Stephen Lebans code to limit enter of text field based on characters entered and code to limit text based upon width of a text box (this seems to be most applicable for single line text box). I am have trouble putting...
|
by: kabradley |
last post by:
Hello,
Thanks for looking at my post and hopefully having an answer or at least a suggestion to my problem. I currently work at a financial planning office that deals with many clients and accounts. Each client may have multiple accounts such as an individual, IRA, and possibly a joint tenant account. Each one of these accounts for the particular client is contained in a 'Portfolio'. For example, Joe Smith may have 3 accounts: Joe Smith...
|
by: FNA access |
last post by:
I have a request to highlight any entries in a report that have the same date. The report is sorted by date so the records would be one after the other. I cannot find any events for the report that I would be able to add any code to.
Any input or advice would be appreciated
I would like to figure the code myself as I find I learn better that way, I just can't find an event to put the code into.
My report is based on a saved query,...
|
by: sphinney |
last post by:
I'm trying to change the font color of a textbox on a report to red if the date displayed in the textbox is before today. I'm using the following code to accomplish this:
Dim Ctrl1 as Textbox
Dim CFO As FormatCondition
Dim EXP1str as String
EXP1str = "<" & Date
Set CFO = Ctrl1.FormatConditions.Add(acExpression, , EXP1str )
CFO.ForeColor = RGB(255, 0, 0)
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |