如何在查询中使用联合时在Crystal报表记录选择中指定条件 [英] How to Specify condition in crystal reports record selection while Using Union in Query

问题描述

我有一个使用Union的Sql查询

Hi,
I have a Sql Query Using Union

select Users.UserId,Users.EmpNo,(Users.FirstName+''''+Users.LastName) As FullName,EmpPayments.SalBasic,EmpPayments.SalCon,EmpPayments.SalDA,EmpPayments.SalHRA from Users  join EmpPayments on Users.UserId=EmpPayments.UserId where Users.UserId=24 and MainContractorSw=''Y'' and EmpPayments.MonthId=8 and EmpPayments.YearId=2010 
Union 
select Users.UserId,Users.EmpNo,(Users.FirstName+''''+Users.LastName) As FullName,EmpPayments.SalBasic,EmpPayments.SalCon,EmpPayments.SalDA,EmpPayments.SalHRA from Users join EmpPayments on Users.UserId=EmpPayments.UserId where Users.MainContractorSw=''N'' EmpPayments.MonthId=8 and EmpPayments.YearId=2010 and Users.MainContractorId=24

在这里，第一个查询将给出承包商的结果
第二个查询将给出分包商的结果，该分包商的承包商是我们从第一个查询中获得的承包商.
我必须在Crystal Report中使用此查询.
现在，我该如何在报告"部分中指定条件，因为我必须使用2个查询条件..
我已经尝试了很多与"条件，它没有检索到任何东西，而使用了或"，但是结果在重复......

Here the First Query will give the result of Contractor
and the second query will give the result of SubContractors whose contractor is the Contractor we get from First Query.
I have to Use this query in Crystal Report.
Now,How can i give the condition in Report Section because i have to use the 2 queries Conditions..
I have tried a lot Used ''AND'' condition it is not retrieving anything and used ''OR'' But the Results are repeating ......

推荐答案

选择不同(...)

然后使用嵌套查询检索内部字段.

将内部查询与外部的EmpPayments ID连接起来.

Select Distinct (...)

Then use a nested query to retrieve the inner fields.

Join the inner query with the outer on EmpPayments ID.

这篇关于如何在查询中使用联合时在Crystal报表记录选择中指定条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！