F5 Debug…

Building & Debugging the Technology!!!

Archive for the ‘SQL Server’ Category

« Previous Entries

Getting Started with SSRS – Part 10 – Creating a Report with Charts

Posted by Karthikeyan Anbarasan on December 23, 2011

This article is a part 10 and the final post of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).

  1. Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
  2. Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
  3. Getting Started with SSRS – Part 3 – Designing a report using Report Designer
  4. Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
  5. Getting Started with SSRS – Part 5 – Deploying a report to the Server
  6. Getting Started with SSRS - Part 6 – Creating Deleting and Moving a folder in SSRS Server
  7. Getting Started with SSRS - Part 7 – User Roles and Permissions in SSRS Server
  8. Getting Started with SSRS - Part 8 – Show SSRS Report in ASP.NET Web Page
  9. Getting Started with SSRS - Part 9 – Creating Matrix Report with inbuilt styles in SSRS
  10. Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges

 

Introduction

In this article, we will cover how to use Charts and Gauges with the reports in the SQL Server Reporting Services. In our earlier articles, we saw how to design and deploy basic reports and some options to administer the server with basic operations on manipulations with the folder. Let us see the step-by-step process on how to use the Charts and Gauges.

Steps

Follow the earlier article steps on how to open and create a Report Server project and connect to a data source (Select * from EmployeeInfo). A screen will open as shown below which is with empty screen.

Launching the Report Designer view of the Report Project

Read More

Hope this article will be useful and if you like, you can follow me in one of the ways below to get update of posts on the latest technology
Twitter @ http://twitter.com/f5Debug
Facebook Page @ http://www.facebook.com/profile.php?id=100002468858656
Linked In @ http://www.linkedin.com/pub/karthikeyan-anbarasan/1b/78b/9a4
Google + @ https://plus.google.com/117525632086880345410/posts
RSS Feed @ http://feeds.feedburner.com/f5debug/Karthik

Posted in SSRS | Tagged: , , , , , , , , , | Leave a Comment »

Getting Started with SSRS – Part 9 – Creating Matrix Report with inbuilt styles in SSRS

Posted by Karthikeyan Anbarasan on December 21, 2011

This article is a part 9 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).

  1. Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
  2. Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
  3. Getting Started with SSRS – Part 3 – Designing a report using Report Designer
  4. Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
  5. Getting Started with SSRS – Part 5 – Deploying a report to the Server
  6. Getting Started with SSRS - Part 6 – Creating Deleting and Moving a folder in SSRS Server
  7. Getting Started with SSRS - Part 7 – User Roles and Permissions in SSRS Server
  8. Getting Started with SSRS - Part 8 – Show SSRS Report in ASP.NET Web Page
  9. Getting Started with SSRS - Part 9 – Creating Matrix Report with inbuilt styles in SSRS
  10. Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges

 

Introduction

In this article we are going to see how to create a Matric Report with the help of the Report Wizard and Report Designer. In our earlier articles, we have covered how to design and deploy the report to the server with the option to design using the wizard and also with the report designer. However, in this article we are going to see how to make a matrix type report, since most of the business reports are developed based on the pivot format to analyze. Now, let us see how to design the report and get the report in a much formatted matrix format.

Steps

Open Microsoft SQL Server Business Intelligence Development Studio and select the new Report Server Project Wizard as shown in the screen below.

Read More

Hope this article will be useful and if you like, you can follow me in one of the ways below to get update of posts on the latest technology
Twitter @ http://twitter.com/f5Debug
Facebook Page @ http://www.facebook.com/profile.php?id=100002468858656
Linked In @ http://www.linkedin.com/pub/karthikeyan-anbarasan/1b/78b/9a4
Google + @ https://plus.google.com/117525632086880345410/posts
RSS Feed @ http://feeds.feedburner.com/f5debug/Karthik

Posted in SSRS | Tagged: , , , , | Leave a Comment »

SQL Server 2012 Developer Training Kit

