We are currently using Business Objects 4.1.3. We are trying to print out a mass mailing using Business Objects and an Oracle Database Vendor file. Can someone tell me how we can print labels using the data file produced by our query and WordPerfect? Or, is there a way we can product the labels within Business Objects?
Have a terrific day!
Penny Brewer
Listserv Archives (BOB member since 2002-06-25)
Penny,
Create a field that Concatenates all of the Information into a single Variable.
(i.e. = & char(13) & & char(13) & & ", " & & " " & )
The char(13) are equal to a carriage-return in ASCII.
Take this new Variable and Place it in the Center of a CELL.
Size the CELL as the Height/width of your labels.
Format the Report so that it contains 3 columns.
I had created a document on this, but don’t have it where I am at. If anyone recalls it, you can forward this on, or I can create a new document.
Thanks!
-rm
Listserv Archives (BOB member since 2002-06-25)
At 01:42 PM 98/11/18 -0600, you wrote:
We are currently using Business Objects 4.1.3. We are trying to print out a mass mailing using Business Objects and an Oracle Database Vendor file. Can someone tell me how we can print labels using the data file produced by our query and WordPerfect? Or, is there a way we can product the labels within Business Objects?
Have a terrific day!
Your safest/easiest bet may be to use BO to query the database and export the results to Wordperfect/Word. It is a LOT easier to produce labels with built-in facilities from Word/Wordperfect than it is in BO. For example, Word has several built-in templates for the various label manufaturers and you can take a data file as your source to populate these templates.
You can also write a script in BO to use OLE and automate the process of extracting the data from the Database and then fire up Word to print the labels.
I think there have been previous discussions on the list regarding this and there may actually be examples in the archives. If you need more help, please feel free to contact me.
Regards,
Chander Aggarwal
COMPUEXCEL http://www.compuexcel.com
The home of BusinessObjects Essentials - the Worlds First and Leading Full Multimedia Computer Based Training For BusinessObjects, with over 10,000 users world-wide!
Listserv Archives (BOB member since 2002-06-25)
How can I format the report so that it contains 3 columns? (I am using BO 4.1.2)
Gijs Damen
Tessenderlo Chemie
Belgium
From: Robert[SMTP:digpen@CONWAYCORP.NET]
Penny,
Create a field that Concatenates all of the Information into a singleVariable. (i.e. = & char(13) & & char(13) & & “, " & &” " & )
The char(13) are equal to a carriage-return in ASCII. Take this new Variable and Place it in the Center of a CELL.Size the CELL as the Height/width of your labels. Format the Report so that it contains 3 columns. I had created a document on this, but don’t have it where I am at. If anyone recalls it, you can forward this on, or I can create a new document.
Thanks!
-rm
Listserv Archives (BOB member since 2002-06-25)