Now that you have setup the report, and if everything is working as desired,
you will need to create a loop (WHILE ... ENDWHILE) to print that report,
based on a unique identifier, one at a time.
Here is a very simple example based on a unique identifier ...
-- Print custom report, one at a time
SET VARIABLE vUniqueID INTEGER = NULL
SET ERROR MESSAGE 705 OFF
DROP CURSOR c1
SET ERROR MESSAGE 705 ON
DECLARE c1 CURSOR FOR SELECT UniqueID FROM tablename WHERE whereclause
OPEN c1
FETCH c1 INTO vUniqueID INDIC iv1
WHILE SQLCODE <> 100 THEN
PRINT customreport WHERE UniqueID = .vUniqueID OPTION output|Parameter(s)
SET VARIABLE vUniqueID = NULL
FETCH c1 INTO vUniqueID INDIC iv1
ENDWHILE
DROP CURSOR c1
CLEAR VARIABLES iv,vUniqueID
RETURN
Just replace the variable vUniqueID and the data type based on the unique
column and data type as you see fit.
Have fun!
Razzak
At 10:47 PM 4/25/2018, Kayza Kleinman wrote:
This should work for one row. But if I want to print multiple rows,
each one taking up 2 pages how would you suggest doing that?
Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
www.jccgci.org
www.nphd.org
-----Original Message-----
From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf
Of A. Razzak Memon
Sent: Wednesday, April 25, 2018 11:11 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X
You will have to play with the suggested idea and find the perfect
setup/layout.
Here is another approach ...
01. Place all contents (objects) for the first page on the "Report
Header" band.
02. Place all contents (objects) for the second page on the "Detail" band.
03. Right-click on the "Report Header" band and check the options as follows:
[x] Static Height
[x] New Page
This technique will print all contents (objects) placed on "Report
Header" as the first page of the report, and all contents (objects)
placed on the "Detail"
band as second page of the report.
Have fun!
Razzak
At 10:42 AM 4/25/2018, Kayza Kleinman wrote:
>When I put a sub report on the footer, it prints as the footer on that
>page. What I need is for it to print on the next page.
>
>Kayza Kleinman
>Director of the Nonprofit Helpdesk
>CIO
>Jewish Community Council of Greater Coney Island, Inc www.jccgci.org
>www.nphd.org
>
>-----Original Message-----
>From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of
>A. Razzak Memon
>Sent: Wednesday, April 18, 2018 8:38 AM
>To: rbase-l@googlegroups.com
>Subject: RE: [RBASE-L] - 2 page report in Rbase X
>
>At 12:24 AM 4/18/2018, Kayza Kleinman wrote:
>
> >What I can't figure out is if I can have both pages print as one report.
>
>Kayza,
>
>Here's how ...
>
>01. Create a sub-report and place the Sub Report object on Report Page
>Footer section.
>
>02. Place all necessary and/or relevant columns/fields on this
>sub-report accordingly.
>
>03. When PRINTing the report, both pages will be printed as one report.
>
>Very Best R:egards,
>
>Razzak
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
