Skip to main content

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. Input the virtual directory path.
7. Now we successfully configured the Reporting Server.

Comments

Popular posts from this blog

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.

File System Watcher

The Following is the example for File System Watcher. Create Console Application in Visual Studio. File --> New --> Project In the Template Select the Console Application. Eg: Namespaces Used : using System.Security.Permissions; using System.IO; These two namespaces used for file operation and file permissions. Code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Security.Permissions; using System.IO; namespace Watcher {     public class Watcher     {          public static void Main()         {             Run();         }         [ PermissionSet ( SecurityAction .Demand, Name = "FullTrust" )]         public static void Run()         {             // Create a new FileSystemWatcher and set its properties.             FileSystemWatcher watcher = new FileSystemWatcher ();             watcher.Path = @"D:\P

Microsoft Chart Controls - ASP.NET

Downloads: Click here to download Microsoft chart control add on.  Install the add on. Steps : Add Chart control in your VS tool box.   2. Create a New Web Application. 3. Drag and drop the chart control to design page. 4. The 3 major properties of the Chart is  Title,Series and Chart Area.     4.1. Title property is used to set the title of the chart.     Eg:      < Titles >       < asp : Title ShadowColor ="32, 0, 0, 0"                  Font ="Trebuchet MS, 14.25pt, style=Bold"                    ShadowOffset ="3" Text ="Sample 1"                    Alignment ="MiddleCenter" ForeColor ="White">       </ asp : Title >    </ Titles >  4.2. Series is collection of values to show in the chart.   Eg:      < Series >        < asp : Series Palette ="EarthTones"                 ChartArea ="MainChartArea"