At the grouping window, you can group the information by one or more of the fields. If you need to combine fields from two tables or queries, you need to create a query containing them before you create the report. Select the table or query (just one per report) that you want to use, and then insert the fields. Click the Reports icon at left, then click the item labeled Use Wizard to Create Report. odb database file containing the data you want. I'll get into those further along in this article. One allows you to drag the contents of a query or table into a Writer doc, and the other lets you insert fields from, about or which control, a table or query. You're going to expand your report-writing options, if you think outside the wizard and are willing to do a little fiddling with some other windows. For instance, printing the total of all values for a field on a report requires simple SQL and multiplying two fields together while very easy, these are technically SQL functions. But SQL know-how will help you do the important parts. You don't have to know SQL to get advanced reports from OpenOffice 2.0, and what you need to know about SQL is pretty simple. Creating your own Reports using the Next Record Field, which gives you a bit more control over formatting.Printing fast reports, covering printing the contents of a table or query in the blink of an eye and,.Handling report-specific fields, especially how to add calculated fields to any report document.How to exploit the Query Design tool and the SQL view, which are not technically specific to reports, but useful on them. Reviewing Report Writer, in which I'll identify the wizard's most useful tool.In this tip, I'll offer how-tos on the primary tools needed for getting creative with reports from OpenOffice 2.0. Creating interesting and more informative reports isn't hard but you must be willing to step away from the wizard. It requires no SQL know-how at all, just the ability to press F4 and click and drag. Tutorials are improved by input from users.In OpenOffice 2.0 Reports, it's easy to do the simple stuff, like just printing the contents of a table or query. In the File name: dialog box, type the name of the tutorial. In the Save as type: pull-down menu box, click OpenDocument Text (.odt) if it is not already selected. In the Save in: pull-down menu box, click My Documents if it is not already selected. To save the tutorial, cl ick F ile > Save A s. (A page will open)Ĭlick on the underlined blue OO by the tutorial of your choice. Go to our website Under Our Tutorial Offerings, click on the underlined Writer, or Calc, etc. Read any explanatory information that may be in parenthesis.īeginner users will use the entire tutorial. (some steps have a picture just below the step that shows Observe the results of each step on the computer screen and compare to In the self-teaching setting, the printout of the tutorial is the teacher.ĭownload and print the tutorial of choice. “Teacher aides” circulating in the room are helpful.Ī teacher may download the tutorials in the OpenOffice format and modify (A picture is worthĪ thousand words) (The printout can be taken home by the student) The teacher can refer to a picture within the tutorial. The student may look at the computer screen as explanatory informationĪ printout of the tutorial will have been placed on the students desk. The student will do the steps and observe the results on his/her computer There will be step-by-step instructions and explanatory information about The teacher will read the tutorial as written. The Teacher may be a professional or non-professional. Tutorials on this website are designed to be used in either a T eacher-Student setting or by an individual in a S elf-Teaching setting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |