My Visual Database — Not showing duplicates

Re: Not showing duplicates

null@example.com (IgorMad) — Sun, 01 Jun 2025 11:44:08 +0000

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

Re: Not showing duplicates

null@example.com (derek) — Sun, 01 Jun 2025 10:36:29 +0000

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

Re: Not showing duplicates

null@example.com (IgorMad) — Sun, 01 Jun 2025 08:19:08 +0000

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

Re: Not showing duplicates

null@example.com (IgorMad) — Fri, 30 May 2025 19:51:29 +0000

Ok,
Thank you

Re: Not showing duplicates

null@example.com (sparrow) — Fri, 30 May 2025 19:40:28 +0000

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.

Re: Not showing duplicates

null@example.com (agusecc) — Fri, 30 May 2025 11:07:41 +0000

you make code in fastreport like this.

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

i share invoice.fr3.. you can replace

Re: Not showing duplicates

null@example.com (IgorMad) — Thu, 29 May 2025 17:30:55 +0000

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

Re: Not showing duplicates

null@example.com (derek) — Wed, 28 May 2025 18:52:00 +0000

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.

Re: Not showing duplicates

null@example.com (IgorMad) — Tue, 27 May 2025 19:47:46 +0000

Here is my project

Not showing duplicates

null@example.com (IgorMad) — Tue, 27 May 2025 19:45:34 +0000

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