SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have a SSRS Report using Report Builder and inserted an Image.  It is set for:
MIMEType = image/png
Source = Database

I want to be able to rotate the image 90 degrees.  How can I do this?
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

The rectangle is too complex to export data to word using ssrs report
I have an issue with a calculation in SSRS 2016. My tablix reports on orders and has 3 row groups. From outside to inside that is:
- Whether the order was closed or missed (boolean)
- Market segment
- Market subsegment
I also have a column groups for month and year-to-date.
My problem is that I want to perform a calculation for the ytd column group that involve results from both the "closed" and "missed" results in the row groups, for the market group and subgroup records. I've tried to illustrate it in attached example.
Anyone have any idea what expression i can use to achieve this? Not sure if it matters, but the datasource is an SSAS MDX cube.

Regarding SSRS datepicker. It is not showing/working in google chrome. Is there any way I can try to make it work? Can I use class or Id to make it as datepicker using jquery? Any suggestion.

Hello there,

In ssrs how do I make sure that alignment of the image and data set are aligned to the  destination rows and column ? I'm using  textbox and list to position my data, when I open in excel the alignment  look weird  as it doesn't position with the same row
Is it possible in SSRS 2016 to dynamically set date parameters ?

I want to have two Date Parameters with no default value, Start Date and End Date.

I would like the user to perhaps from a drop down list, Select Yesterday to Today, Week to Date, Month to Date, Year to Date, Inception to Date and have the selection update the Start Date and End Date.

Thank you.

I have an urgent requirement, please anyone can help me? I help when exporting SSRS to csv, I need to show column header with space for  2 two words column names.
Ex.   Client Number

Thank you.

I am trying to set up multiple Boolean parameter in my report.  They are not dependent on each other.  It works fine and the 'true/false' toggle works fine.  But I still see the empty columns.  I am not sure where the issue is.  I added =IIF(Parameters!xyz.Value, False, True) in the visibility for that textbox.  I also tried playing with tablix visibility and other groupings I have within this report.  I can't seem to make these columns NOT show if the value is set to false.  

Any ideas?
SSRS: I have a multivalued parameter populated using a query which returns thousands of records. I want to disable the <Select All> option and add my custom <All> option. This is because whenever <Select All> is selected, it gets all the options which exceed the maximum allowed characters. Please help. Thanks.
I am working on another report using `SSRS` via `Visual Studio 2010`. I am a rookie with SQL but things are starting to make sense as the weeks go on.

Purpose is to create a report that displays the `Batch up time / downtime` calculated from the `timestamps` taken from a SQL server database. The time stamp is represented as a date/time input, an example, `2018-02-09 14:43:29.193`.

There are 4 Event ID's 1-4 that must be met to trigger a time stamp in the database. Each batch has it's own 3 digit integer ID.

    1-Batch Start, Not running production, but system is initiated. (Down)
    2-Production Start, Running production (Up Time)
    3-Production Stop, Machine is running, but not producing (Down)
    4-Batch Stop, Production complete. (Down)

The difference between,

    2&1 = Downtime
    4&1 = Downtime
    2&3 = Up time
    If 4 is after 2 = Up time
    If 4 is after 3 = Downtime

See the database image which is the working set I am dealing with.

I have done my best with this report with limited knowledge, and in the report I have created parameters to choose dates for the report, along with asking the user to pick the Batch ID along with Batch 1-4 Event's, however I am not sure how to tackle the calculated fields.

Below is the SQL code,

     /****** Script for SelectTopNRows command from SSMS  ******/
    SELECT TOP 1000 [Productio_CrtNo]
Free Tool: Path Explorer
LVL 12
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Print button and date picker  of SSRS Report viewer of,  are not visible in non-IE browsers (google chrome)
Subscriptions.docxSSRS.  Everytime the report server is restarted subscriptions fail with the following:  Failure writing file (to location): The network path was not found.  
However I have found that in reality the password for the user has to be re-entered.  
The path is accessible when I run to that location from the Report server.   If just re-enter the password and save the subscription works.
This is a SSRS 2014 but I have seen the same issues on 2008R2 and 2012.  
Any ideas or suggestions would be appreaciated.
Report Viewer works on ASP.NET Website but not Mac. Shows Blank pages.  Some posts indicate it has to do with overflow:auto defauting to hidden on Mac and visible on Windows.
HI there, I am using SSRS and have a problem where my grand total on the last page of the report will only calculate the the times of the pages that have been shown. In other words, if its a 3 page report and I run it and view the first page then skip to the last it will calculate the first and the last missing out page 2. If however, I run the report and go through each page using the next button it then calculates the total correctly.

