VS2010 Oracle DataSource在rdlc报告中不显示存储过程 [英] VS2010 Oracle DataSource Does not show Stored Procedure in rdlc report

问题描述

我正在尝试使用oracle 11g创建一个rdlc报告。但是在rdlc报告数据源生成中仅显示表和视图，不显示存储过程。但我想使用程序。我怎样才能做到这一点。请有人帮助我。提前谢谢。

解决方案

但是在rdlc报告数据源生成中只显示表和视图，不显示存储过程。

StoredProcedure不存储数据信息，因此它们不会与表和视图一起显示。 SP'是高级别的查询，因此，您可以使用SP作为查询来获取报表中的数据。



此外，SP'将根据某些条件获取特定数据，其中表/视图将存储/整理所有数据，而不管具体标准如何。

Hi,
I''m trying to create an rdlc report using oracle 11g. But in rdlc report datasource generation only tables and views are shown, stored procedures are not shown. But I want to use procedures. How can I do that. Please anybody help me out. Thanks in advance.

解决方案

But in rdlc report datasource generation only tables and views are shown, stored procedures are not shown.
StoredProcedure does not store data information and thus they are not shown along with Tables and Views. SP''s are queries on a high level and thus, you can use SP''s as a query to fetch data in your report.

Further, SP''s will fetch specific data based on certain conditions where as Tables/Views are to store/collate all the data irrespective of specific criteria.

这篇关于VS2010 Oracle DataSource在rdlc报告中不显示存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！