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 2016 Appears In Directory Browser Mode After Deploying Report From VS 2019

I installed Reporting Services on SQL Server 2016 I went through the ssrs configuration wizard, and everything was working fine I was able to go to localhost/ReportingServer, and saw the SSRS reporting manager page I went into VS 2019 15.4, created…
Rick Hodder
  • 2,189
  • 3
  • 26
  • 54
1
vote
1 answer

SSRS Show Toolbar on drill down sub report

I have a dashboard SSRS report in embedded in another web app. In this report there are drill down reports(too many). By default I set rc:stylesheet=hideToolbar for this main report. So the toolbar is hidden. Now we want to show the Toolbar on…
Sam Salim
  • 2,145
  • 22
  • 18
1
vote
0 answers

SSRS sub-report PPT export

I have created a SSRS report with multiple nested sub reports as it iterates through data in each sub-report. Upon exporting to PowerPoint the only editable data is the from the first or ‘main’ report and all of the information from the sub-reports…
TK303
  • 11
  • 2
1
vote
2 answers

SSRS Report set value of parameter based on other parameter

I want to set the default value of 1 of my parameter using the other selected parameters dataset value. for example, the content of the dataset is something like [{'name': alex, 'id': 1}, {'name': bloom, 'id': 2}, {'name': kelly, 'id': 3}, {'name':…
Lynn
  • 182
  • 2
  • 10
1
vote
1 answer

SSRS2016 Convert seconds to hh:mm:ss format

I have a table with a column, Duration that has value in seconds. In Visual Studio / SSRS 2016 I want to display it in HH:MM:SS format. I have tried to use the following expressions =Format(DateAdd("s", Fields!Duration.Value, "00:00:00"),…
Olivia
  • 45
  • 6
1
vote
1 answer

Changing the SSRS date picker format to DD/MM/YYYY

I have seen this issue posted a few times but there does not appear to be a solution for what I am seeing. I have a paginated SSRS report that requires a date input from the drop-down calendar. Upon entering, say, January 21st 2020, the UI is then…
Psymon
  • 13
  • 1
  • 4
1
vote
1 answer

SSRS Configuration rsreportserver.config

I was facing a problem while accessing the first SSRS report of the day taking more time. But I got to know about , I found below references to understand the scenario. SSRS Slow Startup Speed up SSRS on the first Run Still, a few…
Irfan
  • 665
  • 6
  • 29
1
vote
2 answers

SSRS Delivery Extension Sample or Tutorial or Example

For a SQL Server developer wanting to create and implement a SSRS Delivery Extension needs a good step by step tutorial or example to follow. However, I can only find one and as far as I tell it's either incomplete or not easy for a beginner to…
Geezer
  • 513
  • 5
  • 17
1
vote
1 answer

SSRS - Spacing between lines in single TextBox

I have a flat-file to be load in SSRS report. Which already contains New Line and required spacing. Like the below image: Want to display same layout and newlines(CRLF) into SSRS. Which works fine If I use ≪Place Holder Property → Markup type =…
Irfan
  • 665
  • 6
  • 29
1
vote
1 answer

Do all Users in SSRS need to be a System User in Site Settings?

I need to set up a new SSRS site but I'm not sure if adding Users in the Site Settings as System User is required. I've added the Users to Roles on each folder and the Home folder. Is that enough? The last few SSRS sites I've used only had…
WilliamB2
  • 45
  • 1
  • 8
1
vote
1 answer

SSRS ReportViewer in MVC not passing parameters to DataSource

I have a remote SSRS 2016 server with some reports uploaded. These reports are to be shared by the Dev, QA and Production environments. The way I do this is by having a DataSource with a dynamic connection string using an expression: ="Data…
callisto
  • 4,921
  • 11
  • 51
  • 92
1
vote
1 answer

Is there a way to generate PDF in landscape orientation while accesing reports through URL?

I am accessing report using URL like this < reportServerAddress >/ReportServer?%2f< reportName >&< parameter >=< value >&rs:Command=Render&rc:Parameters=false&rc:Toolbar=false&rs:Format=pdf While in standard HTML form report is displayed…
randomUsername
  • 11
  • 4
1
vote
1 answer

SSRS Rendering Fails in Esoteric Context

I am using ReportingService2005 in a C#.net application that reaches out to an SSRS server to generate multiple reports as PDFs and combine them into a single PDF. It had worked well for a rough in-house program, but I recently deployed updated…
Kodithic
  • 160
  • 12
1
vote
2 answers

SSRS 2016 Toolbar Back Button

I am trying to figure out in SSRS 2016 why the back button goes missing and how to get it back. I am adding the report into an iFrame of another application - I do not have access to that application's code, I just get to put in a URL. If I put in…
Jesse
  • 865
  • 10
  • 18
1
vote
1 answer

Is there any problem if i have upgrade SSRS from 2014 to 2016 and the databases are still on SQL Server 2014?

Is there any problem if I have upgrade SSRS (hosted on server1) from 2014 to 2016 and its databases (which are on another server server2) are still on SQL Server 2014?
Sanky
  • 41
  • 8
1 2 3
…
30 31