如何在Crystal Reports 8.5中使用存储过程？ [英] How To use a stored procedure in a crystal reports 8.5?

问题描述

我必须使用水晶报告8.5做一个新的报告。
我在SQL Server 2005中创建了一个存储过程。存储过程有一个输入参数。

I have to make a new report using crystal report8.5 . I have created a stored procedure in SQL Server 2005. The stored procedure has one input parameter.

现在我想知道如何添加存储

Now I wanna to know that how I can add that stored procedure and show its result in my report while designing that report?

谢谢

推荐答案

首先转到文件>选项>数据库（从内存），并确保选中存储过程的复选框。然后，当您设置与SQL Server的连接以及一个Tables部分时，您将在其下看到一个Stored Procedures。在列表中找到您的存储过程，将其添加为报告的数据源，您就可以将其用作正常来源。

First go to File > Options > Database (going from memory) and make sure the checkbox for Stored Procedures is ticked. Then, when you setup your connection to SQL Server, as well as a Tables section you'll see a Stored Procedures one beneath it. Find your stored procedure in the list, add it as the data source for your report, and you'll be able to use it as a normal source.

这篇关于如何在Crystal Reports 8.5中使用存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！