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:
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.).
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’
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.