在Crysal报告中使用sql函数 [英] Use sql Function in Crysal report
本文介绍了在Crysal报告中使用sql函数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个水晶报告,它有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屋!
查看全文