Stack Overflow
Stack Overflow

Questions tagged [ssrs-2016]

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.

463 questions
1
vote
1 answer

SSRS Email Symbol in Footer of report

Could be a rather trivial question, but how does one put an E-mail Symbol next to the email address in the footer of an SSRS 2016 Report please? I've tried HTML Code like ✉ (✉) but it doesn't work ( in reporting services) .. it just shows it as…
Harry
  • 2,636
  • 1
  • 17
  • 29
1
vote
0 answers

SSRS data services Sharepoint 2013 xml

in SSRS 2016 I write the following XML data Source: https:///_vti_bin/usergroup.asmx and afterwards the following DataSet: http://schemas.microsoft.com/sharepoint/soap/directory/GetGroupCollectionFromUser …
Piero Negri
  • 11
  • 2
1
vote
0 answers

Mobile reports custom url in SSRS

I am trying to pass a drillthrough custom url in SSRS Mobile Reports using values from my database, the problem is that my value contains special characters like "/" which look to be converting to %2F causing the hyperlink to break. Is there any way…
GVal
  • 87
  • 2
  • 7
1
vote
0 answers

SSRS url parameter

In SSRS I want to set parameter value of First Name through url, Default value is All. So If I want to set First Name : Joanna, My url will be…
Manan Gogri
  • 11
  • 1
1
vote
1 answer

ReportServer from 2008R2/2012/2014 to ReportServer 2016

Recently I have been experiencing a lot of issues with taking ReportServer database from older instances of SQL Server to SQL Server 2016. I simply take a backup of the database and restore it on an sql server 2016, restart the service and then try…
Laurence
  • 11
  • 2
1
vote
2 answers

v14.0 Web Report Viewer Control not displaying body of report

I am hoping someone has an idea about what I am experiencing. I've worked with various versions of the Report Viewer control (both WinForms and Web) over the years and have just started trying to use the latest HTML5 based version in an ASP .NET…
ChromaticRanger
  • 140
  • 3
  • 16
1
vote
1 answer

Can SQL Server Reporting Services print multiple tables and charts on one page?

I'm new to SSRS and I'm not sure if what I want to do is possible with SSRS. I have a list of 100+ schools in my data set. I'd like to print one page per school, and for it to look like the picture below. Each table and chart are using a unique…
JM1
  • 1,595
  • 5
  • 19
  • 41
1
vote
2 answers

SSRS Running Datasets Multiple Times When I Change Parameter Values

I'm seeing some weird behavior I can't quite figure out. I have a report with a bunch of parameters, none of them are cascading. A handful of the parameters are set to allow multi-select and the available/default values are retrieved from data…
User181
  • 111
  • 8
1
vote
1 answer

SSRS 2016 Report Emails across time zones

I'm using SSRS 2016 and have a number of users that will need to receive an emailed report by 11am respective to the users local time. What's the best practice for doing this? My initial thought was to just create different Active Directory…
stecyk
  • 59
  • 1
  • 4
1
vote
1 answer

SSIS - SSRS Rendering Clash Between EXCEL and EXCELOPENXML

I am attempting to render an SSRS Dashboard (ssrs 2016) to Excel (2010). My Dashboard has 4 parameters as StartDate, EndDate, Company, NumberOfJobs. StartDate, Company and NumberOfJobs will all render perfectly when using render to xlsx…
Stevie Gray
  • 75
  • 7
1
vote
0 answers

Siteminder SSO with SSRS 2016

We are doing some analysis for one of our clients who would like to use Siteminder sso with SSRS 2016, we are not finding the ReportManager folder in SQL Reporting service installed location, Also if there is any way to implement the custom security…
Vinay Patil
  • 21
  • 3
1
vote
1 answer

Check if another Report exists before launching it

The Map polygon Action can launch another Report. Is there a way to check that a particular report actually exists before blindly trying to launch it? This would allow re-direction to an 'Oops!' dummy report instead of it erroring.
radders
  • 923
  • 8
  • 29
1
vote
1 answer

How to setup Email subscription in SQL Server 2016 Reporting Services

Just wondering how to set up a SQL Server Reporting Services subscription to email the report as an attachment. When setting up a usual subscription for a report, it seems to only provide a Windows File Share option. Is there any clean…
Stefan Zvonar
  • 3,959
  • 3
  • 24
  • 30
1
vote
1 answer

Can SSRS 2014 and SSRS 2016 operate concurrently in the Visual Studio development environment

I have developed and trialled a number of reports on my laptop using SQL Server 2014 and SSRS 2014 running in a VS 2013 Community Edition IDE. Can I install SQL Server 2016 and the 2016 SSDTs and run SSRS 2016 without removing SSRS 2014?
user7327707
  • 13
  • 4
1
vote
2 answers

Using Row Group Expressions In SSRS Causing Preview To Run Very Slow

I have a stepped report that has 5 row groups. Each one uses an expression as the value to group on. The user selects a value for up to 5 different parameters and based on those parameters is how the report is grouped. With certain combinations of…
User181
  • 111
  • 8
1 2 3
…
30 31