Stack Overflow
Stack Overflow

Questions tagged [ssrs-2017]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2017 in October 2017.

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2017 in October 2017. More info in the tag.

169 questions
11
votes
3 answers

How to export SSRS 2017 report using REST API

I've setup SSRS 2017.I need to export an SSRS report using their new REST API, I've been looking through the API specification here but I can't find a method in swagger specification to render/export that report using an HTTP client. This Question…
Aarif
  • 1,595
  • 3
  • 17
  • 29
10
votes
2 answers

Oracle Date format exception in SQL Server Reporting Services

Earlier my client was using SSRS 2008R2 with Oracle as transaction database. Recently they have upgraded to SSRS 2017 and now many reports are throwing following error: ERROR: Throwing …
Aftab Ansari
  • 926
  • 9
  • 17
6
votes
0 answers

SSRS Report Consuming RESTful Web Service

I am trying to consume an XML via a REST web service using SSRS. I am intending to create the XML using LINQ and then dump it at the web service location. The web service is held in Azure under https:// ...…
Michael
  • 67
  • 1
  • 5
6
votes
2 answers

Deploy SSRS reports on a customer's machine with PowerShell

We are developing some reports locally. These reports are to be installed on a customer's machine. But we cannot reach this machine online. What I've managed so far: A folder containing: all report objects (data source, data sets and reports) a…
Shnugo
  • 66,100
  • 9
  • 53
  • 114
4
votes
1 answer

How to grant a user SSRS browser permissions on a folder without giving them access to the root

When users browse to http://ssrs_server/reports, they get access denied unless they have Browser permission on the root folder. If they have Browser on folder Dept_1_Reports, they can browse successfully to…
nonpoliticaltag
  • 165
  • 1
  • 2
  • 16
3
votes
2 answers

ssrs error converting data type nvarchar to int

I passed this stored procedure into ssrs to generate a report but kept getting error converting data type nvarchar to int, while i don't even have any parameter that's nvarchar type. Alter proc dbo.spPullOrderRosa1 @Subentity int, @BegShipDate…
Yiting Ma
  • 33
  • 1
  • 3
3
votes
5 answers

SSRS Web Service URL Provides an Error (500)

When I try to access the SSRS Web Service URL (e.g http://SERVERNAME:1234/ReportServer/), it provides me with an Error 500. However, the Web Portal URL (http://SERVERNAME:1234/Reports/) works just fine. It even provides me with the UI for the SQL…
TheDoomDestroyer
  • 2,434
  • 4
  • 24
  • 45
2
votes
1 answer

SSRS - fonts are not emedded into pdf files

I am using SSRS 2017 to generate reports, I've installed a new font to use with the reports but the font is getting embedded in all files types except the pdf files. Here are the font details: When I try to download the report from the preview…
Merna Mustafa
  • 1,235
  • 2
  • 10
  • 22
2
votes
2 answers

Unable configure SQL Server reporting service 2017

I'm getting a typical error, never faced before. I'm unable to install, un-install or repair Setting string variable 'InstallFolder' to value 'C:\Program Files\Microsoft SQL Server Reporting Services' Setting string variable…
AskMe
  • 2,495
  • 8
  • 49
  • 102
2
votes
2 answers

Is report server 2019 not available

I tried to find SSRS Reporting Services 2019. Has MS stopped this? If not, could anyone please provide the link to download this? Note: somehow I'm unable to install Reporting Services 2017, showing error during installation. That's why I'm trying…
AskMe
  • 2,495
  • 8
  • 49
  • 102
2
votes
1 answer

SSRS - Managing Folder, GET AllowedActions Method Returns 404

I'm using SQL Server 2017 Reporting Service and I see that something is wrong with my permissions. I'm in the Administrator group in the SSRS machine, I can manage most of the folders in the SSRS browser web app but I can't manage some of…
rcanpahali
  • 2,565
  • 2
  • 21
  • 37
2
votes
0 answers

SSRS Return tablix cell value using a relative cell reference

I can return the value in a tablix cell with me.value. My objective is to simply use a background color to show that a value is different, compared to the value above. The tablix is sorted. I wish to return the value of the cell 'above'. Is this…
DingoCC
  • 159
  • 1
  • 2
  • 12
2
votes
2 answers

Passing parameter to SSRS url issue when parameter value have '&'

I want to pass report parameters within ssrs url, but one of the values of a parameter contains &, so url won't…
NiveaGM
  • 249
  • 2
  • 11
2
votes
1 answer

SSRS throws "Invalid or Expired Session" for one specific user on one specific report

I have a report named "comments". If I rename this report, the user in question can access it. If I load the report from another user, that user can access it. When the specific combination of the one single user and the one report interact, I get…
Daniel Paczuski Bak
  • 3,720
  • 8
  • 32
  • 78
2
votes
0 answers

What will cause all WarehouseControlWebService methods to return "Value cannot be null. Parameter name: securityNamespace"

BLUF: Pointing a browser at this UI on the SSRS: /TeamFoundation/Administration/v3.0/WarehouseControlService.asmx And selecting any method and clicking 'Invoke' causes the web UI to throw a 500 and the response body is: Value cannot be…
KJ Dietrich
  • 21
  • 4
1
2 3
…
11 12