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

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

2. 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:

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

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

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

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

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

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

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

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

11. 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

1. To create a Push Data Model based Report, please repeat the steps 1 to 8 of "Creating Reports using the Pull Data Model". Instead of clicking "Next", now please right click you result set and select "Save Result (Schema only)" and enter a file name for your .xsd file:

2. Now please create another Report, but instead of choosing "Pull Model" in step 1 of your wizard, please choose "Push Model" and click "Next". Step 2 of your wizard now allows you to select your previously created .xsd file and check which fields should be databound to your report:

3. After clicking the "Finish" button, your report will be shown in the report designer:

3 - Creating Reports using Stored Procedures

4 - Creating Reports using Stored Procedures with Parameters at runtime