如何扣除水晶报表中的重复值? [英] How to deduct repeated values in crystal report?

问题描述

在我的报告中，我在查询中使用内部联接.我得到了正确的记录，但itz重复了.如何扣除重复值?.请检查我的查询itz是否工作.

Hi,

In my report i''m using inner join in queries .I got correct record but itz repeated.How to deduct that repeat values?.Please check my query itz working.

SELECT f.feeid,
       f.studentid,
       ( s.first_name + last_name )AS studentname,
       b.branchname,
       c.coursename,
       y.yearname,
       se.sectionname,
       sem.semester,
       f.paymentmode,
       f.typeoffee,
       f.nameofthebank,
       f.totalfee,
       f.t                         otalpaidfee,
       f.balancefee,
       f.feestatus
FROM   studentfeedetails1 f
       inner join studentdetails s
         ON s.studentid = f.studentid
       inner join branchdetails b
         ON b.branchcode = s.branchcode
       inner join coursedetails c
         ON c.coursecode = s.coursecode
       inner join year_table y
         ON y.yearid = s.yearid
       inner join semester_table sem
         ON sem.semesterid = s.semesterid
       inner join section_table se
         ON se.sectionid = s.sectionid
WHERE  b.branchname = 'CSE'
       AND c.coursename = 'B-TECH'
       AND y.yearname = 'I'
       AND sem.semester = 'I'
       AND se.sectionname = 'A'
       AND f.typeoffee = 'Tution Fee

推荐答案

检查这些

水晶报告:删除重复的值 [禁止在Crystal Reports中重复打印数据 [对Crystal Reports中的重复记录"进行故障排除 [ ^ ]

Check these

Crystal Reports: Remove Duplicate Values[^]
Suppressing duplicate printing of data in Crystal Reports[^]
Troubleshooting "Duplicate Records" in Crystal Reports[^]

很显然，您的应用程序中存在错误，有两条记录符合您的加入条件.一条记录的状态为到期"，另一条记录的状态为已付款".我怀疑您想更新包含状态详细信息的记录，而不是插入新记录，但这由您决定.

问候，

曼弗雷德(Manfred)

It is very obviously an error in your application there are two records matching your join criteria. One record has the status "due" and the other one "paid". I suspect you would want to update the record containing the status details instead of inserting a new record, but that is for you to decide.

Regards,

Manfred

这篇关于如何扣除水晶报表中的重复值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！