Stored procedures or User Defined Functions

This public forum is for user-to-user discussions of ASP.NET Report Maker. Note that this is not support forum.

Stored procedures or User Defined Functions

Postby cbacit » Mon Jul 30, 2012 11:16 pm

Does ASP.Net Report Maker support ,"Stored procedures or User Defined Functions" for MSSQL?
cbacit
 

Re: Stored procedures or User Defined Functions

Postby Webmaster » Tue Jul 31, 2012 10:19 am

The product will not load stored procedures as tables/views in the UI. You can however run the stored procedures (as SQL) in server events by:

Dim ret As Integer = ew_Execute("<Run Proc>")
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Stored procedures or User Defined Functions

Postby ddudley3 » Fri Aug 03, 2012 9:45 am

But aren't server events specific to each table/view listed?

I want to be able to call a stored procedure I've defined and make it selectable by a link like the tables are...

How do I accomplish that?
ddudley3
 

Re: Stored procedures or User Defined Functions

Postby Webmaster » Sat Aug 04, 2012 9:14 am

Currently it is not supported.
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Stored procedures or User Defined Functions

Postby cbacit » Mon Aug 27, 2012 9:32 pm

Please support this in the next version please.
cbacit
 

Re: Stored procedures or User Defined Functions

Postby Webmaster » Tue Aug 28, 2012 9:52 am

Thank you for the suggestion. We will consider in future versions.
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Stored procedures or User Defined Functions

Postby DanielleShriek » Mon May 13, 2013 5:46 pm

Dim ret As Integer = ew_Execute("<Run Proc>")
It is not working any more what are the other alternatives to define stored procedures?
DanielleShriek
 
Posts: 1
Joined: Mon May 13, 2013 5:40 pm

Re: Stored procedures or User Defined Functions

Postby Webmaster » Mon May 20, 2013 9:24 am

Use: Conn.Execute(<SQL>)
Webmaster
 
Posts: 10728
Joined: Fri Aug 06, 2004 5:59 pm

Re: Stored procedures or User Defined Functions

Postby sumoncpi » Thu Feb 06, 2014 5:47 pm

Thank you for the suggestion.
sumoncpi
 
Posts: 7
Joined: Wed Jul 03, 2013 5:15 pm


Return to General Discussion (ASP.NET Report Maker)