I have production SQL Server machine with 10 separate instances on it: The last instance that was added included an install of SSRS. Since that time I've seen high CPU usage on a random single core ...

I am in the process of building a new environment for my company's Customer Relationship Management (CRM) system. This system is a commercially available product which uses SQL Server as its back end ...

If a Reporting Services user group has all rights on SRS Report Server folder, and one of the group member's Windows Account has been added to the folder with Browse only, will SQL server cause that ...

I'd like to execute an SSRS subscription after some ETL work run by a SSIS package that takes a varying amount of time completes. I'm considering using this method, which basically consists of SSIS ...

How can I make a copy of SSRS Report Snaphot History to another folder in Report Manager. I have a report this has history snapshots. But want a copy of the report snapshot history in another folder ...

I need to reproduce the exact emails sent to one recipient across all the data-driven schedules on our SSRS instance. In SQL Server using sp_send mail, I could just query
dbo.sysmail_sentitems. Its ...

I have a fairly specific set of data I am trying to display.
I have a dataset of helpdesk ticket data. I would like to display a line chart that shows tickets opened and tickets closed by day, over ...

In a SSRS matrix report I'm trying to make a conditional format on the 'Total' column
By checking one of the columns for a specific value,
For example:
In case in one of the Groups (Toys, Clothing, ...

So I'm trying to troubleshoot a particular SSRS RDL Report that literally takes forever to run (mostly because it has a mile of SQL to run).
My question is: Is there any way to retrieve the execution ...

I'm reviewing some execution logs for long running queries in SSRS.
A common thread I'm seeing is reports that seem to take a few hours to process, with a rowcount of 0.
I'm using the following query ...

I'm currently reviewing a case where an SSRS server is experiencing frequent blocking and deadlocking.
The reports are not business-critical, and they are frequently killed to alleviate the blocking.
...

I am cleaning up our existing SSRS (report server) and would like a few suggestions and best practices in terms how it should be used. Currently each report has a connection and schedule. Would it be ...

I am about to start a project for SSRs report base on a USP. The procedure will have to use two cursors to compare orders v stock position (similar to a mrp run ): I am thinking of storing the data ...

Wanted to know if I can have two SSRS instances on the same server, one in native mode and one in SharePoint integrated mode.
I have one SSRS instance in native mode on a SQL server default instance ...

I imported an SSRS 2008 Datasource to SSRS 2012 using RS Scripter tool.
The DB connection is the same for the SSRS 2008 and SSRS 2012 data source created.
I can 'test successfully' the login/pw for ...

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...

I have inherited a project using SSRS. One report uses an rdlc file that has subreports in. I need to change one of the subreports as there is a date issue with an expression. when I change the sub ...

I've set up a server with native reporting services, connected to a database server which hosts its two databases. I'm trying to run a backup of the two databases so I can add them to my availability ...

We are building a new SSRS 2008R2 environment on a separate network.
How can I migrate the reports from our current network to the new network?
Can I backup the reports from the existing SSRS server ...

I have a SSRS report that has one column called startime that is listed in mm:dd:yyyy hh:mm:ss format. For the header of this column I want to minus the first date from the second date to give me an ...

We are in the process of migrating some work from Microsoft SQL Server 2000 to SQL Server 2012.
As part of that process, we've been using rsconfig.exe to reconfigure some reporting services instances ...

I had to modify a report that was assembled entirely within table (with 1 column and 10 rows). After my modifications, the report now spans multiple pages and I need it to break naturally at one point ...

Is it possible to determine what SPID was created to execute a SSRS report?
I am trying to prevent users from running the same report multiple times. So what I was thinking of doing was retrieve the ...

I'm currently in a SQL Server 2005 environment that's being upgraded to 2012. I need a tool to script out all of my SSRS subscriptions, and I chose to use RSScripter.
I'm having an issue whenever I ...

We have the Reporting Services installed on our database but we are not actually using it. Generally, the running process takes up a few MB but all of a sudden it has jumped to 4GB. We have restarted ...

In the below expression I am wanting to evaluate several things. I want to turn the value red if the material % is greater than 89.9 %. If it is not then look at the following. is the invoice amount ...