Create a new report server project
Open Business Intelligence Development Studio; on the File menu, select New, Project, select Report Server Project in the Template list, and provide a name and location for the project.
Add a new report to your report server project
In Solution Explorer, right-click the Reports folder, select Add, click New Item, select Report in the Templates list, and provide a name for the report.
Create a shared data source
In the Report Data window, click New, click Data Source, provide a report data source name, click New, provide a shared data source name, select a provider type, specify a connection string, click Credentials, and select a report authentication method.
Create a dataset
In the ...