Click here to Skip to main content
16,016,623 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have three tables as below:

Table1: InvoiceMaster
InvoiceNo(PrimaryKey)-PartName-InvoiceTtl

Table2: ParticularMaster
InvoiceNo(PrimaryKey)-PartSlNo(PrimaryKey)-SGST-CGST-IGST

Table3: InvoiceTaxMaster
InvoiceNo(PrimaryKey)-TaxType(PrimaryKey)-TtlSGST-TtlCGST-TtlIGST

Links:
Table1---->Table2 (via InvoiceNo)
Table1---->Table3 (via InvoiceNo)

In crystal report records of Table3 of particular InvoiceNo should be displayed only once, and that should be after displaying last record of Table2. Actually records of Table3 gets displayed after every record of Table2. How can I make arrangement to display the content of Table3 only once for a report without having to use subreport.

What I have tried:

I tried to display the records from Table3 in detail section. But the problem is, every time when records from Table2 gets displayed, it indeed prints records from Table3 after every row.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900