如何在crystal report 8.5中触发sql查询？ [英] How to fire sql query in crystal report 8.5?

问题描述

Hello all

我在vb6 n oracle n工作现在使用水晶报告8.5准备报告。



我设计的报告n添加带有链接的oracle表它运行良好......



现在我想添加记录集的sql查询以按用户显示报表要求但是如何


在水晶报告中写sql命令的地方我怎么能执行它们？



我完全空白了，请帮助我.......



ex。

Hello all
I m working in vb6 n oracle n now preparing report using crystal report 8.5.

I designed report n add oracle tables with their links n it''s working well......

Now I wanna add record-set of sql queries to display report as per user demands but how to n

where to write sql commands in crystal report n how can I execute them???

I''m totally blank plz help me.......

ex.

<br />
    SQL = "SELECT A.*,C.*,B.LOC_NAME FROM ASSET_OPTION A,LOCATION B,ASSET C WHERE "<br />
    SQL = SQL + " C.LOC_ID=B.LOC_ID AND C.AID=A.AID AND ASSET_NAME LIKE " & "''%" & UCase(STR) & "%'' AND BIT=''FALSE''"<br />
    RS.Open SQL, CON, 1, 2<br />

推荐答案

请参阅此教程 [ ^ ]用于使用oracle创建水晶报告。这是使用crstal报告的链接使用 VB6 。阅读这些链接并提出真正的编码问题。



干杯，

Sudhakar

Please refer to this Tutorial[^] for creating crystal reports using oracle.Here is the link for using crstal reports with VB6. Read these links and come with real coding issues.

Cheers,
Sudhakar

这篇关于如何在crystal report 8.5中触发sql查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！