Here is my interpretation of what you wish to accomplish:
* The label format is:
+---------------------------* page 1
|label_one |label_two |
|label_three |label_four |
+---------------------------*
+---------------------------* page 2
|label_one |label_two |
|label_three |label_four |
+---------------------------*
* What you want to happen in printing is:
+---------------------------* page 1
|data_record1 |data_record1 |
|data_record2 |data_record2 |
+---------------------------*
+---------------------------* page 2
|data_record3 |data_record3 |
|data_record4 |data_record4 |
+---------------------------*
* To do this your best bet is to create a VIEW
Such as:
CREATE VIEW Label2copies (CopyNbr, First_Name, Last_Name,
+
Address) AS SELECT +
1, T1.First_Name, T1.Last_Name, T1.Address FROM TableName
T1 +
UNION ALL
2, T2.First_Name, T2.Last_Name, T2.Address FROM TableName
T2 +
ORDER BY Last_Name ASC, FIRST_NAME ASC, 1 ASC
* You could include WHERE clauses if needed. What this VIEW
does
is create 2 copies of your data. No Need for Temporary tables
as suggested in another post to this thread.
* Base the Label on the VIEW and
when you create your label select the dimensions of two across
and two down a page. You may have to customize the setting.
When Rbase prints the label if there are more than one label
column
per page (say 2) it uses the following sequence:
dataRecord1 --> dataRecord2
dataRecord3 --> dataRecord4
dataRecord5 --> dataRecord6
dataRecord7 --> dataRecord8
dataRecord9 --> dataRecord10
* Since your VIEW returns data as follows:
Name1
Name1
Name2
Name2
Name3
Name3
You get Name1 in two side by side labels then
Name2 in two side by side labels Etc.
* If you need more across just insert Additional UNION statements
before the ORDER BY Incremention the CopyNbr.
--
Jim Bentley
American Celiac Society
[EMAIL PROTECTED] - email
(973) 325-8837 voice
(973) 669-8808 Fax
---- Bernie Corrigan <[EMAIL PROTECTED]> wrote:
> Yes there are R:Base commands for printing more than one
> label to a page. Start the Object Manager > Labels
> > Layout > Labels Settings. This will bring up a dialog
> system which enables the user to spec out the labels
> including how many to print per page.
> ---------------------------------------
> At 10:40 AM 5/13/2002 -0500, you wrote:
> >Rbase 6.5++ Windows
> >
> >I am wanting to print labels, using commercial available
> >label stock (2 x 4 x 2) which has (4) labels per page
> >of course.
> >
> >I have set up the label and it prints fine, but I have yet
> to
> >figure out how to print multiple copies of the same label
> >on one page via Rbase commands. I.E. print (2) copies
> >of the same record on one page, using the top two labels,
> >etc. So far, all I can get it to do is print one label on two
>
> >pages.
> >
> >Is there a built in function for this, or will I need to code
> >the entire label printing routine to be able to do this?
> >
> >I appreciate any input! Thanks!
> >
> >================================================
> >TO SEE MESSAGE POSTING GUIDELINES:
> >Send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: INTRO rbase-l
> >================================================
> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: UNSUBSCRIBE rbase-l
> >================================================
> >TO SEARCH ARCHIVES:
> >http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
