Removing duplicate records with crystal reports.

Kedar Pawgi

Hi i have problem related to crystal reports while printing report. I need to print a ledger. It contain total number of payments done and on right side its the total purchase made from specific supplier with in particular period.

if u see the above image then the problem can be clearly seen that the left hand side rows are repeated for every row on right side.
Please help me to solve this problem. This result come by pulling data using Sql Query made by Crystal Report.
So Please help me to solve this problem. Its very urgent. Please tell me if i have to write query using the SQL, This help will be highly appriciated.
I have tried to run the query using phpmyadmin SQL editor, the query i wrote is :---

SELECT

`payments`.`paymentDate`,
`payments`.`Paymode`,
`payments`.`amt`,
`payments`.`voucherType`,
`payments`.`Chqddno`

`purchaseinvoicemast`.`bookInvoiceNo`,
`purchaseinvoicemast`.`todaysdt`,
`purchaseinvoicemast`.`finalAmount`,
`purchaseinvoicemast`.`sellersName`,
`purchaseinvoicemast`.`customerCode`

FROM `payments`, `purchaseinvoicemast`
WHERE ((`purchaseinvoicemast`.`customerCode`='SUP3') AND ( `payments`.`vendorId`='SUP3' ))

Please help this is very urgent for my software....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kedar Pawgi13y ago
Hi Venkata Kumar thanks for replying so fast, as per ur suggestion i have already tried out with grouping but it was not successful, actually i forgot to give the grouping clause which i used here. Here i am giving the group which i used in the above query.
Here is my query with group by

SELECT

`payments`.`paymentDate`,
`payments`.`Paymode`,
`payments`.`amt`,
`payments`.`voucherType`,
`payments`.`Chqddno`,

`purchaseinvoicemast`.`bookInvoiceNo`,
`purchaseinvoicemast`.`todaysdt`,
`purchaseinvoicemast`.`finalAmount`,
`purchaseinvoicemast`.`sellersName`,
`purchaseinvoicemast`.`customerCode`

FROM `payments`, `purchaseinvoicemast`
WHERE ((`purchaseinvoicemast`.`customerCode`='SUP3') AND ( `payments`.`vendorId`='SUP3' ))
GROUP BY `purchaseinvoicemast`.`customerCode`

if i use this query it shows only one row in answer, if i use following query it gives different query as i have joined the IDs., the 2nd query is ....

SELECT

`payments`.`paymentDate`,
`payments`.`Paymode`,
`payments`.`amt`,
`payments`.`voucherType`,
`payments`.`Chqddno`,

`purchaseinvoicemast`.`bookInvoiceNo`,
`purchaseinvoicemast`.`todaysdt`,
`purchaseinvoicemast`.`finalAmount`,
`purchaseinvoicemast`.`sellersName`,
`purchaseinvoicemast`.`customerCode`

FROM `payments`, `purchaseinvoicemast`
WHERE ((`purchaseinvoicemast`.`customerCode`=`payments`.`vendorId` ))
GROUP BY `purchaseinvoicemast`.`customerCode`

So please guide me on this..
Thanks again in advance.
0
venkata kumar13y ago
try that query by using grouping
0