• Registered: 2024-12-21
  • Posts: 87

Topic: Not showing duplicates

Hi,
why on report dont showing duplicates?
i try print orders and there same like in invoices print not showing  if i make 5 same services with different Quantity.
Please help
Thank you

Post's attachments

Attachment icon FastReport - Invoice.fr3.jpg 768.65 kb, 24 downloads since 2025-05-27 

  • Registered: 2024-12-21
  • Posts: 87

Re: Not showing duplicates

Here is my project

Post's attachments

Attachment icon IGMAeng27052025_2144.zip 1.65 mb, 73 downloads since 2025-05-27 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,961

Re: Not showing duplicates

I rarely use FastReport so don't know if duplicates are suppressed by default.
But rather than try to add code in FastReport to check for this possibility, you could simply add a field that will force uniqueness on each row in table 'TableLines' (see attached including screenshot).
Derek.

Post's attachments

Attachment icon IGMAeng27052025_2144.zip 1.72 mb, 67 downloads since 2025-05-28 

  • Registered: 2024-12-21
  • Posts: 87

Re: Not showing duplicates

Thank you,
working perferctly.
but another problem i got.
TableOrders.Letters (text field) dont show in fastreport, and VAT Notes does not show
Thank you

Post's attachments

Attachment icon IGMAeng29052025_1803.zip 1.65 mb, 61 downloads since 2025-05-29 

5 Reply by agusecc (edited by agusecc 2025-05-30 11:08:25)

  • Registered: 2015-12-19
  • Posts: 145

Re: Not showing duplicates

you make code in fastreport like this.

procedure Memo17OnBeforePrint(Sender: TfrxComponent);
begin
   Memo17.Text := ReportTableOrdersLetters.Text; 
end;

i share invoice.fr3.. you can replace

Post's attachments

Attachment icon Invoice.fr3 100.59 kb, 77 downloads since 2025-05-30 

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,372

Re: Not showing duplicates

Here is a link to the FastReport manual.
https://origin2.cdn.componentsource.com … 8en%29.pdf


Read about Bands. And in general it is useful.

  • Registered: 2024-12-21
  • Posts: 87

Re: Not showing duplicates

Ok,
Thank you

  • Registered: 2024-12-21
  • Posts: 87

Re: Not showing duplicates

Hi,
thank you for answers

agusecc wrote:

you make code in fastreport like this.

procedure Memo17OnBeforePrint(Sender: TfrxComponent);
begin
   Memo17.Text := ReportTableOrdersLetters.Text; 
end;

i share invoice.fr3.. you can replace


i try it but i got this error in attach,
only thing i was change is that i try to add another field to report.
When i dont set dataset i got this 2 fields on report but when i add dataset to masterdata band this 2 fields disappears.
Is there any way to make this 2 fields to be on another dataset, maybe then will work?
Thank you

Post's attachments

Attachment icon 2025-06-01 10_12_28-FastReport - Invoiceagusecc.fr3.jpg 393.91 kb, 33 downloads since 2025-06-01 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,961

Re: Not showing duplicates

Hi,
Probably a couple of ways to fix your issue but I like to keep things simple (where possible).
See attached.
Derek.

Post's attachments

Attachment icon IGMAeng29052025_1803 option.zip 1.64 mb, 85 downloads since 2025-06-01 

  • Registered: 2024-12-21
  • Posts: 87

Re: Not showing duplicates

Hi,
thank you all for helping
Derek your version is simple and works perfectly smile
Thank you so much