Page 1 of 1

Compact report

PostPosted: Mon Sep 10, 2012 3:56 pm
by rpriddle
I have a db with 100 records. Each record has 2 name fields, a 12 char. phone number field, a "year" field, and a "month" field (limited to 4 chars.) (There are other fields too, but these are all that are relevant to this report.)

I want to create a report that includes all 100 records, sorted by Month, sub sort by Last, with first and last in same field. July and August are not used.

The report (4 fields per record, 100 records grouped 10/month for 10 months) should fit on one page! So, once I can print the data (in one long report taking 2 pages but only the left half of 2 pages), I need to move half of it from the bottom of the report to the top on the right.

I'm sure this is not hard but I can't figure it out and I'm very frustrated!

TIA for any help

Roger Priddle
(PS - for "I", please read "my wife")...

Re: Compact report

PostPosted: Tue Sep 11, 2012 10:23 pm
by Villeroy
SELECT DISTINCT "this", "that" FROM "Somewhere" ORDER BY Year("date") DESC ,Month("Date") DESC, "name" ASC
selects "this" and "that" without duplicates from table "Somewhere", latest months on top, names sorted ascending within the months.

Re: Compact report

PostPosted: Wed Sep 12, 2012 10:29 am
by Arineckaig
The report (4 fields per record, 100 records grouped 10/month for 10 months) should fit on one page! So, once I can print the data (in one long report taking 2 pages but only the left half of 2 pages), I need to move half of it from the bottom of the report to the top on the right.

If I understand correctly you are seeking a two column report. One method is described at:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=42&t=44491&p=206123#p206123

Greater flexibility in the layout of reports can be provided by the work-around of using an independent Writer (or Calc if applicable) document linked for example to Villeroy's suggested query in the Base file. This method is fully described at:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=27662&p=125944#p125944
and at:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=40493