Base Subsection reporting

users
#1

Hi,
I need a printed (paper or PDF) report from a small selection of my DB. I
am puzzled what is the best way to achieve that.
Filter?
Query?
other?
I am new to Base (but no PC dummy!)

Greetings ftN

#2

Hi Pieter and all:

  As first answer but not necesary the best, BASE has it own report way,
but before you can filter or use query or mix tables data to make
consultation (Option below Tables at left). Then, after you make it, you
can go to Form option (The last option at left).

  In both options you can use Wizzards or make by your self. I suggest
you to use Wizzards to probe how is going on and if you like the
results. If not, try by your self, but this need to know better the
program performance.

  As I remember, Base generate a Report in Writer program that you can
edit after.

I hope this help,

#3

Hi Pieter,

I need a printed (paper or PDF) report from a small selection of my DB. I
am puzzled what is the best way to achieve that.
Filter?
Query?
other?
I am new to Base (but no PC dummy!)

Best way to get a report is:
Create a table "filter", which will only be needed for filter-values.
One row, PrimaryKey could be a boolean-field.
Create a query for all needed fields.
Include the "filter"-table for the conditions in the query.
If query will show, what you will get, create a view of this query.

Report-Builder will better work with views than queries.

Here you could find the Base Handbook 4.0 in English:
http://www.libreoffice.org/get-help/documentation/
And here you could get it for LO 5.3 in German:
http://de.libreoffice.org/get-help/documentation/

Regards

Robert