Topic: Data is repeating in report automatically

i have a problem that's it.
i have a detailed data entry form.
but when i go to print then data is repeating automatically.
i have designed report like it.

https://i.ibb.co/ThZk13H/r1.png


but output  is repeating like it


https://i.ibb.co/j43mWgg/r2.png


and here is project with attach for all details

Post's attachments

Attachment icon 111.7z 276.9 kb, 329 downloads since 2020-10-29 

Re: Data is repeating in report automatically

It is a design issue, the main problem is that you are retrieving all information at once from the table party. It is difficult to fix your problem without knowing what you want to do and what you want to see. You might need to generate multiple dataset in order to construct a report with multiple datasets.

Re: Data is repeating in report automatically

https://i.ibb.co/vsKyDt9/p1.png


https://i.ibb.co/7NnrD5s/p2.png


https://i.ibb.co/fN56K5y/p3.png


project is attached in post one

Re: Data is repeating in report automatically

is here any helper?????

Re: Data is repeating in report automatically

https://i.ibb.co/xSY96wj/p1-1.png

https://i.ibb.co/KF5Fnhs/p1-2.png






https://i.ibb.co/f8TwkDX/p2-1.png

https://i.ibb.co/xMvQ1QC/p2-2.png

Re: Data is repeating in report automatically

There might be a bug with the implementation of the report module. I tried to redo the report with only one report on one field and this field is repeated 4 times!! Unless you write a SQL report, it is a massive headache to solve!!

For instance the table Tindola has only 2 records and the report shows 4 times the same 2 records.


Please Dmitry fix the report module !!

Re: Data is repeating in report automatically

tcoton wrote:

There might be a bug with the implementation of the report module. I tried to redo the report with only one report on one field and this field is repeated 4 times!! Unless you write a SQL report, it is a massive headache to solve!!

For instance the table Tindola has only 2 records and the report shows 4 times the same 2 records.


Please Dmitry fix the report module !!

thanks dear for your replay and how about sql report?????

Re: Data is repeating in report automatically

i think the forum is helpless and thanks to all for your silence. keep the silence for better community.

9 (edited by sibprogsistem 2020-11-12 05:01:05)

Re: Data is repeating in report automatically

bbrother wrote:

i think the forum is helpless and thanks to all for your silence. keep the silence for better community.

программа работает правильно, повторяющихся полей нет..  а вот связка таблиц выглядит очень странно. 

   
the program works correctly, there are no duplicate fields .. but the bunch of tables looks very strange.

посмотрите пример того как создавать связанные списки
see an example on how to create linked lists
http://myvisualdatabase.com/forum/viewtopic.php?id=1081

Re: Data is repeating in report automatically

bbrother,
See attached for a solution to your report. Select a record on the Form1 grid and click on NEW REPORT button.


Keep in mind that most all of us on the forum are volunteers and contributes whenever they can. Sometimes it may be a few days before somebody can respond. Personally I'm lucky if I can get on here once a week. I have my own clients to take care of and they come before this forum. So try to be a little patient. You'll get your answers from somebody.

Post's attachments

Attachment icon 111 Revised.zip 343.72 kb, 401 downloads since 2020-11-13 

Re: Data is repeating in report automatically

ehwagner wrote:

bbrother,
See attached for a solution to your report. Select a record on the Form1 grid and click on NEW REPORT button.


Keep in mind that most all of us on the forum are volunteers and contributes whenever they can. Sometimes it may be a few days before somebody can respond. Personally I'm lucky if I can get on here once a week. I have my own clients to take care of and they come before this forum. So try to be a little patient. You'll get your answers from somebody.

thanks again and again i try and tell you.

Re: Data is repeating in report automatically

ehwagner wrote:

bbrother,
See attached for a solution to your report. Select a record on the Form1 grid and click on NEW REPORT button.


Keep in mind that most all of us on the forum are volunteers and contributes whenever they can. Sometimes it may be a few days before somebody can respond. Personally I'm lucky if I can get on here once a week. I have my own clients to take care of and they come before this forum. So try to be a little patient. You'll get your answers from somebody.

good and thanks but can we use default report chekbox for more information????

Re: Data is repeating in report automatically

I am not sure what you mean by

can we use default report chekbox for more information????

Re: Data is repeating in report automatically

ehwagner wrote:

I am not sure what you mean by

1.it means that there is no way for manually report designing.because a person that's don't know sql and pascal is M.V.D.B not for that.?????
2.in final project i will add many new fields in party table for details information.how about new fields??????
3.can we work on this project with out making Datasets???
4.if Datasets are necessary so is there any way after creating data sets can we use other fields normally in report for more detail see the image.

https://i.ibb.co/nBNvyFf/12a.png

5.when i edit your designed report  then in showing a error comes like.

https://i.ibb.co/KjHk9Hh/12b.png