OpenOffice Report shows zeros

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

OpenOffice Report shows zeros

Postby W. Joy » Sun Feb 12, 2017 8:01 pm

I am trying to create a report but when I do there are 0s were peoples names should be. I cannot figures this out to save my life. Any suggestions?
Apache Open Office 4.1.3 on MacOS Sierra
W. Joy
 
Posts: 2
Joined: Sun Feb 12, 2017 7:56 pm

Re: Open Office Report shows zeros

Postby RusselB » Sun Feb 12, 2017 9:10 pm

What section of Open Office are you working with? I'm suspecting it's either Base, Calc or Writer
Can you upload your file so that we can see just what you are working with?
There are just too many possibilities to even make a guess based on the information you've given so far.

NB: My original reply was made while the topic was listed in the Getting Started -> Beginners section of the forum
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
RusselB
Volunteer
 
Posts: 4113
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: OpenOffice Report shows zeros

Postby W. Joy » Mon Feb 13, 2017 2:33 am

I am working with Base, I created a table and a form then ran a query. Then I tried to create a report and it fill in zeros were there was suppose to be text.
Attachments
WJoy Provider Information.odb
database
(42.07 KiB) Downloaded 38 times
Apache Open Office 4.1.3 on MacOS Sierra
W. Joy
 
Posts: 2
Joined: Sun Feb 12, 2017 7:56 pm

Re: OpenOffice Report shows zeros

Postby chrisb » Mon Feb 13, 2017 2:42 am

 Edit: please note that i was posting this reply at the same time as you uploaded your attachment. 
if you're using report builder then
1. open the report for edit
2. select the appropriate text box
3. if necessary hit (F4) to open the Properties pane
4. hit the General tab
5. ensure that 'Formatting' = 'Text'
open office 4.1.4 & LibreOffice 5.4.2.2 (x64) using HSQL 1.8.10 (Embedded) and HSQL 2.4.0 (Split) on Windows 10
chrisb
 
Posts: 148
Joined: Mon Jun 07, 2010 4:16 pm

Re: OpenOffice Report shows zeros

Postby chrisb » Mon Feb 13, 2017 7:23 am

this problem appears to be caused when setting the sort order in the report wizard.
COULD THIS ISSUE BE THE SAME AS DESCRIBED IN THE PREVIOUS THREAD Report showing 0 data

 Edit: sorry the solution is ineffective.
i can only suggest that you use your table as the data source & set the sort order from within the wizard or install the report builder extension.
maybe someone else can offer & alternative solution 

the solution therefore is to use an order by clause in your query.

here's how>>
right click your query & select 'Edit in SQL View'
add order by "Provider's Company Name" to the very end & save.

recreate your report without setting a sort order.
open office 4.1.4 & LibreOffice 5.4.2.2 (x64) using HSQL 1.8.10 (Embedded) and HSQL 2.4.0 (Split) on Windows 10
chrisb
 
Posts: 148
Joined: Mon Jun 07, 2010 4:16 pm

Re: OpenOffice Report shows zeros

Postby Villeroy » Mon Feb 13, 2017 11:26 am

Another workaround:

Open the query in SQL view and append
Code: Select all   Expand viewCollapse view
ORDER BY "Provider Contact - Last Name" ASC

Save the query.
Create a new report.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24584
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: OpenOffice Report shows zeros

Postby Nocton » Fri Feb 17, 2017 6:35 pm

I suggest that you install the Oracle Report Builder extension. I had no problem creating a report showing all your data, whether I sorted it by company, names, etc. or not.
ORB will give you much more scope to design a nice report.
OpenOffice 4.2.0 on Windows 10
Nocton
Volunteer
 
Posts: 444
Joined: Fri Nov 05, 2010 10:27 am
Location: UK


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests