如何在crystal report 8.5中触发sql查询？

问题描述：

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查询？

相关推荐