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

OLE DB connection in SSRS doesn't like when parameters are repeated

I'm changing an Oracle based SSRS report and I'm having all sorts of issues with parameters. The connection to Oracle is OLE DB. My code is not doing anything complicated. I've only added in a new parameter. When I only have one instance of said…
jdids
  • 561
  • 1
  • 7
  • 22
1
vote
1 answer

How can I write a WHERE clause to cater for optional paramerers on an SSRS report?

I am trying to get a basic SSRS report to be filterable by any optional parameters. The 2 parameters to filter should be either between 2 dates or by a SalesID. I can get each parameter to filter individually but when I add them together in a…
Jimbo
  • 67
  • 9
1
vote
1 answer

SSRS - Set default parameters and datasources based on folder it is deployed to

We're running into a dilemma where we're maintaining the same reports with a simple parameter and datasource change I'm wondering if there is a way to set a default parameter/datasource based on the folder the report is deployed to. For example, if…
jdids
  • 561
  • 1
  • 7
  • 22
1
vote
1 answer

SQL query: using data in a column as column names in another table?

I am struggling to get data from within a table that looks like this: to display horizontally, grouped by GroupID, then the start/process/stop times (in that order) to display on a single row like this: I have tried writing several SQL case…
Jimbo
  • 67
  • 9
1
vote
0 answers

Visual Studio SSRS 2016 - Switch Data Source on Environment Change

I have a SSRS project in a Visual Studio 2017. I have 4 copies of the database I can report against a local one, a development one, a QA one, and a production one. In the solution I have 4 environments setup in Configuration Manager to match, they…
Ben Hoffman
  • 8,149
  • 8
  • 44
  • 71
1
vote
2 answers

ReportViewer responds with 502 error after it times out

We have been building reports for SSRS 2016. Reports that execute in under 2 minutes work fine. However, we have some remotes that need well over 10 minutes. However, when executing the report it times out after about 2 minutes and returns this…
Khaled Abul Borghol
  • 11
  • 1
  • 2
1
vote
0 answers

403 error when trying download SSRS Report using System.Net.WebClient

I have the following code which I want to use to download an SSRS report as a PDF into a folder Protected Sub BtnPDF_Click(sender As Object, e As EventArgs) Try Dim client As New WebClient() client.Headers.Add("user-agent",…
SE1986
  • 2,534
  • 1
  • 10
  • 29
1
vote
3 answers

SSRS Data Driven File share account - impersonation error

I am setting up SSRS data driven subscription with windows file share delivery option. In regular SSRS subscriptions with windows file share delivery there is an option to use file share account credentials - seems that is missing in data driven…
BPen
  • 43
  • 1
  • 9
1
vote
1 answer

How do I show some static text for SSRS groups that are empty?

I have a query that groups by a particular column. Some of these groups have no entries and therefore are skipped. I would rather it state somehow 'GROUP XYZ IS EMPTY' How do I do this ? edit 1: You are correct and I did an outer join with the…
punkouter
  • 5,170
  • 15
  • 71
  • 116
1
vote
3 answers

How to select the latest year in the dataset?

I have a dataset that has 3 years worth of data, and I only want the latest year in the dataset for a tablix, in this case, 2019. In this case, I want to total(count) how many IncidentID's occur by grade for 2019 only. Data set: Desired…
JM1
  • 1,595
  • 5
  • 19
  • 41
1
vote
0 answers

SSRS LOOKUP function bug

I think I've found a bug in SSRS or maybe I'm missing something. Basically if I use a lookup in a text box between two charts, the legend values in the second chart are incorrect, the lookup function will not find a unqiue match but that 'should' be…
Alan Schofield
  • 19,839
  • 3
  • 22
  • 35
1
vote
1 answer

Pass a table value to a linked report filter - SSRS 2016

I have a report that has summary data and graphs that summarizes the data year by year. I also have a summary table that shows values by year and by type. When the user clicks on the graph or table it will take them to another report that has all of…
jdids
  • 561
  • 1
  • 7
  • 22
1
vote
2 answers

Trying to round the results of a sql query to 2 decimals

In the following query, I'm trying to return the data with 2 decimal places (.00) for the SUM line: SELECT CONVERT(varchar, YEAR(COALESCE(release_date, requested_date))) + RIGHT('00' + CONVERT(varchar, MONTH(COALESCE(release_date,…
SoTech
  • 41
  • 1
  • 7
1
vote
3 answers

The version of the report server database is either in a format that is not valid, or it cannot be read

I had an SQL Server 2012 database instance installed on server A. I then installed SSRS 2016 only (not the the complete SQL Server 2016) on server B but pointed the SSRS instance to host its ReportServer database on the SQL Server 2012 instance…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
1
vote
1 answer

Cannot Preview SSRS reports - Embedded connection

I cannot preview reports when using any embedded DS connection. I can however preview reports if I switch to 'Shared' DS connections. I am on Visual Studio 2017 version 15.7.5 Any ideas why? Embedded Data Source Configuration is given below.
Kman
  • 41
  • 9
1 2 3
…
30 31