Posts Tagged ‘reporting’

Business leaders around the world are fully aware of the precipitous drop in energy prices. Oil prices are reported to be at 5 year lows, with the absolute price per barrel cut roughly in half in 2014. This weekend in Chicago, there was a specific gas station, to which I am fortunate to live near, […]

While there are several BI technologies and more coming into the foray every day, SSRS has remained a key player in this area for quite some time now.  One of the biggest advantages of SSRS reporting is that it involves the participation of the end user and that is very intuitive to use. Let’s go […]

SSRS is a powerful tool not because it projects queries in really good looking charts but because it enhances user experience.  The reports are so intuitive that users can navigate and export data without much training.  However, as business analyst or data analysts or report designers, it is our responsibility to extend these usability features […]

Table of contents have always helped readers to navigate through thick volume of books. This feature can be extended to our users in SSRS to navigate through several pages of reports. The table of contents in SSRS is called the document map. A document map is a clickable table of contents that takes the user […]

In the past few weeks, we created variety of reports starting from simple tabular reports to colorful pie charts to user friendly drill down reports.   SSRS tool is very friendly and is developed to provide world class reports to the user community.  While browsing through several business intelligence forums, I found couple of questions that […]

SSRS report tends to hold maximum number of rows it can fit on a page.  The number of rows varies according to the page size, row width, location of the table, etc.  My report contains 99 records and these records are unevenly distributed throughout the report.  The report I created holds 36 rows on page […]

Sales Report with Date Picker. Last week we created a generic sales report in SSRS.  This week we will customize that report and display the numbers only for specific dates.  Such reports are called Parameterized reports and are user friendly because the user can choose a date range for his/her reports. So, let us begin! […]

I hope everyone has found my articles useful and have used my articles in creating some great looking SSRS reports.  This week we will take a look at creating a product breakdown report or a detailed sales report. Let us refresh our memory.  Our sales table has the following fields: Fields Description Data Type ID […]

Now that we have created out first SSRS report, it is time to make our reports presentable. SSRS is really user friendly and customizing a report is very simple. This is how our reports currently look:   Let us first add a title to the report so that the users/managers know what information to look […]

In this post, we are going to create our first report in SSRS.  Excited? Let’s get started. In order to create a report, we need 2 things: 1.)    Data source: Here, you make connection to your database in Microsoft SQL server, Oracle, Teradata, etc. 2.)    Dataset: Here, you choose your table you want to create […]

I am splitting this article in 2 parts.  In the first part, I want to talk about all the tools you need to create your first report.  Before reading the 2nd part of this post, make sure you have: 1.)    Microsoft’s Business Intelligence Development Studio 2.)    Report Builder 3.0 (I am going to use Report […]

Hello Readers and fellow Perficient bloggers, This is my first official blog post on Business Intelligence forum.  Before I tell you what my blog is about and the agenda for upcoming blog posts, I would like to give you a quick introduction. I am Sujay Nadkarni and I joined Perficient in March 2012 as a […]