Skip to main content

Posts

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.
Recent posts

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.

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"