[Solved] Repeated values in the Report

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

[Solved] Repeated values in the Report

Postby lachass » Wed Jan 28, 2015 5:23 pm

I am trying to make a report from a query in the Report Builder. I have tried to eliminate repeated values in my report, but have been unsuccessful so far. In the control I have put the 'print repeated values' to 'NO', but still it continues to repeat them. It repeats the values with a number, currency and a date format.
I need name, address, place, arrival date, departure date and deposit only printed once. And after that all the different items someone bought with the different prices and taxes.
I have attached the database 'la chassagne.odb'.
Attachments
La Chassagne.odb
The language is Dutch for many fields.
(51.99 KiB) Downloaded 82 times
Last edited by Hagar Delest on Sat Jan 31, 2015 7:24 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.0.0 on windows 8.1
lachass
 
Posts: 16
Joined: Wed Jan 28, 2015 5:02 pm

Re: Repeated values in the Report

Postby Sliderule » Wed Jan 28, 2015 6:38 pm

Welcome to the OpenOffice / LibreOffice Base forum.

Please find as an attachment . . . a copy of your database. I did change the name of the file . . . I added an _02 to the file name . . . so you could TEST it.

I added / created a NEW report . . . with a name of . . . facturr_02 . . . so you could see it ( run it ) and check the results.

Please forgive me, but, language differences ( my English and your language ) . . . I only added a GROUP for the Query fields -- you may add the others, as you see fit: :super:
  1. naam
  2. postcode en plaats
  3. aankomst
  4. vertrek
Also, please note, addition of naam Header . . . that is used to display the only columns you wanted to display once . . . but . . . Detail contains the columns from your query . . . that is printed for each unique naam Header . :)
One additional item, I was not sure if you wanted the content of naam Header repeated . . . when . . . it is a NEW PAGE for the same naam etc . . . I did NOT do this, but, you can, if you want. :D

La Chassagne_02.odb
(81.55 KiB) Downloaded 101 times

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
User avatar
Sliderule
Volunteer
 
Posts: 1191
Joined: Thu Nov 29, 2007 9:46 am

Re: Repeated values in the Report

Postby lachass » Fri Jan 30, 2015 11:32 am

Thank you Sliderule for your immediate response and your extra work in solving my problem. I was away from my computer for a day so my apologies for my late reaction; I wasn't expecting such a fast response.
So I have executed the new report, and the problem of repeated values have been solved. I do have some questions.
1. How do you make a new header with your field name on it which seems to be blue, and what is the purpose of said header?
2. Why do you need the other headers too like 'postcode en plaats' and 'aankomst' when you don't use them or fill them with fields and keep them invisible?

Thanks a million,
Lachass
OpenOffice 4.0.0 on windows 8.1
lachass
 
Posts: 16
Joined: Wed Jan 28, 2015 5:02 pm

Re: Repeated values in the Report

Postby Sliderule » Fri Jan 30, 2015 5:25 pm

lachass wrote:Thank you Sliderule for your immediate response and your extra work in solving my problem. I was away from my computer for a day so my apologies for my late reaction; I wasn't expecting such a fast response.
So I have executed the new report, and the problem of repeated values have been solved. I do have some questions.
1. How do you make a new header with your field name on it which seems to be blue, and what is the purpose of said header?
2. Why do you need the other headers too like 'postcode en plaats' and 'aankomst' when you don't use them or fill them with fields and keep them invisible?

Thanks a million,
Lachass

Please see/review the Report Builder Wiki:

  1. General Documentation:
    https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation

  2. Groups:
    https://wiki.openoffice.org/wiki/SUN_Report_Builder/Documentation#Report_Navigator_-.3E_Report_-.3E_Groups_-.3E_Sorting_and_Grouping_Window
Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
User avatar
Sliderule
Volunteer
 
Posts: 1191
Joined: Thu Nov 29, 2007 9:46 am

Re: Repeated values in the Report

Postby lachass » Sat Jan 31, 2015 1:37 pm

Thanks Sliderule!

Lachass
OpenOffice 4.0.0 on windows 8.1
lachass
 
Posts: 16
Joined: Wed Jan 28, 2015 5:02 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 2 guests