OpenOffice Report shows zeros
OpenOffice Report shows zeros
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
Re: Open Office Report shows zeros
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
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.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.
Re: OpenOffice Report shows zeros
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 373 times
Apache Open Office 4.1.3 on MacOS Sierra
Re: OpenOffice Report shows zeros
Edit: please note that i was posting this reply at the same time as you uploaded your attachment. |
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.14 & LibreOffice 6.4.4.2 x64 using HSQL 1.8.0.10 (Embedded) and HSQL 2.6.0 (Split) on Windows 10
Re: OpenOffice Report shows zeros
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
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.
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 |
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.14 & LibreOffice 6.4.4.2 x64 using HSQL 1.8.0.10 (Embedded) and HSQL 2.6.0 (Split) on Windows 10
Re: OpenOffice Report shows zeros
Another workaround:
Open the query in SQL view and append
Save the query.
Create a new report.
Open the query in SQL view and append
Code: Select all
ORDER BY "Provider Contact - Last Name" ASC
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: OpenOffice Report shows zeros
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.
ORB will give you much more scope to design a nice report.
OpenOffice 4.1.12 on Windows 10