My total is a SUM of a previous total and both are code elements within the report, after doing a bit of research I found out that this is why, the code elements only fire on the page that is in view.

My 2 code elements are:

Public shared dim totalJobTypeRateTotal as Decimal

Function AddTotal(ByRef JobTypeRateTotal AS Decimal) AS Decimal
                totalJobTypeRateTotal = totalJobTypeRateTotal + JobTypeRateTotal
                return JobTypeRateTotal

End Function

====This function calculates row items based on a lookup that finds the specific rate for each job type=====

 Public Function GetTotal()
                return totalJobTypeRateTotal
End Function

====This is the grand total at the end of the report group that will only calculate the total of the AddTotal function expression on pages that have been viewed====

How do I get the 2 code calculations to produce a grand total correctly without having to scroll through each page?
Hey all I am pulling out my hair trying to figure out why this is telling me that there are duplicates of the key for ReportViewerWebControlHandler.

This is what my web.config file looks like (omitting things that do not apply here)
<?xml version="1.0" encoding="utf-8"?>
    <add key="webpages:Version" value="" />
    <add key="webpages:Enabled" value="false" />
    <add key="ClientValidationEnabled" value="false" />
    <add key="UnobtrusiveJavaScriptEnabled" value="false" />
    <add key="owin:AutomaticAppStartup" value="false" />
    <add key="vs:EnableBrowserLink" value="true" />
    <sessionState mode="InProc" timeout="30" />
    <machineKey validationKey="****" decryptionKey="****" validation="SHA1" decryption="AES" />
    <compilation defaultLanguage="c#" targetFramework="4.5.1" debug="true">
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=89845DCD8080CC91" />
        <add assembly="Microsoft.ReportViewer.Common, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
        <add assembly="Microsoft.ReportViewer.DataVisualization, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
        <add assembly="Microsoft.ReportViewer.Design, 

Open in new window

Hey all I currently have my datasource/dataset defined inside my rdl file like so:
  <DataSource Name="DataSource1">
        <ConnectString>Data Source=Z92hf54d;Initial Catalog=B2018</ConnectString>
  <DataSet Name="DataSet2">
            <QueryParameter Name="guid">
        <CommandText>SELECT,BL.poc,BL.description,BL.number,BL.line,,BL.type,BL.IPhase,BL.environment,BL.servType,BL.bDescription FROM BL</CommandText>
            <QueryDefinition xmlns="">
                    <ColumnExpression ColumnOwner="BL" ColumnName="id" />
                    <ColumnExpression ColumnOwner="BL" ColumnName="poc" />
                    <ColumnExpression ColumnOwner="BL" ColumnName="description" />
                    <ColumnExpression ColumnOwner="BL" ColumnName="number" />

Open in new window

How do I redirect the SSRS 2014 URL?  I'd like to make it so it's not http://server/reports but just http://reports for internal users.
Hey all I am trying to find a way to populate a SSRS report with what a user selects on a page. The user will be able to select any table and any database to put some data together and I need to be able to take that data and place it onto a report that they can download via PDF and/or Excel.

Currently I have not found any good examples of dynamic creating SSRS reports. The only close example I found doesn't work in VS 2017 (here).

Is it possible for a SSRS guru to post some sample code (compatible with VS 2017) that has a good example of the above issue I am looking to solve?

The current code setup in my MVC project is this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportViewer.aspx.cs" Inherits="BOM2017.Reports.ReportViewer" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html>

<html xmlns="">
<head runat="server">
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager" runat="server"></asp:ScriptManager>
            <rsweb:ReportViewer ID="QIUReportViewer" runat="server" AsyncRendering="false" Height="700" Width="1150"

Open in new window

