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

learn more… | top users | synonyms (1)

1
vote
1answer
27 views

SSRS in database server

Is it advised to use SSRS in the database server itself? Will it hamper the performance of the server itself. (in SQL SERVER 2005) What are the merits and demrits of the same?
2
votes
1answer
1k views

Running SSRS and SSAS from different server than the primary database instance(SQL Server Engine)

Right now both SSRS, SSAS and SQL Server Engine are on the same server. We are using 2008R2 Enterprise. We are thinking to upgrade to SQL Server 2012 or 2014. and We want put on separate serve the ...
3
votes
2answers
107 views

How to create a custom map report

not sure if this is the right forum. But just wondering is there a way one can make a map report out of an image or a map made on excel. I have the data and I've looked around and found that its ...
2
votes
1answer
76 views

How do I create/publish a report in SQL Server 2014? [closed]

I installed SQL Server 2014 with Reporting Services but I don't how understand how to create and publish a report so that users can run it on the report server on IIS. These are the programs that ...
1
vote
0answers
34 views

Report Builder Data Sources Do Not Change in Catalog Table

I am trying to extract the connection string for MS SSRS reports from the Report Server Catalog table. This is straightforward enough but if I change the Data Source in Report Builder, the change is ...
5
votes
1answer
1k views

Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version

Tonight we upgraded our SQL Server 2012 (SP2+CU6) cluster with SQL Server 2014 Service Pack 1. On that cluster nodes, we have Native mode Reporting Services scale-out configuration. After in-place ...
1
vote
1answer
190 views

Loading subscription slow in SSRS

I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it ...
0
votes
0answers
387 views

Data Sources are not visible through browser or through SSMS when connect to reporting server but are visible in SSMS

As above I have a reporting server and currently when I browse to bizvm01/reports Data Sources are not visible through the browser. Reports are visible and they work. When I connect to bizvm01 using ...
0
votes
1answer
779 views

SSRS email Subscription Not Working but local smtp is working

SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION Operating System- Window Server 2008 R2 I've Created Local Smtp to use gmail id for Subscription of SSRS Report by Email as we don't have an ...
0
votes
1answer
32 views

Can SSRS XML data sources contain spatial data?

I've been given the task of producing a report which will extract data from a web service. The web service provides data from a list of sites including aggregates. Lets say total sales by month. ...
1
vote
2answers
2k views

Naming The SSRS Report Name based on the Parameters Passed

I want to save my SSRS Report Based on the Parameters Passed. i.e. Am passing P1 And P2 as parameters so I want my SSRS Report name as P1_P2_ReportName.Xtension. Any suggestions?
2
votes
1answer
110 views

Number of SQL Server languages

As per MSDN There are currently ten SQL Server languages. The report server language for a given report server instance will always be one of the ten available languages. Support for all ten ...
0
votes
1answer
103 views

Overload resolution failed

I am using reporting services to generate a list of families in my database. After the first family member in the list, I want to put the family's address: family, First 123 la la lane Somewhere, Ca ...
0
votes
2answers
249 views

Unable to browse to folder on SSRS 2012 through report url

I have installed SSRS 2012 in native mode on windows server 2012 r2 and deployed reports to the server successfully. I am having difficult browsing to any report folder through the report URL. I can ...
0
votes
1answer
249 views

How does one create a Matrix Report to convert sql columns as rows? [duplicate]

I'm trying to create a product listing. Naturally Sql prints the data vertically forming rows after rows like this: Rowa. product_img#1|Product_name|Product_price|Product_short_description Rowb. ...
4
votes
2answers
2k views

SSRS Blocking Processes

We have a busy SSRS Reporting server (SQL Server 2008 R2) on which we see frequent blocking between the below processes: [dbo].[CheckSessionLock] [dbo].[WriteLockSession] We are aware that some ...
0
votes
0answers
94 views

What is restarting SSRS service once a day?

My 2008 R2 SSRS service (10.50.1600.1) is consistently restarting every morning at 2:30 AM and I can't figure out why. The RecycleTime setting in rsreportserver.config is unchanged from the 720 ...
0
votes
2answers
297 views

need information on a deleted SSRS report

In SSRS, once a report is deleted, the ItemPath no longer appears in the ExecutionLog because the Catalog no longer has the report information. I can track down the ReportID, but I can't find ...
2
votes
2answers
122 views

SQL Server total memory less than target memory, lot of extra memory unallocated

The situation is the following: We have a SQL2008r2 server (64bit on 64bit Windows) with SSRS installed on it. The Max Memory is set to 6GB, the server has 12GB total memory. The target server ...
0
votes
2answers
188 views

Sudden Slow Reports [closed]

we have reports on our report server that are running slow all of a sudden. They were working fine and then all of a sudden over the weekend they started to process incredibly slow. It appears that ...
1
vote
0answers
75 views

SSRS Datasource Escape Password

I am using a dynamic datasource inside a SSRS report to display detailed metrics about an instance. This dynamic datasource uses a SQL Login to connect to each instance listed by this report. The ...
0
votes
1answer
597 views

Dynamically change a db in transact sql

I am trying to run a script against a database that is dropped from a third party daily so the name of the database changes daily. I can get the name of the new database using the sys.databases ...
0
votes
1answer
50 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
327 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
64 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
104 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
26 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
154 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
122 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
92 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
1k 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
654 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
11k 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
150 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
122 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
129 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
45 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
128 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
137 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
248 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
321 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
50 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
235 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
57 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
257 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 ...