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
37 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
35 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
183 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 ...
0
votes
1answer
174 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. ...
0
votes
0answers
51 views

Copy SSRS Report Snapshot History to another folder in Report Manager

How can I make a copy of SSRS Report Snapshot History to another folder in Report Manager? I have a report that has history snapshots. I want a copy of the report snapshot history in another folder ...
-1
votes
1answer
91 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
1answer
30 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
1answer
16 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 ...
0
votes
2answers
93 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 ...
0
votes
1answer
53 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 ...
1
vote
0answers
75 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
44 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
1answer
72 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
516 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 ...
0
votes
0answers
23 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 ...
2
votes
1answer
79 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
50 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
317 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
185 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 ...
1
vote
1answer
203 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 ...
0
votes
1answer
36 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
28 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 ...
2
votes
1answer
147 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 ...
2
votes
1answer
671 views

Does installing SQL Server Database Engine and Reporting Services in Azure require two virtual machines?

We are evaluating moving a large-ish web application comprising ASP.NET, Classic ASP and SQL Server Reporting Services into Azure, and we want to know the "best practice" for installing the Database ...
0
votes
1answer
72 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 ...
0
votes
1answer
550 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 ...
2
votes
1answer
68 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 ...
2
votes
1answer
167 views

Does reporting webservice url contain the function that helps to export the report to the client version?

The reporting webservice url contains the webservice url that contains all the information of the Reports which are created in SSRS. As the report has been created on reporting service, i want to ...
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?
3
votes
1answer
487 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
84 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
57 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
29 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
502 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
0answers
84 views

Drill down report links fall outside cell [closed]

Apologies for the vague title, not sure how to summarise the problem... I'm creating a dashboard report showing server state for a group of SQL servers, the problem is that the links for the drill ...
0
votes
1answer
62 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
1answer
27 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. ...
0
votes
0answers
178 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 ...
3
votes
1answer
497 views

Exporting SSRS report to Excel

We have a number of SSRS reports and want to show the report in Excel format to the users. SSRS has provided an option to save the report in Excel format (.xls), however when the report is saved as ...
2
votes
2answers
3k views

Use domain username on SQL server reporting services installed in a server which is part of a Workgroup

I have installed SQL Server 2012 on Windows Server 2008. This system is configured to be part of a Workgroup and all the users in our organisation are part of a domain. I am trying to use the ...
1
vote
2answers
810 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?
0
votes
0answers
264 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 ...
2
votes
1answer
84 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 ...
5
votes
1answer
3k views

SSRS Merge Data Across 2 Group Values

I have created a report for SSRS 2008 which produces the results below. What I am looking to achieve is for those results in pink, AD, to be under both AM and PM with the text centered i.e. merged ...
0
votes
2answers
162 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 ...
2
votes
2answers
104 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 ...
1
vote
0answers
55 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
125 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?
0
votes
0answers
74 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
151 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 ...