SQL Report Services and DotNetNuke

Create Report Model

When creating a report using Reporting services, you have the option to use a Data source for the report or a Report Model. A Report Model is required to design a report using the advanced online report designer.

This tutorial will walk you through the creation of a Report Model.

Note, this tutorial assumes you have Reporting Services installed on your local computer at http://localhost/Reports.		  

What you will need:
     

Install and configure SQL Reporting services

This book is on SQL Server 2005 Reporting services but it is recommended reading:
Developer's Guide to Reporting Services 2005 		   

Open Visual Studio. From the menu bar, select File then New Project.		  

From the New Project screen:

  • Select Business Intelligence Projects in the "Project types:" section
  • Click on Report Model Project
  • Enter ReportModelProject for Name
  • Click the Create directory for solution box
  • Click the OK button
  
When the project opens, right-click on the Data Sources folder in the Solution Explorer and select Add New Data Source.  
When the wizard comes up, click the NEXT button to navigate to the "Select how to define the connection" screen.

Click the New button to define a new connection.		  
Enter the connection information to connect to the database of your DotNetNuke site.

Use the Test Connection button to test the connection.

Click the OK button.		  
The connection will show on the "Select how to define the connection" screen.

Click the Next button.		  
Give the Data Source the name Dot Net Nuke Dev and click the Finish button.  
Right-click on the Data Source Views folder in the Solution Explorer and select Add New Data Source View.  
When the wizard comes up, click the NEXT button to navigate to the "Select a Data Source" screen.

You will see the Data Source you created previously.

Click Next.		  
The tables in the DotNetNuke site will appear. Select the EventLog table.

Click Next.

(Note: Normally you would not make a report using DotNetNuke core tables because they could change. The core table is only used for demonstration)		  
Click the Finish button.  
Right-click on the Report Models folder in the Solution Explorer and select Add New Report Model.  
You will see the Data Source View you created previously.

Click Next.		  
Accept the defaults and click Next.  
Accept the default and click Next.  
On the Completing the Wizard screen, click the Run button.  
Click the Finish button.  
When the popup box shows, click the Yes to All button.  
The model will show in the designer.  

Deploy the Model

You will now deploy the model to the SQL Reporting Services website.		    

Right-click on the project in the Solution Explorer and select Properties.		  
Ensure that the settings are correct and click the OK button.  
Right-click on the project in the Solution Explorer and select Deploy.  
In your web browser, navigate to the Reporting services website (usually http://<server name>/Reports)

and navigate to the Models directory (usually http://<server name>/Reports/Pages/Folder.aspx?ItemPath=%2fModels&ViewMode=List)

You will see the Report Model you just created.		  
     

Next Steps:

Create a Report

    
     

 

[Back to: The ADefWebserver DotNetNuke HELP WebSite]

 


Buy DotNetNuke Modules from Snowcovered

 DotNetNuke Powered!DotNetNuke™ is a registered trademark of DotNetNuke Corporation.