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
0answers
38 views

SSRS with database on different server

On server lab01 was installed SQL Server and SSRS. On second server lab02 is installed only SSRS. When I configured Reporting Services Configuration Manager I create new database and given name ...
2
votes
1answer
204 views

Migrating reports from SSRS 2005 to SSRS 2014 and SSAS 2005 cube to SSAS 2014?

As SQL Server 2005 end of life is getting closer I'm facing inevitable job of migrating databases, SSIS packages, SSRS reports and SSAS cubes. Since newest version of SQL Server is SQL Server 2014 we ...
1
vote
1answer
57 views

Report Builder CTP 2.3 Installation DLL Error

I was attempting to install Report Builder CTP 2.3 and cannot get it to install on any of three tested systems. First system was Windows Server 2012 R2 Datacenter - MS Azure SQL 2016 preview image ...
2
votes
1answer
153 views

Reporting Services will not connect to SQL Server

I have set up a new SQL Server 2014 default instance. In SQL Server 2014 Configuration manager I see my 32 and 64 bit SQL Native Client 11.0 configurations and all protocols, pipes, tcp/ip,shared ...
2
votes
1answer
114 views

How to Resolve a Case of "The tablix 'xyz' contains an invalid DataSetName in SSRS?

I am getting the following stubborn error in an SSRS 2012 report: Deploying report 'abc'. Warning : The tablix 'xyz' contains an invalid DataSetName (Expected: ‘DataSet1’; Actual: ‘DataSet2’). The ...
0
votes
0answers
20 views

Trying to correct query for SSRS report

I have the following query below which produces this report for me: I am trying to bring in cc.valid_to so that I can change the expressions for a conditional formatting to reference against that but ...
4
votes
1answer
237 views

Conditional formatting based on number of days in SSRS against a cell value in reference to another field

I have a SSRS report where I have cell displaying a field called activity_date. I would like this to be colour coded based on a number of days against another dataset field called valid_to where if it ...
2
votes
1answer
191 views

Use Group Managed Service Account for SSRS

We have a production environment running SQL Reporting Services 2014. The service is running as a group managed service account domain\SSRSProdSvc$ We are now trying to change our test environment to ...
1
vote
0answers
45 views

Bulk changing SSRS schedules

I have around 100 SQL Server Reporting Services subscriptions that I need to change the schedule on. The schedules are all standalone, not shared. Is there a way that I can easily bulk change the ...
1
vote
0answers
39 views

Date picker is dynamic in SSDT but not in SSRS

Running SQL Server 2012 SP1 and SSDT from same distribution. (VS2010) When I display a report in SSDT the date selector on a date parameter is dynamic or responsive. When you click on the date ...
0
votes
1answer
152 views

SSRS - Data missing when running report from server

I have an extremely strange issue with an SSRS report i'm working on. We use SQL Server 2012 availability groups and as number of groups and the nodes they run on has swelled, confusion on the part of ...
-1
votes
1answer
50 views

encryption key for SQL Server 2012 Reporting services [closed]

Is it required to have an encryption key for SQL Server 2012 Reporting services?
0
votes
1answer
40 views

Order column data in a tablix in SSRS

I have created a report with following data Age_Category Count 31-40 10 41-50 20 51-60 30 61 and Over 40 Under 30 50 Now I want to order "Age_Category" column ...
1
vote
1answer
39 views

Color formatting Pie Charts in SSRS 2008 R2

I have a pie chart with Categories(Male, Female) with Percentages. If I want to color format Male and Female portion of the chart, what is the approach?
0
votes
0answers
418 views

Reporting Services Dataset - Login failed for user - SQL User

I have two SQL Server 2012 Development Edition machines setup for testing purposes. One is a reportserver and one is a database server. I've configured the report server such that it's database is on ...
1
vote
1answer
49 views

SSRS - Graph Line Value for Parameter

For the purpose of reporting database growth, I am created everything except one and most important thing. In SSDT I'm created report, which contains graph line which need to be show in depend of ...
0
votes
2answers
124 views

What is the best tool for reporting? [closed]

I usually work with SQL Server SSAS, I have almost finished my cube and MDX queries, but I don't know anything about the next step. I take a look at SSRS but I didn't like it too much. I'm trying to ...
-1
votes
1answer
189 views

Adding a Quarter column every three months in a report in SSRS

This is driving me a bit bonkers. It seems like it should be easy but SSRS has me stumped. I want to create a report of our customers displaying the monthly sales totals and display the Quarter ...
1
vote
0answers
65 views

