report form / more than one page

I need print a report containing 3 pages, keeping the order. I am using the
procedure :

use arq
DO WHILE .NOT.EOF()

REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT
REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT
REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT

skip

ENDDO

but I ' d like to simplify that, printing these 3 pages in order

VFP6 SP5 windows ALL

alberto

Andrew
Mon Oct 25 09:30:10 CDT 2004

alkots wrote:
> I need print a report containing 3 pages, keeping the order. I am
> using the procedure :
>
> use arq
> DO WHILE .NOT.EOF()
>
> REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT
>
> skip
>
> ENDDO

Do you need detail bands for each report?

If not you may be able to work around by creating 2 or 3 groups on _pageno
and making it start a new page for each group.
You may even be able to work around if you need the detail bands (eg use a
stretching field and build your detail data into a string variable with line
feeds.)

I did something similar for a report that printed payslips for people, the
first page just had their name and address (no detail band necessary) and
the subsequent pages had the job details and payment information.

--
HTH
Andrew Howell

Andrew
Mon Oct 25 09:43:24 CDT 2004

Andrew Howell wrote:
> alkots wrote:
>> I need print a report containing 3 pages, keeping the order. I am
>> using the procedure :
>>
>> use arq
>> DO WHILE .NOT.EOF()
>>
>> REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT
>> REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT
>> REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT
>>
>> skip
>>
>> ENDDO
>
> Do you need detail bands for each report?

Actually, I'm sure you don't need detail bands because you're only reporting
NEXT 1.

--
Good luck!
Andrew Howell

Ook
Mon Oct 25 10:14:01 CDT 2004

You probably can't get much more simple then this. You can get move complex
and more clever, but then you loose readability. I'd just leave it the way
it is, it's simple, it's fast, and it works.

"alkots" <alkots@discussions.microsoft.com> wrote in message
news:C5EAF171-B100-4753-B0ED-F6CCFBD65DF6@microsoft.com...
> I need print a report containing 3 pages, keeping the order. I am using
the
> procedure :
>
> use arq
> DO WHILE .NOT.EOF()
>
> REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT
>
> skip
>
> ENDDO
>
> but I ' d like to simplify that, printing these 3 pages in order
>
> VFP6 SP5 windows ALL
>
> alberto

alkots
Mon Oct 25 11:11:04 CDT 2004

Yes, it's fast, simple and works, but...

the file has many records, when I send a report to print, each record
creates 3 jobs in spool to print. Then I am having problem with spool32
error, kernell32.dll, due to number of jobs. I tried adjust that but I
couldn't. If there are solutions to avoid that error , I wouldn't change my
software

Any idea ??

Alberto








"Ook" wrote:

> You probably can't get much more simple then this. You can get move complex
> and more clever, but then you loose readability. I'd just leave it the way
> it is, it's simple, it's fast, and it works.
>
> "alkots" <alkots@discussions.microsoft.com> wrote in message
> news:C5EAF171-B100-4753-B0ED-F6CCFBD65DF6@microsoft.com...
> > I need print a report containing 3 pages, keeping the order. I am using
> the
> > procedure :
> >
> > use arq
> > DO WHILE .NOT.EOF()
> >
> > REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> > REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> > REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> >
> > skip
> >
> > ENDDO
> >
> > but I ' d like to simplify that, printing these 3 pages in order
> >
> > VFP6 SP5 windows ALL
> >
> > alberto
>
>
>

Ook
Mon Oct 25 11:56:07 CDT 2004

How many jobs are getting queued? I've queued hundreds of jobs and never had
any problems. If you are getting spool32 errors, I'm thinking something else
is wrong, as this should not happen.

How different are the reports with regards to layout? You can get rather
clever with the report designer and perhaps have it print all 3 pages using
the same physical report form by having certain fields print or not print
depending on_pageno. I've done some pretty fancy stuff in the report
designer, but it can be a tad difficult and time consuming.

I'm inclined to think that you need to find out why spool32 is causing the
error. Maybe try another printer driver? Does it do this with Win2000/XP? I
can see Win98 doing this, I've crashed spool32 and kernel32 under Win98 many
many times, all you need to do is just *think* about printing with Win98 and
it crashes lol.


"alkots" <alkots@discussions.microsoft.com> wrote in message
news:113550C1-6C92-4A47-98C2-B8BB8BDA7B12@microsoft.com...
> Yes, it's fast, simple and works, but...
>
> the file has many records, when I send a report to print, each record
> creates 3 jobs in spool to print. Then I am having problem with spool32
> error, kernell32.dll, due to number of jobs. I tried adjust that but I
> couldn't. If there are solutions to avoid that error , I wouldn't change
my
> software
>
> Any idea ??
>
> Alberto
>
>
>
>
>
>
>
>
> "Ook" wrote:
>
> > You probably can't get much more simple then this. You can get move
complex
> > and more clever, but then you loose readability. I'd just leave it the
way
> > it is, it's simple, it's fast, and it works.
> >
> > "alkots" <alkots@discussions.microsoft.com> wrote in message
> > news:C5EAF171-B100-4753-B0ED-F6CCFBD65DF6@microsoft.com...
> > > I need print a report containing 3 pages, keeping the order. I am
using
> > the
> > > procedure :
> > >
> > > use arq
> > > DO WHILE .NOT.EOF()
> > >
> > > REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> > > REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> > > REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT
> > >
> > > skip
> > >
> > > ENDDO
> > >
> > > but I ' d like to simplify that, printing these 3 pages in order
> > >
> > > VFP6 SP5 windows ALL
> > >
> > > alberto
> >
> >
> >