SSRS

In SSRS classes this week.

Use BIDS to create a new SSRS project. Open Visual Studio 2008 with BIDS installed. First create a new project (File| New | Project). On the dialog page, click Report Server Project and enter a project name:

newProj

First thing to do is create a ‘Shared Data Source’ (if not using an already created shared data source), in the Solution Explorer.  To create the Shared Data Source, right click on ‘Shared Data Sources’ in the Solution Explorer and click ‘Add new data source’. Follow the wizard to complete the process of creating a data source ( a data source is a pointer to a database and is basically a connection string: nothing more.).

CreateDataSource

So  a Data Source is a connection string and you will most likely want to use Shared Data sources. A Dataset is set of data that is pulled back from the database (or a defined query). Like data sources, there are shared and embedded version. Shared Datasets don’t appear to be as useful as embedded datasets because you will probably want to customize the query for each report and change the parameters and fields that need to be in the report.

Creating a report:

So you’ve created a Shared Data Source, which we will use as we create the new report.

In the Solution Explorer, right click Reports, then click ‘Add’, and ‘New Item’. Then select ‘Report’ as the type and enter a name for the report.

Now in the ‘Report Data’  explorer right click ‘Data Sources’, and ‘Add Data Source’. In the dialog, you will change the radio button to ‘Use Shared Data Source’ and

enter a better name than DataSource1, then hit ‘OK’

AddDataSource

Now you need to create a Dataset, which is the query that will be used to get the data that goes into the report. Right click Dataset and click ‘Add Dataset’, which opens the Dataset dialog. Click use ‘Use a dataset embedded in my report’. The select the datasource you created in the previous step (this points you to the right database). Then you can click the ‘Query Designer’ button, which will open a GUI for you to build the query which will pull the data for your report to display.

NewDatasource

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s