RE: [RBASE-L] - 2 page report in Rbase X

2018-04-26 Thread A. Razzak Memon 

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  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  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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-25 Thread Buddy Walker 
Kayza

  Reports > Breaks >
   From the dropdown select the uniqueID and click Add
   Check box for "Start New Page"

 Note: this will sort the report based on the uniqueID 

Buddy 

-Original Message-
From: rbase-l@googlegroups.com  On Behalf Of Kayza 
Kleinman
Sent: Wednesday, April 25, 2018 10:48 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X

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  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  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.

-- 
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.

-- 
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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-25 Thread Kayza Kleinman 
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  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  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.

-- 
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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-25 Thread A. Razzak Memon 
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  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.

Re: [RBASE-L] - 2 page report in Rbase X

2018-04-25 Thread karentellef via RBASE-L 
Right-click inside the report footer section, and pick "new page"

Karen

 

 

 

-Original Message-
From: Kayza Kleinman 
To: rbase-l 
Sent: Wed, Apr 25, 2018 9:42 am
Subject: RE: [RBASE-L] - 2 page report in Rbase X

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  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.

-- 
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.

-- 
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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-25 Thread Kayza Kleinman 
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  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.

-- 
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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-18 Thread Kayza Kleinman 
I’m not sure what you mean. But, if you are asking if we’re trying to 
essentially fill out a paper form, the answer is yes.


Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
www.jccgci.org<http://www.jccgci.org/>
www.nphd.org<http://www.nphd.org/>

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Wednesday, April 18, 2018 4:10 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - 2 page report in Rbase X

Are you filling a form?
Albert


On Apr 17, 2018, at 10:24 PM, Kayza Kleinman 
mailto:kklein...@jccgci.org>> wrote:

Each row of data gets spread over 2 pages. Some items can be printed directly, 
but they need to be in VERY specific spots. For other data fields, I need to 
place a tick mark in a specific spot based on the value. So, assuming 
coordinates x,y, for Field1= 1 x is at x,y; Field1 = 2, X is at x+2; y etc. 
I’ve figured ot how to make that happen, although it’s a pain. What I can’t 
figure out is if I can have both pages print as one report.


Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
www.jccgci.org<http://www.jccgci.org/>
www.nphd.org<http://www.nphd.org/>

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry
Sent: Tuesday, April 17, 2018 3:43 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - 2 page report in Rbase X

Kayza, it would be helpful to have a more detailed description of the two 
pages. Do you want specific data in specific locations on each page? Are all 
the data elements in a single row in a table? etc.
Albert



On Apr 16, 2018, at 11:27 PM, Kayza Kleinman 
mailto:kklein...@jccgci.org>> wrote:

Is there a way to print a report that takes up two pages per row? (I posted 
about the precursor to this report 2 years ago, and I’m still saddled with it.)

Currently, what I’m doing in ver 9.5 is

Declare cursor
Fetch cursor
While sqlcode <>100
   Print Page1
   Print Page2
   Fetch Cursor
Endwhile

Is there a way to have a report that allows the data to be put on two pages? If 
not, is there any way to output to PDF (or any other file format, for that 
matter) with each “print” job appending to the existing file rather than 
creating a new file for each page?

Thanks for any help you can give!

Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
3001 West 37th Street
Brooklyn NY 11224
718 449-5000 x 2266
fax 347-946-6390
www.jccgci.org<http://www.jccgci.org/>
www.nphd.org<http://www.nphd.org/>



--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-18 Thread A. Razzak Memon 

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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-18 Thread Buddy Walker 
Kayza

  The best way I have found to do this is to use regions and checkbox. The 
regions can be set to expand based on the region before. 

 

Buddy

 

 

From: rbase-l@googlegroups.com  On Behalf Of Kayza 
Kleinman
Sent: Wednesday, April 18, 2018 12:24 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - 2 page report in Rbase X

 

Each row of data gets spread over 2 pages. Some items can be printed directly, 
but they need to be in VERY specific spots. For other data fields, I need to 
place a tick mark in a specific spot based on the value. So, assuming 
coordinates x,y, for Field1= 1 x is at x,y; Field1 = 2, X is at x+2; y etc. 
I’ve figured ot how to make that happen, although it’s a pain. What I can’t 
figure out is if I can have both pages print as one report.

 

 

