SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2016.
Questions tagged [ssrs-2016]
463 questions
0
votes
2 answers
SSRS 2016 report manager
I have installed SSRS 2016 developer locally on my machine.
I can't get the report manager page to load and in the log files I get this error:
Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:…
paulmezza
- 101
- 2
- 15
0
votes
1 answer
SSRS Goup header evaluates expression only once
I have a SSRS 2016 report which has two group headers. I want one group header to show up on the first page of each group item and then the other header to be visible for the following pages.
I have tried many solutions for instance setting a…
Jeremy Vetter
- 5
- 2
0
votes
0 answers
Rectangle Creates Extra td tr Tags in SSRS Report
I'm using SSRS Report. While using Rectangle in SSRS Report, on web page it creates extra td/tr tags like below image.
Report
How can I remove such td/tr tags or is there any way to eliminate?
Actual Image of Design Issue:
Pedram
- 6,256
- 10
- 65
- 87
0
votes
2 answers
SSRS 2016 RDL view in HTML5?
I am aware that SSRS 2016 provides RDL to be viewed in HTML5 as "Preview" version in admin portal, but is there a way to view the RDL in my MVC .HTML view without using asp.net report viewer controller?
Navin
- 684
- 1
- 11
- 24
0
votes
0 answers
SSRS: Time Out for Timeouts! Stop the Drops! A Cause for the Causes, Just Because
I realize that SQL Server 2016 RC1 and all of its RC1-refreshed accessories may be half-baked.
That said, let me ask this: In SSRS, what may be causing flaky connectivity and timeouts?
No default-installation timeout settings (wherever I found…
JOINtheFun
- 27
- 1
- 1
- 8
-1
votes
1 answer
string format with JOIN inside SSRS expression
I am using an SSRS expression to format the result of a string like this based on a condition
= IIf(my_condition,"All active items",JOIN (Parameters!SelectedBooks.label,"
")) This will make the resultant string comes on next lines…
")) This will make the resultant string comes on next lines…
Sebastian
- 4,625
- 17
- 76
- 145
-1
votes
1 answer
SSRS 2016 user needs Publisher role to display charts of type "comparison time chart"
I'm using SQL Server 2016 Enterprise with SSRS in Native Mode.
I am using the Mobile Report Publisher to generate mobile Reports. My data source is a SSAS Cube. Today I ran in some issues regarding permissions. The user who executes the report…
Mario
- 1
- 2
-1
votes
1 answer
How to add a sunburst chart to a RDLC
I'm tasked with creating a report in a RLDC that contains a Sunburst chart which is one of the new charts that comes with SQL 2016.
However in Visual Studio 2015 the option to add that type of chart only appears if you add it in a RDL file that is…
Dijkgraaf
- 11,049
- 17
- 42
- 54
-2
votes
1 answer
SSRS SQL Server 2016 Standard - Error when trying to customize security for a folder
We are constantly getting errors when trying to customize security on folders in SSRS 2016 standard edition.
To start, because we're using SQL Server 2016 standard, the SSRS site is currently on the same server as its associated database.
When we…
LordAlfredHayes
- 1
- 2
-2
votes
1 answer
How to display Page Number and Total Pages in SSRS 2016 with specific format like (page # 2 / 5 pages)
How to display Page Number and Total Pages in SSRS 2016 with specific format like (page # 2 / 5 pages)?
Right Answer (Worked with me)
="page # "+Globals!PageNumber.ToString() +" / " + Globals!TotalPages.ToString()+ " pages"
Mohammed Osman
- 3,688
- 2
- 27
- 25
-2
votes
1 answer
Combine multiple SSRS Report and publish that to SSRS native web portal
How can i combine couple of rdl reports and display that to SSRS native web portal. I already created that report and deployed to the server (SSRS Native portal) using Sql Server data tool 2015. But my client wants to view all reports in the same…
Rashed Hossen
- 81
- 1
- 9
-2
votes
1 answer
Is SQL Server 2016 Report Builder compatible with SQL Servers 2008 and 2012?
I'm wondering if I can use the 2016 version of Report Builder with 2008 and 2012 SQL Servers or, if I have to download the three corresponding Report Builders separately. Thanks!
Joe
- 69
- 1
- 11
-3
votes
2 answers
What is the best method for being able to design a report using SQL 2016?
When I am trying to edit a report by clicking on the design option, an error message is displayed as:
The report builder is not available. Please check the report builder URL in report setup.
So is there anything new with reports in SQL 2016 or…