Posted by Karthikeyan Anbarasan on December 19, 2011

Recently after the SQL Server 2012 release Microsoft team has shipped the much enhanced and updated training kit for the SQL Server 2012 development. It includes a huge list of training materials to be covered with presentations and labs on BI Symatic Model, SQL, Integration Services, Power View.

We can download the training kit from the Web Installer Preview using the link

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27721

Some of  the update include as follows:

  • Presentation: Introduction to SQL Server 2012 (SQL11UPD00-DECK-01)
  • Demo: A First Look at SQL Server Data Tools (SQL11UPD00-DEMO-03)
  • Hands On Lab: Build Your First Web Application with SQL Server 2012 and ASP.NET (SQL11UPD00-HOL-01)
  • Hands On Lab: Exploring Transact-SQL Improvements in SQL Server 2012 (SQL11UPD00-HOL-02)
  • Hands On Lab: Managing Rich Unstructured Data in SQL Server 2012 (SQL11UPD00-HOL-03)
  • Presentation: Introduction to SQL Azure (SQL11UPD07-DECK-01)
  • Presentation: Advanced SQL Azure (SQL11UPD07-DECK-02)
  • Hands On Lab: Migrating Databases to SQL Azure (MigratingDatabasesToSQLAzure)
  • Hands On Lab: SQL Azure Data-tier Applications (SQLAzureDAC)
  • Hands On Lab: Build Your First Report with SQL Azure Reporting (SQLAzureReportingServices)
  • Hands On Lab: SQL Azure Data Sync (SQLAzureDataSync)
  • Hands On Lab: SQL Azure Federations (SQLAzureFederations)

Hope this training kit will be of great use for the developers to dig with the new features of SQL Server 2012.

Happy Coding!!!

Posted in SQL Server 2012, SQL Server Denali | Tagged: , , , , , , , | Leave a Comment »

Getting Started with SSRS – Part 8 -Show SSRS Report in ASP.NET Web Page

Posted by Karthikeyan Anbarasan on December 15, 2011

This article is a part 7 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).

  1. Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
  2. Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
  3. Getting Started with SSRS – Part 3 – Designing a report using Report Designer
  4. Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
  5. Getting Started with SSRS – Part 5 – Deploying a report to the Server
  6. Getting Started with SSRS - Part 6 – Creating Deleting and Moving a folder in SSRS Server
  7. Getting Started with SSRS - Part 7 – User Roles and Permissions in SSRS Server
  8. Getting Started with SSRS - Part 8 – Show SSRS Report in ASP.NET Web Page
  9. Getting Started with SSRS - Part 9 – Creating Matrix Report with inbuilt styles in SSRS
  10. Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges

 

Introduction

In this article, we will cover how to use the deployed SSRS Report on to the ASP.NET Web application. In our earlier articles we have seen the steps to create and deploy the report to the Reporting Server and administer the deployed reports. In real time, we have seen requirements on accessing the reports from different clients. Let us now move ahead for the step-by-step process on accessing the SSRS report in ASP.NET web pages dynamically.

Steps

Before starting the steps to show the SSRS Report in ASP.NET Page, we should just have a look around on the previous articles to get some fair idea on how to design the report and deploy it to the Report Server.

First, open visual studio 2010 IDE and create a new ASP.NET Project as shown in the screen below. In this example we are going to use the report which we deployed in the Part 2 of this series of articles on SSRS.

Read More

Hope this article will be useful and if you like, you can follow me in one of the ways below to get update of posts on the latest technology
Twitter @ http://twitter.com/f5Debug
Facebook Page @ http://www.facebook.com/profile.php?id=100002468858656
Linked In @ http://www.linkedin.com/pub/karthikeyan-anbarasan/1b/78b/9a4
Google + @ https://plus.google.com/117525632086880345410/posts
RSS Feed @ http://feeds.feedburner.com/f5debug/Karthik

Related articles

Posted in SSRS | Tagged: , , , , , , , , , | Leave a Comment »

« Previous Entries