SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.

learn more… | top users | synonyms (1)

0
votes
1answer
49 views

Creating a constraint

I created a report that records entries from a table which has 4 columns 1 Shipper ID 2 SHipper Reference 3 loading 4 Completion My primary keys are columns 1 and 2 there are no foriegn keys, ...
0
votes
0answers
292 views

SSRS Consuming a Single Core

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 ...
1
vote
0answers
63 views

SSRS Filter efficiency question

People at my organization use SQL Queries within SSRS reports: for instance SELECT name, age FROM egTable Then, this query is run on the database and then they use a FILTER within SSRS to get rid ...
2
votes
1answer
94 views

Security implications of running SSRS and an OLTP database on the same server

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 ...
1
vote
0answers
25 views

Will SSRS User rights be over-ridden by Windows account?

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 ...
1
vote
0answers
138 views

Permissions for executing subscription in SSRS

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 ...
2
votes
1answer
114 views

Deploying SSRS reports on an “Air Gapped” report server without SSDT?

Whats the simplest way to deploy multiple reports (.rdl) along with the respective data sources to a machine which cannot be connected to from Visual Studio? I can only place files at a given ...
0
votes
0answers
87 views

Receiving Error: 18456, Severity: 14, State: 16 when trying to deploy SSRS Report

Our SSRS reports have stopped working. I tried re-deploying it but got a message stating that Error: 18456, Severity: 14, State: 16 an internal error occurred on the report server If checked ...
2
votes
1answer
859 views

SSRS: Line Chart, Grouping by Day

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 ...
2
votes
1answer
584 views

remove old SSRS Schedule jobs

We have a application that creates SSRS Schedules 2 times a year and it does create one for each of our customers. Each schedulation results in a SQL Agent job with a GUID as name and the description ...
3
votes
1answer
8k views

How to pass multi-valued characters in SSRS Report?

I have a SSRS report that has 3 data sets feeding off one data source. The main dataset is a stored procedure that is aggregating some data based on a set of parameters powered by the other two ...
1
vote
1answer
2k views

SSRS make a conditional format on the column

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, ...
1
vote
1answer
14 views

Run a report by specifying which server to execute the query on

I have a couple of stored procedures that I have written that gathers some information about all of the databases on the server it's stored on. I would like to create a report such that I can select ...
0
votes
1answer
46 views

Where are connections to databases made from when using SSRS?

If I have SSRS set up in the following format Server 1 : Running SQL Server, hosting the SSRS database Server 2 : Running SSRS, configured to store metadata on Server 1 database And SSRS reports ...
1
vote
1answer
141 views

Get the Messages stream in an SSRS RDL Report

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 ...
1
vote
1answer
102 views

SSRS executionlog having rowcount 0

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 ...
2
votes
1answer
115 views

Resource cost of a blocked 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. ...
0
votes
1answer
42 views

Find out CPU usage by reporting server

Is there a way to found out what is the CPU usage of the reporting server? Sometimes the CPU usage is rised up by 40% percent for several seconds. I think the reporting server is causing it but I am ...
0
votes
1answer
118 views

SSRS shared data sources and shared schedule

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 ...
0
votes
1answer
104 views

View the role assigned to each user (Report Server)

Is there anyway I could list down the roles assigned to each user on the different folders on ReportServer Database and in that SQL statement I should be able to declare something like @User_Name ...
2
votes
1answer
228 views

Prevent Subscription to report from running on a holiday

I have a SQL Server that I am using for building and distributing reports. I have built all the packages for importing data as needed as SSIS packages. These reports only need to be run after the ...
0
votes
0answers
281 views

Accessing SSRS receive System.UnauthorizedAccessException

Trying to log into localhost/reports I get the following error on the screen. An internal error occurred on the report server. See the error log for more details. (rsInternalError) Access is ...
0
votes
1answer
48 views

Tempdb tables, table in database or even cte for usp for reporting

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 ...
2
votes
1answer
3k views

SSRS (2008 R2 to 2014) Migration Issues Running Reports

This is my first ever StackExchange question, so sorry if I something is off...I searched and found a rather helpful article that got me this far, but nothing I found addressed what I am currently ...
0
votes
2answers
2k views

2 SSRS Instances, one in native mode and one in sharepoint integrated mode with PowerPivot and PowerView on same server

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 ...
1
vote
1answer
210 views

Cannot login to SQL Server from Visual Studio, same credentials work on SSRS page

I am running into a strange issue. I have a SQL Server login that I use for running reports on SSRS. When I go to the SSRS page I can modify the stored credentials to use that login: Now when I ...
0
votes
0answers
54 views

