Adhoc Reporting Using SSRS 2008 R2

3.
Right
click the data sources and Select the option Use shared connection or report
model.

4.
Browse
to the Models folder and select the model AdventureWorks. Click Open
and then OK.

5.
Right-click on Datasets and add dataset. Click Select the dataset embedded
in my report and click on the query designer.

6.
The
below dialog box opens where you can now drag and drop the fields from the left
pane.

7.
I
have chosen sales group, sales current year and sales last year fields to
analyze. Click OK.

8.
Click
Ok.

9.
Thus
using the report model and Report Builder the following report was created in
less than 5 mins.

Pages: 1 2 3




Array
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |