Posts

Showing posts from October, 2014

How to install SQL Server 2012

Image

How To Install SQL Server 2008 R2

Image
In above slide SQL server agent                             AS          NT AUTHOURTY/ NETWORK SQL server database Engine            AS          NT AUTHOURTY/ NETWORK SQL server analysis service             AS          NT AUTHOURTY/ NETWORK SQL server integration service        AS          NT AUTHOURTY/ NETWORK SQL server reporting service          AS           NT AUTHOURTY/ LOCAL    

Chart Report in SSRS

Image
When you want to summarize data in a visual format, use the chart data region. Charts enable you to present large volumes of aggregated information at a glance. It is important to carefully prepare and understand your data before you create a chart, as this will help you design your charts quickly and efficiently. Step 1: In the Solution Explorer, right click on the "Reports" folder and click on Add -> New Item as shown below: Step 2: In the Add New Item dialog box, select the "Report" template and specify the name of the report that you are creating, as shown below: Step 3: Then click on Add button. So your blank report is added Step 4: To create a data source, right click on Data Sources in Report Data Pane and click on Add Data Source as shown in below screen shot: Step 5: It will take you to the screen of Data Source Properties , where you can use either shared data source or embedded data source in report. Here we used a share