Kayza Kleinman

Director of the Nonprofit Helpdesk 

CIO

Jewish Community Council of Greater Coney Island, Inc

www.jccgci.org <http://www.jccgci.org/> 

www.nphd.org <http://www.nphd.org/> 

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
[mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry
Sent: Tuesday, April 17, 2018 3:43 AM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: Re: [RBASE-L] - 2 page report in Rbase X

 

Kayza, it would be helpful to have a more detailed description of the two 
pages. Do you want specific data in specific locations on each page? Are all 
the data elements in a single row in a table? etc. 

Albert

 

On Apr 16, 2018, at 11:27 PM, Kayza Kleinman mailto:kklein...@jccgci.org> > wrote:

 

Is there a way to print a report that takes up two pages per row? (I posted 
about the precursor to this report 2 years ago, and I’m still saddled with it.)

 

Currently, what I’m doing in ver 9.5 is

 

Declare cursor

Fetch cursor

While sqlcode <>100

   Print Page1

   Print Page2

   Fetch Cursor

Endwhile

 

Is there a way to have a report that allows the data to be put on two pages? If 
not, is there any way to output to PDF (or any other file format, for that 
matter) with each “print” job appending to the existing file rather than 
creating a new file for each page?

 

Thanks for any help you can give!

 

Kayza Kleinman

Director of the Nonprofit Helpdesk

CIO

Jewish Community Council of Greater Coney Island, Inc

3001 West 37th Street

Brooklyn NY 11224

718 449-5000 x 2266

fax 347-946-6390

www.jccgci.org <http://www.jccgci.org/> 

www.nphd.org <http://www.nphd.org/> 

 

 

 

-- 
For group guidelines, visit  
<http://www.rbase.com/support/usersgroup_guidelines.php> 
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  <mailto:rbase-l+unsubscr...@googlegroups.com> 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit  <https://groups.google.com/d/optout> 
https://groups.google.com/d/optout.

 

-- 
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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

-- 
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 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
For more options, visit https://groups.google.com/d/optout.

-- 
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.

Re: [RBASE-L] - 2 page report in Rbase X

2018-04-18 Thread Albert Berry 
Are you filling a form?
Albert

> On Apr 17, 2018, at 10:24 PM, Kayza Kleinman  wrote:
> 
> Each row of data gets spread over 2 pages. Some items can be printed 
> directly, but they need to be in VERY specific spots. For other data fields, 
> I need to place a tick mark in a specific spot based on the value. So, 
> assuming coordinates x,y, for Field1= 1 x is at x,y; Field1 = 2, X is at x+2; 
> y etc. I’ve figured ot how to make that happen, although it’s a pain. What I 
> can’t figure out is if I can have both pages print as one report.
>  
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> www.jccgci.org <http://www.jccgci.org/>
> www.nphd.org <http://www.nphd.org/>
>  
> From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
> Albert Berry
> Sent: Tuesday, April 17, 2018 3:43 AM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - 2 page report in Rbase X
>  
> Kayza, it would be helpful to have a more detailed description of the two 
> pages. Do you want specific data in specific locations on each page? Are all 
> the data elements in a single row in a table? etc. 
> Albert
> 
> 
> On Apr 16, 2018, at 11:27 PM, Kayza Kleinman  <mailto:kklein...@jccgci.org>> wrote:
>  
> Is there a way to print a report that takes up two pages per row? (I posted 
> about the precursor to this report 2 years ago, and I’m still saddled with 
> it.)
>  
> Currently, what I’m doing in ver 9.5 is
>  
> Declare cursor
> Fetch cursor
> While sqlcode <>100
>Print Page1
>Print Page2
>Fetch Cursor
> Endwhile
>  
> Is there a way to have a report that allows the data to be put on two pages? 
> If not, is there any way to output to PDF (or any other file format, for that 
> matter) with each “print” job appending to the existing file rather than 
> creating a new file for each page?
>  
> Thanks for any help you can give!
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> 3001 West 37th Street
> Brooklyn NY 11224
> 718 449-5000 x 2266
> fax 347-946-6390
> www.jccgci.org <http://www.jccgci.org/>
> www.nphd.org <http://www.nphd.org/>
>  
>  
>  
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> <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 
> <mailto:rbase-l+unsubscr...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> <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 
> <mailto:rbase-l+unsubscr...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> <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 
> <mailto:rbase-l+unsubscr...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.

-- 
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.

RE: [RBASE-L] - 2 page report in Rbase X

2018-04-17 Thread Kayza Kleinman 
Each row of data gets spread over 2 pages. Some items can be printed directly, 
but they need to be in VERY specific spots. For other data fields, I need to 
place a tick mark in a specific spot based on the value. So, assuming 
coordinates x,y, for Field1= 1 x is at x,y; Field1 = 2, X is at x+2; y etc. 
I’ve figured ot how to make that happen, although it’s a pain. What I can’t 
figure out is if I can have both pages print as one report.


Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
www.jccgci.org<http://www.jccgci.org/>
www.nphd.org<http://www.nphd.org/>

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Tuesday, April 17, 2018 3:43 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - 2 page report in Rbase X

Kayza, it would be helpful to have a more detailed description of the two 
pages. Do you want specific data in specific locations on each page? Are all 
the data elements in a single row in a table? etc.
Albert


On Apr 16, 2018, at 11:27 PM, Kayza Kleinman 
mailto:kklein...@jccgci.org>> wrote:

Is there a way to print a report that takes up two pages per row? (I posted 
about the precursor to this report 2 years ago, and I’m still saddled with it.)

Currently, what I’m doing in ver 9.5 is

Declare cursor
Fetch cursor
While sqlcode <>100
   Print Page1
   Print Page2
   Fetch Cursor
Endwhile

Is there a way to have a report that allows the data to be put on two pages? If 
not, is there any way to output to PDF (or any other file format, for that 
matter) with each “print” job appending to the existing file rather than 
creating a new file for each page?

Thanks for any help you can give!

Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
3001 West 37th Street
Brooklyn NY 11224
718 449-5000 x 2266
fax 347-946-6390
www.jccgci.org<http://www.jccgci.org/>
www.nphd.org<http://www.nphd.org/>



--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
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<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
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.

Re: [RBASE-L] - 2 page report in Rbase X

2018-04-17 Thread Albert Berry 
Kayza, it would be helpful to have a more detailed description of the two 
pages. Do you want specific data in specific locations on each page? Are all 
the data elements in a single row in a table? etc. 
Albert

> On Apr 16, 2018, at 11:27 PM, Kayza Kleinman  wrote:
> 
> Is there a way to print a report that takes up two pages per row? (I posted 
> about the precursor to this report 2 years ago, and I’m still saddled with 
> it.)
>  
> Currently, what I’m doing in ver 9.5 is
>  
> Declare cursor
> Fetch cursor
> While sqlcode <>100
>Print Page1
>Print Page2
>Fetch Cursor
> Endwhile
>  
> Is there a way to have a report that allows the data to be put on two pages? 
> If not, is there any way to output to PDF (or any other file format, for that 
> matter) with each “print” job appending to the existing file rather than 
> creating a new file for each page?
>  
> Thanks for any help you can give!
>  
> Kayza Kleinman
> Director of the Nonprofit Helpdesk
> CIO
> Jewish Community Council of Greater Coney Island, Inc
> 3001 West 37th Street
> Brooklyn NY 11224
> 718 449-5000 x 2266
> fax 347-946-6390
> www.jccgci.org 
> www.nphd.org 
>  
>  
> 
> -- 
> 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 
> .

-- 
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.

[RBASE-L] - 2 page report in Rbase X

2018-04-16 Thread Kayza Kleinman 
Is there a way to print a report that takes up two pages per row? (I posted 
about the precursor to this report 2 years ago, and I'm still saddled with it.)

Currently, what I'm doing in ver 9.5 is

Declare cursor
Fetch cursor
While sqlcode <>100
   Print Page1
   Print Page2
   Fetch Cursor
Endwhile

Is there a way to have a report that allows the data to be put on two pages? If 
not, is there any way to output to PDF (or any other file format, for that 
matter) with each "print" job appending to the existing file rather than 
creating a new file for each page?

Thanks for any help you can give!

Kayza Kleinman
Director of the Nonprofit Helpdesk
CIO
Jewish Community Council of Greater Coney Island, Inc
3001 West 37th Street
Brooklyn NY 11224
718 449-5000 x 2266
fax 347-946-6390
www.jccgci.org
www.nphd.org


-- 
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.