ActiveReports 9
Reports with Stored Procedures
Show AllShow All
Hide AllHide All

You can create a report using a stored procedure as a dataset. A stored procedure is a group of SQL statements that are used to encapsulate a set of operations or queries to execute on a database.

This walkthrough illustrates how to create a report that uses a stored procedure as a data set. The walkthrough is split into the following activities:

Note:
  • This walkthrough uses a table from the Reels database. By default, in ActiveReports, the Reels.mdb file is located in the [User Documents folder]\GrapeCity Samples\ActiveReports 9\Data folder.
  • Although this walkthrough uses Page reports, but this can be implemented using RDL reports also.

When you complete this walkthrough you get a layout that looks similar to the following at design time and at runtime.

Design Time Layout

Runtime Layout

To add an ActiveReport to the Visual Studio project

To connect the report to a data source

To add a dataset with a parameter

To create a layout for the report

To view the report

See Also

 

 


Copyright © 2016 GrapeCity, inc. All rights reserved

Support Forum