Hi Cathy
Method you presented will send both reports to preview but one after the
other,
they do not show as single report.
You might want to have look at www.report-sculptor.com
After integrating RS into your environment, you can have any number of FRX
reports
trully merged. (Moreover you can have page 1 of X on all reports together. )
Here is sample code for two reports ;
*-----------------
local oRS
oRS = GetRsObject()
oRS.lAutoFirstPage=.f.
local cFrx1,cFrx2
with oRS
.OpenSession()
cFrx1 = HOME() + 'SAMPLES\SOLUTION\REPORTS\' + 'ledger.FRX'
cFrx2 = HOME() + 'SAMPLES\SOLUTION\REPORTS\' + 'Colors.FRX'
.LoadFrx( rsFrx(cFrx1 ) )
.LoadFrx( rsFrx(cFrx2 ) )
.CloseSession()
endwith
oRs.Output( 2 , .t. ) &&Foxpro9 native preview
*----------------------------------------------
You will get both reports show together as one single report.
Reports Sculptor is completely free.
HTH
Sergio
-----Original Message-----
From: Cathy Pountney [mailto:[email protected]]
Sent: Thursday, September 17, 2009 4:55 PM
To: [email protected]
Subject: RE: VFP - Reports
If you're using VFP 8 or later you can chain multiple reports together.
REPORT FORM MainRpt PREVIEW NOPAGEEJECT
REPORT FORM SummRpt PREVIEW
This keeps both reports in one print job, but don't be deceived by the
"NOPAGEJECT" clause. There really is a page ejected after the first report.
The second report always starts on a new page.
In VFP 9 another option is to use multiple detail bands. The main report can
be defined in the first detail band and the summary report can be defined in
the second detail band. Just use a fudge "relation" between the table to
ensure that all the main records are processed first, followed by the
summary records.
Cathy
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]
On
> Behalf Of Sytze de Boer
> Sent: Thursday, September 17, 2009 12:05 AM
> To: [email protected]
> Subject: VFP - Reports
>
> Hi Folk
>
> I have a report with a single summary row But, I need the system to
> print a detailed summary report which spans a whole A4 sheet (well,
> almost)
>
> This is no problem if I print the 1st report followed by the 2nd, but
> I would prefer to print the 2nd report immediately after the 1st The
> report is always previewed first, using XFRX
>
> I hope my intentions above are clear ?
>
> --
> Regards
> Sytze de Boer
> Kiss Systems
> Hamilton, NZ
> Ph: 64-7-8391670, Mob:021 937611,
> www.kiss.co.nz
> ***Email is a great medium for distributing
> misunderstandings...***
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
