Crystal Reports - 存储过程语法问题

When I drag a field from my stored procedure onto a formula (Crystal Reports 11), I get something like this:

当我将存储过程中的字段拖到公式(Crystal Reports 11)时,我得到这样的结果:

{sp_YES_AccountSnapshot;1.ST0405_Ext}

What does the "1." represent?

“1”是什么代表?

I hope it refers to the table number... because I'd like to return two tables from the stored procedure and be able to access both from a report.

我希望它引用表号...因为我想从存储过程返回两个表,并能够从报表中访问它们。

Thanks

1 个解决方案

#1

I believe the semicolon one (";1") represents if the sp is active or not in the database.

我相信分号1(“; 1”)表示sp是否在数据库中是活动的。

I opened a report and connected to a datasource I frequently use and all of the sp's have ";1" except for 2 sp's which have ";0". Those sp's are old sp's which were deleted and do not show in the SQL Server Management Studio.

我打开一个报告并连接到我经常使用的数据源,并且除了2个具有“; 0”的sp之外,所有sp都有“; 1”。那些sp是旧的sp,它们被删除了,并没有在SQL Server Management Studio中显示。

I don't believe that multiple tables can be pulled into a Crystal Report from an sp. When I just tried it on my system Crystal Reports closed out.

我不相信可以从sp中将多个表拉入Crystal Report。当我在我的系统上尝试它时,Crystal Reports关闭了。

#1