Problem with Stored Proc as a DataSource

Stimulsoft Reports.NET discussion
Dmitry
Posts: 15
Joined: Mon Apr 28, 2014 12:54 pm

Re: Problem with Stored Proc as a DataSource

Post by Dmitry »

Aleksey wrote:it is a ADO.NET limitations, not our
MS's ReportBuilder is able to retrieve parameters and columns for Stored Proc without editing it's options.
Without user help. And I do believe, it's done via ADO.NET.
It works without magical passes even if SP uses temporary tables. BTW, temporary tables are VERY important while creating reports in Stored Proc
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Problem with Stored Proc as a DataSource

Post by Alex K. »

Hello,

Unfortunately, it is working as is.
There are peculiarities with getting columns for procedures. In order to get columns for procedures which use temporary tables, they must be executed. Some users have this problem because of the large amount of data. Therefore, additional options have been added.

Thank you.
Post Reply