SSAS (SQL Server Analysis Services) Competitors

Above information has been received from:
link

SSIS (SQL Server Integration Services) Competitors

Do you want to know who are Microsoft SSIS 2008 competitors with their features? Following is the details:

Above information has been received from following white paper:
White Paper URL

Add your existing report as report template in SSRS

This is very intersting stuff..

My requirement is: I have one report and I want to add this report as report template in list of SSRS templates, so that I neither need to rewrite my report nor need to add sub reports.

Answer is: Just create your standard template report and Once your are done with your report, just copy and paste your standard report at following location:

C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

You are all set.. You will see your report as standard template in BIDS(Business Intelligence Development Studio)

How to develop Standard and Data driven subscription?

Creating standard subscription is fairly simple

• Go to report manager
• Open report properties
• Select subscription
• Create new subscription
• Select your delivery method (Windows Share/Email/Sharepoint library)
• Define required parameters
• Define schedule (Custom/Shared)
• Click OK.

You are all set!!!

Creating Data driven subscription is somewhat tricky,

• First of define one table in your database for your subscription paramter (e.g. tblSubParameter), like

- Email To

- Subject

- Render Format (PDF/Excel etc)

- Include report link etc...

• Once you are ready with your report table, go to report manager
• Select report and open report properties
• Go to Subscription
• Create a new data driven subscription
• Give some name for subscription
• Select datasource (Shared/Custom) where your subscription parameter table exists.
• Click Next
• Write the query to fetch the parameters (E.g. select * from tblSubParameter)
• Validate your query
• On successful validation, click Next
• In place of giving static values for each parameter like, Email to, render format. etc... ; Select parameter which is coming from database
• Select all required database parameters, click next
• Select report level parameters, click next
• Select schedule, click FINISH.

You are all set!! now at scheduled time, subscription event will fire and it will bring subscription parameter information from database and based on your table information, report server will send the report subscription...

Different Delivery Extensions for Subscription in SSRS

Following are the different type of delivery extension for SSRS report subscription(Scheduling)

Avaliable with SSRS Native and Sharepoint Integrated mode:

• Windows file share: Delivers report to predefined share location. The share location name should be in UNC(Universal Naming Convention)  format.
• Email: Delivers report as an email attachment or URL link

Avaliable only with Sharepoint Integrated Mode:

• Sharepoint library:Delivers report as an static application file to sharepoint library.

Subscription in SSRS

A subscription that delivers a specific report to one or more e-mail accounts or to a designated network file share on a scheduled basis.

There are two types of subscription in SSRS.

• Standard Subscription: Standard subscriptions are created and managed by individual users. A standard subscription consists of static values that cannot be varied during subscription processing. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters.

• Data Driven Subscription:Data-driven subscriptions get subscription information at run time by querying an external data source that provides values used to specify a recipient, report parameters, or application format. You might use data-driven subscriptions if you have a very large recipient list or if you want to vary report output for each recipient.

It is better to go for data driven subscription, when you have

• Large no of recipients   OR
• Different recipient has different file format requirement OR
  
• Each recipient need reports execution based on different parameters

So decide what is the best for your enterprise, and implement it!! keep learning!

View SSRS Report in Sharepoint Web Part

In order to view SSRS report in Sharepoint Web part follow the steps:

1. Complete all the steps as per last post- for integrating SSRS with MOSS 2007

2. On successful completion of integration, 

• Go to your Sharepoint site settings.
  
• Under Library -> click on Report Library
• Upload your SSRS report rdl file under this report library folder
• Once report is uploaded, right click report and click on Data sources
• Update datasources with proper credential information.
• On completing this stuff, your SSRS report will be ready to deploy on sharepoint site.

3. Now it is time to view report on sharepoint site.

• Open sharepoint site
• Edit your page
• Click on add new web part
• Add a web part called, SQL Server Reporting Services Report Viewer
• Open Report viewer web part properties
• Select Report location using report browser. (Note: Your reports will be under your report library)

You are all set!! Sharepoint web part will show the report under sharepoint context.