sql上的存储过程专门用于Crystal Reports [英] stored procedure on sql specifically for Crystal Reports

问题描述

在提供了大量帮助之后，我准备好了我的选择语句。我被告知要在新的Visual Studio中生成专业的报告。 net必须在存储过程中。我现在要做的是获取附加的select语句，该语句接受表示工单号的整数，并根据select语句中使用的数据生成报告。在我从下拉列表中接受工作订单号后，我想使用visual basic来调用水晶报告。

理想情况下我想打开一个vb表单来获取我的工作订单号，然后调用我的水晶报告传递w / o整数。然后让水晶报告调用存储过程。

代码片段

解决方案

将此帖作为将数据集附加到a的一种方法水晶报告 http://forums.msdn.microsoft.com/ en-US / vscrystalreports / thread / 8d9946aa-31ad-4347-9043-5ca9bd54e7eb （它在C＃但VB.net几乎完全相同）

谷歌搜索或阅读这样的论坛，以便从存储过程中填充数据集 http://www.codeguru.com/vb/ GEN / vb_database / storedprocedures / article.php / C5155 /

 

Ok after lots of help, I have my select statement ready.  I've been told to generate professional looking reports in the new Visual Studio . net it must be in a stored procedure.  What I want to do now is to take the attached select statement which accepts an integer representing the work order number and generate a report from the data used in the select statement.  I want to use visual basic to call crystal reports after I have accepted the work order number from a drop down list.

Ideally I would like to open a vb form get my work order number and then call my crystal report passing the w/o integer.  Then let the crystal report call the stored procedure.

Code Snippet

解决方案

read this post as one way to attach a dataset to a crystal report http://forums.msdn.microsoft.com/en-US/vscrystalreports/thread/8d9946aa-31ad-4347-9043-5ca9bd54e7eb (it's in C# but VB.net is nearly identical)

google search or read a forum like this in order to fill your dataset from your stored procedure http://www.codeguru.com/vb/gen/vb_database/storedprocedures/article.php/c5155/

这篇关于sql上的存储过程专门用于Crystal Reports的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！