F5 Debug…

Building & Debugging the Technology!!!

Archive for the ‘SSRS’ 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 »

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 »

Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server

Posted by Karthikeyan Anbarasan on December 13, 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 see how to set user access roles and permissions for a specified user in SQL Server Reporting Services. User permissions in SSRS server is a big challenge for accessing the server for specified users. In this article, we will see how to add a new user role and provide permissions for the user to access particular components of the server reports. Let us see the step-by-step process on how to create user role and permission on the server.

Steps

First, let us step into the Report Manager by accessing the local URL or server URL, http://localhost/reports. With this we can see the user interface 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

Related articles

Posted in SSRS | Tagged: , , , , , , , | 2 Comments »

« Previous Entries