At 23:46 10/09/2007 -0700, A Nameless Person ("Open Office User") wrote:
I'm an esl teacher. I'm trying to [create?] a "directory" of all the words and what book/unit/page number it appears on. I created a two field data base table . Here's an example:
  Word    bookpagenumber
  crab   2.1.4
  fish   2.1.4
[snip]

When I print it, I get a very long two column report twelve pages long. I need to design a printable report In which the two columns flow down to the bottom of the page and then flow to the top of the page.

  Like this
  Word   bookpagenumber   Word   bookpagenumber      Word   bookpagenumber
  Word   bookpagenumber   Word   bookpagenumber      Word   bookpagenumber
[snip]

  When the page is full it should move on to the next page.
  I'm not a database or computer expert. I hope you can help me.

Like you, I'm no database expert, but no-one seems to have replied to this, so I'll have a go.

We are talking about creating a report from a database in Base - right? I think you can decide on and carry out this formatting only at one point, so you have to notice that point and not miss it. When you create the report using the Report Wizard, the last screen - step 6 - gives you a default option of "Create report now" but an alternative of "Modify report layout". If you choose to modify the report layout at that point, the report will open as a text (Writer) document, and you can use the normal Writer facilities to change the layout the form will have. As someone has already indicated, you now need to go to Format | Page... | Columns and to select the required number of columns for the report - and to make any other formatting changes you might like.

Note that you get only this one chance to modify the layout: the report subsequently opens as a read-only document and cannot be modified. But if you change your mind, you can probably fairly easily create a new replacement report in another style.

I trust this helps.

Brian Barker

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to