On Tuesday 06 September 2005 09:06 am, Brian E. Blandford wrote:
> Dan Lewis wrote:
> >On Monday 05 September 2005 10:19 am, Brian E. Blandford wrote:
> >>I'm late getting to experimenting with 2.0, so apologies if this
> >>query has been answered before, and I haven't noticed.
> >>
> >>I want to generate a report from calc, but I can't see how to do
> >> it. In 1.1 there is a report auto pilot in the file menu, but not
> >> in 2.0. The task I'm trying to do is to select and print in my
> >> report those cells containing a particular name amongst others. At
> >> the moment, I am having to resort to using the "find all" button,
> >> then laboriously copying and pasting the results.
> >>
> >>I've tried the help file and the google search in OOo's tutorial
> >>pages without finding what I'm sure is a very simple answer.
> >>
> >>Brian B.
> >
> > Have you tried to register the Calc file as a database and then
> >create the report from the database?
> >
> >Dan
>
> That doesn't seem to be possible in 2.0, as the
> tools>options>database menu only seems to allow the addition of a
> base file, not a calc file. Or am I going about it the wrong way?
>
> Brian B.
Sort of. Create a new database (File > New >Database). On the first
page of the wizard, select "Connect to a new database" and from the
Drop down menu select "Spreadsheet". Click Next. Browse to locate your
spreadsheet and enter its address in the box. Click Finished. Name the
database so that you know it is associated with your spreadsheet. Each
of the sheets in your spreadsheet will not also be a table in the
associated database. You can now create reports on any one of these
tables or more than one table if you so desire.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