Below Query Command Text runs fine in SSRS Dataset to retrieve records. It retrieves data from a function with parameters.

FROM WKLD.fnGetOEDGETransReportData(@FromDate,@ToDate,@FromHr,@ToHr,@FromMin,@ToMin,@Office,@Desk,@Shift,null)

Now,  what I am trying to do is add a Where Clause so the query looks like this.

FROM WKLD.fnGetOEDGETransReportData(@FromDate,@ToDate,@FromHr,@ToHr,@FromMin,@ToMin,@Office,@Desk,@Shift,null)
Where ActivityName = "TOP"

But, I get the below error.

Invalid column name 'TOP'.

How can I include a Where Clause in this query or can it not be done.
I do not want to change the function since I did not write it unless I have to.
Just want to change this Query Command Text in the SSRS Dataset to include Where Clause.
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I am putting together a report for our production facility to show when lines are ready to run and whether another process is also ready to run. Attached is the sample report I am trying to duplicate using SSRS (rto.png). However, when I run the report in SSRS, the lines are not continuous across the report as shown in capture.png.

The report will run once weekly for the previous seven days from GETDATE()-8 6am through GETDATE()-1 6am.

The data points the report is based upon are both either 0 or 1. There is only a data entry point if the value changes. So the way I have set up the stored procedure is to find the first data point AFTER 6am on the first date and then set the value at exactly 6am to the opposite of that. I have done this for READY and RUNNING. When the data point changes, there is an entry in the database.

I want the lines to continue across and print until the value changes.

I have manipulated the final values for READY by adding .1 to the value so they can both appear on the same chart and not be right on top of each other. The READY will show on top in the chart because this process is supposed to be READY if the line is RUNNING. The RUNNING line should always be underneath the READY line. The processes are both either on or off. I'm also including a chart showing the data this is currently pulling.

How can I get the lines to continue at their current value until that value changes?
Hello experts -

I am really stumped on this one. I feel like I am just totally missing something easy but it is escaping me.

We are in the process of upgrading our SQL servers from 2008 to 2012 and part of that is to re-point the SSRS data sources on report manager to the new servers. Everything works great - I am just updating the connection strings on the new server with the IP address of the database server. However, when I use the attached code to verify the connections have been changed, it pulls the old connection string. And what is very odd is that all the connection strings should be completely blank with the exception of the few that I have entered manually for my tests.

The attached document has everything I think you will need to help me figure this out. I have attached the screen shot of report manager first along with the new IP address that the connection string should have. I have also included screen shots of SSMS with the server and database visible and the results that show the incorrect connection string. Lastly I included the actual code I found online.

I initially thought maybe I had something cached but I got one of my co-workers to run it on her machine and the results were the same. My next thought is maybe the default schema needs to be changed? But I have had no luck with that either.

Any thoughts will be greatly appreciated.

Thank you.
We're using SSRS 2016 & SQL SERVER 2016 in our environment and don't want to use IIS.
We've a requirement to re-direct report manager URL to Target URL (Similar to URL rewrite function of IIS). When I access the report server URL - http://ssrs01/reports/redirect?<redirectnewurl>
In a nutshell I'm trying to achieve when someone tries to access above URL they will be automatically redirected to the target url <redirectnewurl>
I did research a lot and found this link useful which redirects from http: to https:
But we don't have any need to use SSL as it is only internal environment and looking for optimal solution
I have a web application that includes SSRS.  I have created a sql username for the reporting services.  Reports are delivered from a web page.  When a user selects a report he/she is prompted for a username and password.  I need instruction on how to provide the sql username/password so that the credentials are not prompted for.

Any help appreciated.
We are starting upgrade project to upgrade from SQL Server 2008 to SQL Server 2016

What is the best/ fastest way to upgrade all SSIS packages and SSRS reports ?

Hi, I have a report setup on Report manager (SQL SERVER 2005)
The data source I have used many many times.
The report runs fine when I run it myself on the report manager.
I setup a subscription so the report would run and email to myself.
But I'm getting this error "Failure sending mail: Logon failed."
And I can't understand why since other reports linked to the same data source will send the reports to the same email.

Any advice would be much appreciated
Thank you


SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.