Why my crystal report bill showing products twice ?

Question

I am using VS212 and SQL 2012 i created a invoice system. here when i am going to print the invoice bill in my listview there are only two products but in invoice bill it is showing 4 products. same products repeting twice. why is tht? please help me i have attached screen shots

Phani Kumar · Answer

Hi Rif Check the query if it is returning only two products then supress the fields which were duplicate or else if it is returning repeated products then make distinct columns to be returned.

Imtiyaz Ansari · Answer

Hello Rif... Try this....!!!! https://www.itsupportguides.com/crystal-reports/crystal-reports-filter-duplicates-by-field/ http://stackoverflow.com/questions/23477553/duplicated-data-in-crystal-reports

Shubham Kumar · Answer

Hi Try to Suppress the field if it i duplicate Right Click the Field and Choose to Format the Field check the checkbox Suppress if Duplicated

Rif Rifkan · Answer

Hi Brothers thanks a lot dears for your replies i crated one table on dataset and did some coding correction thn it is working fine