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

seperate page/document for each record?

P: n/a
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it to
seperate the pages by only allowing it to start an a new client heading on a
new page

I also then want to 'print' each invoice (report pages) to a seperate file -
as these will be 'printed' as PDFs

Thanx in Advance
Dan
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
To start a new client on a new page, set the NewPage property of your
Clients header to BeforeSection.

To create separate files, you'll need to do more, though.
One approach would be to write a loop which runs through your Clients and
runs a filtered report for each one.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:Fb**************@newsfe4-gui.ntli.net...
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it to
seperate the pages by only allowing it to start an a new client heading on a new page

I also then want to 'print' each invoice (report pages) to a seperate file - as these will be 'printed' as PDFs

Thanx in Advance
Dan

Nov 13 '05 #2

P: n/a
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
To start a new client on a new page, set the NewPage property of your
Clients header to BeforeSection.

To create separate files, you'll need to do more, though.
One approach would be to write a loop which runs through your Clients and
runs a filtered report for each one.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:Fb**************@newsfe4-gui.ntli.net...
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it
to
seperate the pages by only allowing it to start an a new client heading
on

a
new page

I also then want to 'print' each invoice (report pages) to a seperate

file -
as these will be 'printed' as PDFs

Thanx in Advance
Dan


Nov 13 '05 #3

P: n/a
Which part is difficult for you?
Writing a loop?
Obtaining a list of all clients?
Filtering your report?

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:7q***************@newsfe3-win.ntli.net...
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
To start a new client on a new page, set the NewPage property of your
Clients header to BeforeSection.

To create separate files, you'll need to do more, though.
One approach would be to write a loop which runs through your Clients and runs a filtered report for each one.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:Fb**************@newsfe4-gui.ntli.net...
I'm trying to create invoices using reports and I have
(Clients>Projects>Jobs>Expenses) four headers on the report. I need it
to
seperate the pages by only allowing it to start an a new client heading
on

a
new page

I also then want to 'print' each invoice (report pages) to a seperate

file -
as these will be 'printed' as PDFs

Thanx in Advance
Dan



Nov 13 '05 #4

P: n/a
All - I've not a clue where to start any decent web pages you know?

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:oe*****************@newsread2.news.atl.earthl ink.net...
Which part is difficult for you?
Writing a loop?
Obtaining a list of all clients?
Filtering your report?

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:7q***************@newsfe3-win.ntli.net...
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
> To start a new client on a new page, set the NewPage property of your
> Clients header to BeforeSection.
>
> To create separate files, you'll need to do more, though.
> One approach would be to write a loop which runs through your Clients and > runs a filtered report for each one.
>
> HTH
>
> "Dan Kean" <we*******@sms.uk.ro> wrote in message
> news:Fb**************@newsfe4-gui.ntli.net...
>> I'm trying to create invoices using reports and I have
>> (Clients>Projects>Jobs>Expenses) four headers on the report. I need
>> it
>> to
>> seperate the pages by only allowing it to start an a new client
>> heading
>> on
> a
>> new page
>>
>> I also then want to 'print' each invoice (report pages) to a seperate
> file -
>> as these will be 'printed' as PDFs
>>
>> Thanx in Advance
>> Dan
>>
>>
>
>



Nov 13 '05 #5

P: n/a
If you honestly don't know how to write a loop, you have a fairly steep
learning curve ahead of you.
If you're serious about pursuing this, I'd suggest that you look for a book
or video on VBA programming, or perhaps find a course at your local
community college or computer center.
If you're in any sort of hurry for this, though, and have the financial
resources available, you may find it in your interest to rent a consultant
for a few hours to take care of this for you.

HTH

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:qR**************@newsfe5-gui.ntli.net...
All - I've not a clue where to start any decent web pages you know?

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:oe*****************@newsread2.news.atl.earthl ink.net...
Which part is difficult for you?
Writing a loop?
Obtaining a list of all clients?
Filtering your report?

"Dan Kean" <we*******@sms.uk.ro> wrote in message
news:7q***************@newsfe3-win.ntli.net...
How would I go about writing a loop to run through the clients and do a
filtered report for each S:

Thanx
Dan

"MacDermott" <ma********@nospam.com> wrote in message
news:p3****************@newsread2.news.atl.earthli nk.net...
> To start a new client on a new page, set the NewPage property of your
> Clients header to BeforeSection.
>
> To create separate files, you'll need to do more, though.
> One approach would be to write a loop which runs through your Clients

and
> runs a filtered report for each one.
>
> HTH
>
> "Dan Kean" <we*******@sms.uk.ro> wrote in message
> news:Fb**************@newsfe4-gui.ntli.net...
>> I'm trying to create invoices using reports and I have
>> (Clients>Projects>Jobs>Expenses) four headers on the report. I need
>> it
>> to
>> seperate the pages by only allowing it to start an a new client
>> heading
>> on
> a
>> new page
>>
>> I also then want to 'print' each invoice (report pages) to a seperate > file -
>> as these will be 'printed' as PDFs
>>
>> Thanx in Advance
>> Dan
>>
>>
>
>



Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.