Columnar report

Getting your data onto paper - or the web - Discussing the reports features of Base

Columnar report

Postby papadcha » Fri Mar 13, 2015 10:33 am

Hello everybody.

I want your help to create (if possible) a columnar report in the following database using the table "Κινήσεις" sorting by "Ημερομηνία" and creating columns with specific record values in the following fields "Λογαριασμός πίστωσης 1", "Λογαριασμός πίστωσης 2", "Λογαριασμός χρέωσης 1", "Λογαριασμός χρέωσης 2" and under each column displayed the value of "Αξία πίστωσης 1", "Αξία πίστωσης 2", "Αξία χρέωσης 1", "Αξία χρέωσης 2".

I include the base file for and an image to zip (link below) to show you how I want the report to be.

https://yadi.sk/d/amsW7yclfDhp8

Thanks in advance.
openoffice 4.1.1 libreoffice 4.4.1 on mint linux
papadcha
 
Posts: 2
Joined: Mon Mar 02, 2015 9:33 am

Re: Columnar report

Postby Villeroy » Fri Mar 13, 2015 2:43 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26730
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Columnar report

Postby MTP » Fri Mar 13, 2015 4:59 pm

This type of "report" is better shown as a "Base form" rather than a "Base report" (confusing, I know, but sometimes forms makes better reports than "reports" do). You would make a query, and then put a tablegrid based on that query into the form.

But looking at the image - that is a very wide report. Just due to the width, I agree with Villeroy you're better off importing the data into Calc. You'll still need to write a query to get the data together, then import the query into Calc and format as you want.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests