将此SQL语句转换为Crystal Reports语言 [英] Convert This SQL Statement into the Crystal Reports Language

问题描述

我想知道如何将此SQL查询转换为公式，因为我需要使用此条件进行过滤并且我很难过这样做。



select * from ARInvoiceDetails ARI1 join ARInvoiceDetails ARI2

on ARI1.InvoiceDetailID = ARI2.InvoiceDetailID

其中ARI1.SubmitTo = 1或

（ARI2.SubmitTo = 2且ARI2.VoucherStatus = 1）;



我感谢您的帮助。



谢谢！

Hi,

I would like to know how can i convert this SQL Query into a Formula because i need to filter using this conditionals and i Having a hard time doing this.

select * from ARInvoiceDetails ARI1 join ARInvoiceDetails ARI2
on ARI1.InvoiceDetailID = ARI2.InvoiceDetailID
where ARI1.SubmitTo = 1 or
(ARI2.SubmitTo = 2 and ARI2.VoucherStatus = 1);

I appreciate your help.

Thanks!

推荐答案

您需要使用的是 Selectionformula 。检查这些

使用选择公式创建报告 [ ^ ]

设置选择公式手动代码 [ ^ ]



从UI，您可以使用参数字段来应用 selectionformula 动态。

C＃Crystal Reports字符串参数 [ ^ ]

C＃Crystal Reports整数参数 [ ^ ]

All you need to use is Selectionformula. Check these
Creating a Report with a Selection Formula[^]
Setting the Selection Formula Manually in Code[^]

From UI, you could use parameter-fields to apply selectionformula dynamically.
C# Crystal Reports String parameter[^]
C# Crystal Reports Integer parameter[^]

这篇关于将此SQL语句转换为Crystal Reports语言的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！