How do I Print Multiple entries in multiple columns on 1 page

Keith Prins

unread,

Jun 21, 2002, 6:56:46 AM6/21/02

to

Hi All

I have a database of all employees with various info about them, 1
item is their extension number.

Although I have a view that allows the staff to use this database as a
phone directory, there are a few die hards that still want a paper
phone directory.

How can I print this info. The problem is that I want all this info
on one a4 landscape page, with the name and extension snaking across
about 6 columns, so I just print the view.

Any one have any ideas how to do this?

Thanx in advance
Keith

Keith Prins

unread,

Jun 21, 2002, 7:08:42 AM6/21/02

to

Keith Prins <keith...@nospam.capespan.co.za> wrote:

>about 6 columns, so I just print the view.

That meant to say "so I Can't just print the view"

W.Flamme

unread,

Jun 22, 2002, 1:52:43 AM6/22/02

to

"Keith Prins" <keith...@nospam.capespan.co.za> schrieb im
Newsbeitrag
news:l316hu86ovk8tg95e...@4ax.com...

>How can I print this info. The problem is that I want
>all this info on one a4 landscape page, with the name
>and extension snaking across about 6 columns, so I

>[can't (wf)] just print the view.

Pure Notes:
You need programmatic access to RichText table and table
wrap features (NotesAPI or RTLibrary). In addition I guess
you want to switch to temporary landscape printing. Tough.

Can't you use e.g. Word as a printing engine? Just loop the
view, retrieve the values and 'type' them into Word using
COM - need a 6-column Word template of course.

--

Wolfgang Flamme
wfl...@mainz-online.de

Dennis N. Yugo

unread,

Jun 22, 2002, 12:27:46 PM6/22/02

to

In article <l316hu86ovk8tg95e...@4ax.com>,
keith...@nospam.capespan.co.za says...

One way is to build a form whose contents are computed form the view. Use
@DBColumn to collect all the data, then @subset to split the data into
the columns you want. Them just put a View Action button on the view with
the action to read that form.

I don't think there is any way to si9mply format the view as you
describe.

dy
--
Dennis Yugo
Angle-of-Attack Systems
http://www.aoasystems.com

Bike

unread,

Jun 24, 2002, 6:14:03 AM6/24/02

to

Hi Keith,

Another way to do this is to make a form special for printing. In that form
you can put all the fields represented the way you want them (and leave out
those you don't need). When printing choose 'customize' and pick your new
created 'print form' as alternate form to print. Then choose either 'blank
line' or 'nothing' between the various documents.

Success, Bert.

Bill LaRue

unread,

Jun 24, 2002, 11:49:14 PM6/24/02

to

You might try to create a form set up just for printing and specifying that
form in your print command (optional value).

Another way to do this is to set up an export to Excel. I do this all the
time for client views when they really, really, really want a printed form
"Like from Crystal Reports but we don't want to buy Crystal Reports". Set
up a template in excel and export the data from the view; you can specify
the print orientation, etc from the excel environment (and it's fun to
watch!)

Bill