Skip to main content

Posts

Showing posts from March, 2011

SQL - Reporting Server - Part III

Display Reports in Web Application Open Visual studio and create a new Web Application. Add Microsoft Report Viewer control. Specify the ReportServerURL and ReportPath in report properties. Run the application and see the output in browser.

SQL - Reporting Server - Part II

Create a New Report Server Project 1. Open Visual Studio. 2. New --> Project -->    2.1. Select Project type --> Business Intelligence Project.    2.2. From the template select   Report Server Project. 3. In the solution, Right click in Shared Datasource and select  Add New Datasource. 4. In the properties window general tab enter the data source name and server type.    4.1. Create new connection click Edit button.    4.2. Or you can directly enter the connection string a in the text box. And In the Credentials tab enter the username and password.  Eg.  Data Source=SAM;Initial Catalog=NHG; Adding New Reports:    You can add the report in two ways.   1. Using Report Wizard.   2. Using Bland Report.   1. Using Report Wizard. 1.1. In the solution, Right Click at Reports and select Add New Report. It will display the Report Wizard to generate Report. 2. Using Bland Report.  2.1. In the solution, Right Click

SQL - Reporting Server - Part I

Configure a Reporting Server in SQL - 2008 Steps: 1. Open the Reporting Service Configuration Manager. Start --> All Programs --> Microsoft SQL Server 2008 --> Configuration Tools --> Reporting Services Configuration Manager. 2. Select the server name from the list. 3. Set the server account name 4. Set the Service URL. 5.Select or create Reportserver database. 6. 6. Input the virtual directory path. 7. Now we successfully configured the Reporting Server.