在Crysal报告中使用sql函数 [英] Use sql Function in Crysal report

问题描述

我有一个水晶报告，它有6个表，从该表中检索报告中的字段

现在我想要一个从Sql函数生成的文件，它有2个输入参数

如何将此功能添加到crysatl报告中\



谢谢

Ankita Mali

I have one crystal report ,which is having 6 table ,from that table i m retrieving fields in report
Now i want one more filed which will be genrated from Sql function which is having 2 input parameters
how can add this function to crysatl report\

Thank you
Ankita Mali

推荐答案

据我所知，在Crystal Report中不可能使用SQL函数。



请参阅：

http://www.dbforums.com/crystal-reports/985086-using-sql-user-defined-function-crystal.html [<一个href =http://www.dbforums.com/crystal-reports/985086-using-sql-user-defined-function-crystal.html\"target =_ blanktitle =新窗口> ^ ]

http://stackoverflow.com/questions/16861773/crystal-reports-10-is-it-possible-to-call-a-custom-function-from-a-command [< a href =http://stackoverflow.com/questions/16861773/crystal-reports-10-is-it-possible-to-call-a-custom-function-from-a-command\"target =_ blanktitle =新窗口> ^ ]

http://scn.sap.com/ thread / 2022383 [ ^ ]



使用带参数的存储过程代替SQL公式。

使用Visual Studio .NET向您的应用程序添加专业质量报告 [ ^ ]

绑定水晶报告与存储过程返回两个数据表 [ ^ ]

As far as i know, it's not possible to use SQL function in Crystal Report.

Please, see:
http://www.dbforums.com/crystal-reports/985086-using-sql-user-defined-function-crystal.html[^]
http://stackoverflow.com/questions/16861773/crystal-reports-10-is-it-possible-to-call-a-custom-function-from-a-command[^]
http://scn.sap.com/thread/2022383[^]

Instead of SQL formula, use stored procedure with parameters.
Add Professional Quality Reports to Your Application with Visual Studio .NET[^]
Binding crystal report with stored procedure returning two datatables[^]

这篇关于在Crysal报告中使用sql函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！