Deploying SSRS 2008 Reports to SharePoint 2010 sites in Integration mode

 

Scenario: We have SSRS 2008 R2 configured for SharePoint 2010 Integration mode.

Requirement: We as a BI Developer, need to develop and deploy the reports to the SharePoint sites.

Walkthrough:

Step 1: Fire up BIDS – New Project – Select “Report Server Project” from the templates – Name the project “MyFirstReport” – Click OK.

Step 2: Let’s create the Shared DataSource. Right click the [Shared DataSources] in Solution Explorer and click “Add New DataSource” – Fill the [General] Section with the Name=”DataSource1”, Type=”Microsoft SQL Server” and edit the ConnectionString. We’ll select “Use Windows Auth” to connect to our DB for this example (This may vary based upon your Authentication mechanism).

Leave the [Credentials] Section with “Windows Auth” selected. Click Okay and you should see the DataSource1.rds created in the Solution Explorer.

Step 3: Now let’s create a report. Right click the [Reports] in Solution Explorer and click “Add New Report” – Go through the Report Wizard using the DataSource1.rds that we created earlier – Build your query by adding the appropriate tables – Select your Report Type (Table/Matrix, I’ll select Table) – Design your Table (I added all fields to the Details section) – Choose Table Style (Corporate) – Finish the wizard by naming the report “Report1”. You should see the Report1.rdl in the Solution Explorer.

Step 4: At this point, you can build the report and switch to the preview tab to view the report.

Step 5: It’s time for deploying our reports. Quite simple, just right-click on the project and deploy (if you want all the datasources and reports to be deployed in one go, else you can deploy them individually). Okay, right-click and deploy, uh Oh ! what happened. This is not what we wanted to see.

Okay, we never provided the SP Site URLs. Also, we need to make sure and plan where will our Datasources and reports should be deployed on the site.

Step 6: So let’s create the Document Libraries, one for Datasource and another for Reports. Browse the SP site and create them now. I created the following: [DataSources] and [Reports] without the braces [ ].

Step 7: Now, let’s get back to our BIDS project. Right click on the project and choose Properties. There you are, if you see the values there, they are the default values for SSRS in Native Mode.

So we need to change them to comply with our needs. Modify them as shown here:

Ok now that looks better. Let’s try to deploy again. It should do just fine. Browse to the “Reports” library on the site and click on the

You should be able to see the report.

Technorati Tags: SharePoint 2010,SSRS 2008,Reports,Integration Mode

Configuring Anonymous access on SP2010 sites

The steps involved in enabling anonymous access to a SharePoint 2010 site are very similar to what we have been doing in MOSS 2007, so I won’t go into details of everything and do a quick walkthrough for achieving the same in SP 2010.

So here are the basic steps:

Step 1: Create the Web Application and the Site Collection.

Step 2: Select the Web App in [Manage Web App] section.

Step 3: In the ribbon, click [Authentication Providers].

Step 4: You’ll only see the “Default” zone, if you have just followed my instructions above and have not extended to any other zone. So, click the Default from the list.

Step 5: Select the check-box for [Enable Anonymous Access] and leave the [Windows Authentication] section as it is. You want this to sign-in using your AD account and grant access for “anonymous” users in the next step. (You may also want this to let you make additions/modifications to the site later.)

Step 6: Click Save.

Step 7: Next, login to your site using your AD account as the Site Collection owner.

Step 8: Go to [Site Permissions] – [Anonymous Access] on the ribbon – Then select “Entire Site” – Click “OK”.

Step 9: Once you are done with all changes/updates to your done, follow the Steps 2 through Step 5 again and uncheck the [Windows Authentication] and Click Save.

Step 10: You might get the error “401”, if you try to refresh the page after Step 9. In this case, clear your cache, close all the browser instances and try again. You’ll be able to get to the site without any login prompt.

So there it is. In just 10 steps you have been able to setup an anonymous site.

Technorati Tags: SharePoint 2010,Anonymous Access