Crazy SSRS Issue

We are working a data center migration and are to the SSRS boxes and I am having trouble. SSRS is installed on a server alone pointing to the ReportServer and ReportServerTempDB on a different SQL ...
0
votes
1answer
218 views

SSRS Domain Migration

My company is currently going through a data center migration. We are now down to the SQL Servers and this includes SSRS. The bad thing that is going to hit us is the current SSRS server is being ...
1
vote
1answer
855 views

Unable to create a datasource. Datasource fails to 'test successfully' for SSRS

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 ...
4
votes
0answers
151 views

SSRS URL Changes while navigating

I am trying to track down the root cause of this issue I keep seeing. We have SSRS running with a custom URL like https://reporting.companyname.com/reports. When I connect to that address I can ...
0
votes
0answers
66 views

SQL-SRS create a report that is evaluated every day

Is there any functionality in the SQL Server Reporting Services to run a query every day and graph the result or do i need to use a seperate table and cronjob to run the query and save the result plus ...
1
vote
1answer
87 views

Windows Managed account to report subscription file share

Is it possible to used a Windows Managed account to access a file share in a Report subscription? When creating a Windows file share report subscription, on Step 4 - Create a data-driven ...
0
votes
3answers
243 views

Replacing the results of a row

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 ...
0
votes
1answer
143 views

Reporting Services DBs not appearing in Management Studio, but can be queried?

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 ...
0
votes
1answer
247 views

Formatting the output of SQL Server query

I am new to SQL Server and SSRS...and am trying to get a matrix report formatted correctly. My query is: select e.name, ea.element, case when ea.element = 'projected_status' then 'Projected ...
0
votes
2answers
24 views

SSRS Migration To a separate Network

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 ...
0
votes
0answers
207 views

Installer Error while Installing SQL Server Reporting Services

I have a Windows 2008 R2 Server 64bit, I have already installed SQL Server 2008 R2 SP2 64bit Enterprise Edition, Which is working fine, without any issues. Now when I am trying to install Reporting ...
1
vote
0answers
420 views

How to handle many columns / variable schema?

I apologize in advance in case this question has been asked already. I'm working on revamping a reporting application used within my company. The requirements are: Support addition of new fields ...
1
vote
0answers
1k views

SSRS 2012 - Dynamically change value of textbox in report header

I am in the process of converting some MS Access 2003 reports to SSRS 2012 (using VS 2010 to develop the reports). I have a report with a number of parameters. Some of the parameters are populated ...
1
vote
1answer
340 views

SSRS minus first two dates as the header

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 ...
2
votes
1answer
155 views

How to specify a display name in emails from SSRS subscriptions?

How can I specify a display name (e.g. "Reporting Server" <noreply@domain.com>) in the emails sent from SSRS subscriptions?
2
votes
1answer
221 views

Reporting services scheduled reports are clogging up sql job history log

This is a bit of a cross-disciplinary question - Hopefully I’ve posted in the right place. SQL server 2008 R2 Question: How can I limit the number of rows in [sysjobhistory] for specific jobs, ...
0
votes
1answer
198 views

Restrict users from modifying datasources in SSRS

We had a situation lately when a particular user of the SSRS reports modified the datasources defined on the reporting server. These users have access rights to create ad-hoc reports using ...
0
votes
1answer
26 views

SSRS 2012 and SharePoint 2010 Standard

Is it possible to use Report Builder Model, Report Builder Report, Report Data Sources with a Sharepoint Standard 2010 edition?
4
votes
2answers
911 views

SSRS - Set Page Break within table

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 ...
0
votes
0answers
199 views

Retrieve SPID For SSRS Request

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 ...
0
votes
1answer
56 views

Deploy SSRS 2012 report to a distant Sharepoint 2010 server

My installation : - SQL server 2008 r2 + Sharepoint server (main farm) = VM1 - SQL server 2012 + SSRS 2012 (not native mode) = VM2 I would like, if possible , make my SSRS configuration manager ...
0
votes
1answer
587 views

Configuring Reporting Services - ExecutionLogDaysKept

Is it possible to set Reporting Services options when Reporting Services is not installed on a server? Is this how a SQL Server instance used by SharePoint works? I'm a new DBA (very junior...), and ...
1
vote
2answers
269 views

Reporting Services buttons show up one under the other instead of side-by-side

This seems a browser problem to me. When I render a reporting services report in IE11, the "Export", "Refresh" and "Export to Data Feed" buttons show up under each other taking up a lot of extra ...
1
vote
0answers
475 views

SQL Server Reporting Services (MSSQLSERVER) Process using high memory

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 ...