Page 3 of 3

Re: Problem with Stored Proc as a DataSource

Posted: Fri May 23, 2014 6:26 am
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

Re: Problem with Stored Proc as a DataSource

Posted: Fri May 23, 2014 8:11 am
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.