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

how to create a registry per line and report?

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


Joined: 13 Dec 2002
Posts: 5

PostPosted: Fri Dec 13, 2002 9:27 am    Post subject: how to create a registry per line and report? Reply with quote

I have a small database need done by msworks for years, each new line contains all the information related to a single report, and after I put the information on the report, I use a report template where specific parts from the database are put in place.

example database: (calc)
date, time, activity, outcome
07:12:2002, 12:16, work done, no problems
08:12:2002, 11:42, work done, no problems
09:12:2002, 11:16, work done, no problems
10:12:2002, 10:38, work done, no problems
11:12:2002, 11:52, work done, no problems
12:12:2002, 12:36, work done, no problems


report example (writer)
| --- complete A4 paper --- |
| =date |
| |
| |
| at =time, we found that |
| we have seen =activity, |
| so =outcome at =time |
| |
| |
| |
| --- complete A4 paper --- |


from works, I may choose any individual line, to create the report for any time period

is it possible to do it on ooo?

is there a similar use example I may see to fit my needs?

thank you very much.
Back to top
View user's profile Send private message
Wiley
Guest





PostPosted: Fri Dec 13, 2002 12:56 pm    Post subject: Reply with quote

You're really talking about a mail merge feature right? The idea being, you have data in a spreadsheet or database. You then create a template in say Writer with fields from the spreadsheet. When you create the report, it will insert data from the spreadsheet in place of the fields. Is that right?
Back to top
urbieta
General User
General User


Joined: 13 Dec 2002
Posts: 5

PostPosted: Tue Dec 17, 2002 9:05 am    Post subject: how to create a registry per line and report? Reply with quote

well I dont know anything about the "mail merge" term, but I believe you are correct, I need to print a few database line entries from the template, is it possible? how? Cool
Back to top
View user's profile Send private message
avery
Guest





PostPosted: Tue Dec 17, 2002 3:54 pm    Post subject: Reply with quote

Yes. This howto provides a nice overview:

How to do a "Mail Merge" from a Calc spreadsheet.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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