SSRS Dynamic Columns with Sub-report

I have a SSRS report with a set of dynamic columns presenting summary data. I want to run a sub-report under the grouped columns but the only way I can do this is to put the sub-report outside of the ...
2
votes
0answers
189 views

SQL Reporting Services (SSRS) - Blocked process on ReportServer, SP CheckSessionLock [duplicate]

We frequently see blocking on our SSRS box which houses both front-end Report Manager ReportingService and the SQL database engine with ReportServer & ReportServerTempDB Catalog databases ...
0
votes
1answer
82 views

SSRS Matrix Report - Count for NULL data

I have a SSRS Matrix Report for data quality in our warehouse. We use this report to display invalid values in specific fields during specific time period. For example, Missing/Invalid Postcode, My ...
0
votes
0answers
94 views

SSRS Migration 2008 to 2014 - InternalCatalogException secDesc != null

We're migrating side by side from SSRS 2008 Web to SSRS 2014 Enterprise. I followed the steps: backup encryption key backup databases (ReportServer and ReportServerTempDB) restored databases on 2014 ...
1
vote
0answers
177 views

Problem connecting to SSRS reporting services

When I try to connect to my reporting services server (SQL Server 2005) from my local machine, SQL Server 2014 I get the error message below Invalid Namespace (System.Management) But when I ...
0
votes
0answers
31 views

Is there a way to set the data source in Report Manager for whole folder rather than each report?

I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports ...
0
votes
1answer
21 views

What does the presence of rsAccessDenied mean?

I'm troubleshooting a SSRS security issue where one user is being denied access, while another user with apparently identical settings is working as expected. I'm seeing "The permissions granted to ...
2
votes
1answer
120 views

Calculate Difference in Overlapping Time in PostgreSQL / SSRS

I'm using PostgreSQL 9.2 and SSRS 3.0. I'm trying to calculate the difference in non-overlapping time entries in a timesheet. My data looks like this: I would like this to return: I can get ...
0
votes
1answer
92 views

See SQL Server Reporting Services Reports without logging in?

I have installed SQL Server 2015 with SSRS and I have some reports I need to run, but in order to access http://reportsserver/Reports I need to start Internet Explorer in administrator mode. This is ...
9
votes
4answers
486 views

Is it poor practice to aggregate data from different tables into one?

Background I write a lot of large reports for and generally maintain a large health records DB (write SPs, functions, jobs, etc.). The original schema, and software that uses it, is from a different ...
2
votes
1answer
85 views

SSRS Report drop down parameters. Use SP or embeded SQL query for datasource?

When I create SSRS reports I create stored procedures to bring data into my report. When I create the report parameters I just embed SQL code directly in to the parameter/SSRS report. Should I also ...
0
votes
1answer
63 views

What are the user privileges required to for an ssrs report owner to 'send email'

Yes, this question is a duplicate to: SSRS - rsAccessDenied error but that question is 2 years old and unanswered...so I thought I might try again. Our DBA has recently departed leaving ...
1
vote
1answer
35 views

Is it possible to uninstall SSRS?

I installed SQL Server with Reporting Services package by mistake and I will never have a requirement to use the Reporting Services part. Is it possible to uninstall Reporting Services (and anything ...
1
vote
1answer
343 views

Report Server ( [162] Internal request to deactivate schedule ) error ( SQL Server 2008 R2 )

This is the error: [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule N The Image: Has anyone seen this? I have no idea what is ...
1
vote
1answer
286 views

How to migrate SSAS and SSRS from SQL Server 2008R2 to SQL Server 2012?

We are upgrading our SQL Server 2008R2 to 2012 and separate the SQL Server engine from SSAS and SSRS. We want put on Server 1 the engine and on Server 2 SSAS and SSRS. I did the side-by-side ...
1
vote
1answer
212 views

How to get past the 5000 row limit in a SQL Server Reporting Services tablix report?

I have a report whose data returned exceeds 5000 rows in a tablix in SSRS 2012. When I Google this, I get all kinds of info concerning settings in Sharepoint, but this instance is running in Native ...
0
votes
1answer
110 views

SSRS and Informix connection

I have the IBM drivers installed, created a data source that successfully tests from SSRS front end. Create a report from my machine which also has the drivers installed and the ODBC testing ...
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
886 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
99 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
67 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
32 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 ...
0
votes
1answer
157 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
315 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
718 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
30 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
1k 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
104 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
85 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
219 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
227 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. ...