OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Printing more than 1 page length memos

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
eokaila
General User
General User


Joined: 27 Feb 2009
Posts: 6

PostPosted: Fri Feb 27, 2009 10:29 pm    Post subject: Printing more than 1 page length memos Reply with quote

Hello,
I have problem when trying to print memo fields that exceeds 1 page. They are jus cut at the page break and the next page printing is about the next record in database. How can I control OOo to get longer memofield printed?
_________________
EKa
Back to top
View user's profile Send private message
eokaila
General User
General User


Joined: 27 Feb 2009
Posts: 6

PostPosted: Sun Mar 01, 2009 1:11 am    Post subject: Re: Printing more than 1 page length memos Reply with quote

Hi again,

this is just to encourage folks to give hints for testing. I still have the same problen as below. But trying to solve it I have managed to generate new ones. Instead of continued printing on several pages, I get extra title on separate page and pruned body. - This is absolutely newbie problem and I know it has an elementary solution. So all suggestions are wellcome.

Anyone? Smile

eokaila wrote:
Hello,
I have problem when trying to print memo fields that exceeds 1 page. They are jus cut at the page break and the next page printing is about the next record in database. How can I control OOo to get longer memofield printed?

_________________
EKa
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Sun Mar 01, 2009 8:32 am    Post subject: Reply with quote

Hello

You have problems with printing great memo fields.

Try to use the possibilities of writer. Do not use a textbox. In a writer document you can insert fields and maybe they give no problems for you. I do not use them but JohnV have post several posts.

Romke
Back to top
View user's profile Send private message
eokaila
General User
General User


Joined: 27 Feb 2009
Posts: 6

PostPosted: Sun Mar 01, 2009 11:44 am    Post subject: I'll check that. Reply with quote

Possibilities of writer. OK I'll look upon that. Thanks.

RPG wrote:
Hello

You have problems with printing great memo fields.

Try to use the possibilities of writer. Do not use a textbox. In a writer document you can insert fields and maybe they give no problems for you. I do not use them but JohnV have post several posts.

Romke

_________________
EKa
Back to top
View user's profile Send private message
eokaila
General User
General User


Joined: 27 Feb 2009
Posts: 6

PostPosted: Mon Mar 09, 2009 11:37 am    Post subject: Writer supporting Base or vs. Reply with quote

Thanks to Romke , I got a step ahead in solving my memo-reporting problem. Now I know how to drop retriewed content form database to Writer doc. Basically that is soving my key problem.

But knowing that I'm applying manually a very rustic method, i.e. dropping one record by record in to document, I'd like to learn how to automate this process. I mean, how to drop all data from Base into report made with Write.

Or, is it possible at all?

Smile
_________________
EKa
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Mar 09, 2009 1:20 pm    Post subject: Reply with quote

Hello

I did have post here a solution with a macro. I did erase that post. I did understand of your post that my first solution did not work. But I did try and do it without copying with hand. Do use the capabilities of writer.

Writer does have a lot possibilities.

Search good in the post of JohnV. He did wrote a lot of them.I will try to find a good post of him.

I did have search on mailmerge and author : JohnV
You can can be happy there are only six post.
It is real difficult for me to write it easy up for you there I don't use it.

I hope this help to search. Now you knew there is a easy solution

Romke
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Tue Mar 10, 2009 5:58 am    Post subject: Reply with quote

Hello

I did test some thing for you

Splitting problem
You have to split you problem in more parts

Make document
One is making a writer document. Insert in this document the fields you need.
For this go to
menu--> insert-->field--> other

Now there come a new popup with several tabpage.
Choose the tabpage with Database.
Here you see all your registerted database. Choose your database
Now you can choose a table or a query. I think choose for a query and not a table.
The query you can change easy. The table is more difficult to change.

On the same page you can choose between several types. I cannot explain the difference between all type but you have to use mail merge fields.
I did choose two fields
a) one for title and one for the memo

The title I do on top and centered.
The memo I do to the left. with a little distance from the title.

Now your document is ready. You can save it.

Printing
The next problem is how to print this file.
You have a nearly empty document.
click you want print it. Now there is a popup who ask you to print a form leter from a database. I say Yes
Select again your database and the query or table
Select what you and print

The end
I did have test it only with one record but I think it will also print more then one on more then one page.

Try to play with. I was surprice what you can do with it . One memo over 5 pages. I do make 93 files. I think it was not good to print them out.

Yesterday It was to difficult for me but now it was easy

I hope this helps you

Romke
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed Mar 11, 2009 10:18 am    Post subject: Reply with quote

Quote:
But knowing that I'm applying manually a very rustic method, i.e. dropping one record by record in to document, I'd like to learn how to automate this process. I mean, how to drop all data from Base into report made with Write.
Perhaps this is what you want:
Open new Writer document, press F4, open your database, open the Tables item and click your table.
Select all records with the gray box at their upper left.
Click the Data to Text icon and go from there.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Mar 11, 2009 11:35 am    Post subject: Reply with quote

Hello JohnV

That is real nice and easy. I have seen it before, but I forget it always

Romke
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu May 21, 2009 4:06 am    Post subject: Reply with quote

Hello

This will explain how to make a mailmerge.
It does use information from earlier post in this thread from me and from JohnV.
I hope it is more clear

You can insert fields from your database on several way.
1) table Insert as table
2) Fields insert as fields This is use ful for mailmerge
3) text insert as text.


For a mailmerge with fields

a) Select the datasource you need
b) Select the table or query you need
c) Select a record and drag it to your tekst document. Point on the gray surface just next to your table. Where the record pointer is.
e) Now in the popup select in what way you want have your fields and which fields you want have. You can select one field or more
f) if you select colums then the column will be inserted in the way you choose in e

g) Now your document is ready and you start printing read in an earlier post for printing.

I hope this helps you

Romke
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group