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'.
[Solved] Repeated values in the Report
[Solved] Repeated values in the Report
- Attachments
-
- La Chassagne.odb
- The language is Dutch for many fields.
- (51.99 KiB) Downloaded 278 times
Last edited by Hagar Delest on Sat Jan 31, 2015 7:24 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice 4.0.0 on windows 8.1
Re: Repeated values in the Report
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:
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.
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.
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:
- naam
- postcode en plaats
- aankomst
- vertrek
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.
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.
Re: Repeated values in the Report
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
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
Re: Repeated values in the Report
Please see/review the Report Builder Wiki: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
- General Documentation:
https://wiki.openoffice.org/wiki/SUN_Re ... umentation - Groups:
https://wiki.openoffice.org/wiki/SUN_Re ... ing_Window
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.