Feature Tour

In order to get the samples running without any difficulty you should read how to setup the sample environment.

The SharpDevelop Reports for .NET feature tour will cover the following topics:

{toc}

1 - Creating Reports using the Pull Data Model

First, please click "File / New" then select "Sharp Develop Reports" and click the "Create" button.

This brings up the SharpDevelop Reports Wizard where you can set the Report Name, the Report File Name, the Report Path and select the Report Model. Please keep "Pull Data" selected, then click the "Next" button:

The next page allows you to define a database connection by right clicking "database connections" and selecting "Add connection"

In the upcoming Data Link Properties dialog please select "SQL Native Client" and click "Next":

In the Connection dialog please fill in the values as shown below and click "OK":

Your SharpDevelop Reports wizard now shows the database connection and you can display the elements of the selected datasource:

Now please drag and drop the table "Categories" to the Command Text window. This will autogenerate the SELECT statement:

The next step in the wizard shows you the result set for your SELECT statement:

When clicking the "Finish" button now, your report will be generated and shown in the report designer:

When clicking the "Preview" tab you can preview the rendered version of your report:

And last but not least, when you click the "Report Viewer" tab you can print or export your report to a PDF file:

2 - Creating Reports using the Push Data Model

3 - Creating Reports using Stored Procedures

4 - Creating Reports using Stored Procedures with Parameters at runtime