Stored Procedures

  • dejamakan 10 years, 7 months ago

    Hi all,

    I am new to ActiveReports and trying to create reports using Access/SQL Server 2k stored procedures.  I am trying to use the example "How Can I Use a Stored Procedure with Date as an Input Parameter".  I do have a stored procedure but I can’t figure out how to call the stored procedure in the code.

    Thanks in advance

  • brandon DD 10 years, 7 months ago

    The code listed in the article is for creating the stored procedure in SQL server. In the data source dialog, the stored procedure is called by setting the SQL statement to "exec [sales By Year]". Basically you can call any stored procedure by calling "exec [Stored Procedure Name]".

    brandon. -DD

  • dejamakan 10 years, 7 months ago

    Thanks Brandon

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.