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
0 answers

SSRS - Power BI Reporting Server: Running subscriptions simultaneously

I'm running Power Bi Reporting Service 2018 Version 1.2.6648.38132 The problem I am running into is when running scheduled subscriptions, only 1 subscription can be run at a time. When starting the subscription manually through the SQL Agent (while…
theOGloc
  • 231
  • 4
  • 13
1
vote
1 answer

SSRS 2016 find 2nd minimum/ 2nd maximum

I want to find the second minimum number in my row. I can complete Min and Max by the inbuilt expression. More information about the SSRS, it is loaded from SSAS datasource. In the SSRS design, I have followed Chris steps 1.) Put the custom code…
Platalea Minor
  • 877
  • 2
  • 9
  • 22
1
vote
0 answers

SSRS 2016 Chart not loading in Chrome

I'm using SSRS 2016 Reporting services. I created a line chart and when i view the report through the application (report viewer control) it is working fine in IE but the chart is not loading in chrome. Once I refreshed the URL using ctrl+F5 it is…
Sreepathi
  • 93
  • 13
1
vote
1 answer

SSRS Date Parameter Interpretation Issue

I'm looking for some help with SSRS 2016, and Date Parameters. We have multiple reports that have date pickers, and we need to keep the date pickers. The issue is, when we load the report through the web portal the dates comes out as MM/DD/YYYY and…
Svelluto
  • 63
  • 8
1
vote
0 answers

SSRS Server Data Sources Lost authentication

I am using sql 2016 Ent. and had a very strange issue yesterday. I had most of my shared data sources on my production ssrs server suddenly "lose" their authentication to their sql servers. The fix was to go to each one by one and re-enter their…
Carl
  • 11
  • 1
1
vote
1 answer

SSRS 2016 - Customise Output based on values in data

I have been tasked with creating a report that needs to display in chronological order, but within that report there is data from 2 sources that covers 2 different areas of business. What I have been asked for, is when the type of business changes,…
chilluk
  • 217
  • 2
  • 17
1
vote
1 answer

SSRS 2016 - Tablix in subgroup fails upon deployment

SQL Server 2016, SSRS: I have an expandable group that works correctly in Report Builder or Visual Studio SSDT, but does not display when run on the server. My charter was to create a report that didn't rely on pop-ups or new windows to display…
Barry Seymour
  • 51
  • 10
1
vote
0 answers

SSRS Calculated Fields ends up showing error

In SSRS reports I have created this calculated fields to calculate or return sales of Bike WRT to the previous year but it ends up showing error:- The expression used for the calculated field 'CompareSales' includes an Aggregate, RowNumber, Running…
Yash Sonar
  • 13
  • 5
1
vote
1 answer

SSRS 2016 Custom Authentication error - ProcessingObjectModel DLL access denied

We have two instances of SSRS 2016 installed, as one of them requires Windows authentication and the other requires custom authentication. The latter follows all the latest direction from the sample everyone references, except that it leverages a…
MikeL
  • 11
  • 1
1
vote
1 answer

Merge duplicate (row group) column cells

ID| Date1 | Date 2 |Total ----------------------------------- 1 | 15/02/2017 |02/02/2017 | 3 | ----------------------------------- 1 | 15/02/2017 |05/08/2017 | 3 | ----------------------------------- 1 | 15/02/2017 |12/12/2017 | 3 …
StackTrace
  • 9,190
  • 36
  • 114
  • 202
1
vote
1 answer

Maximum File Count Per Folder

Is there a way to set a maximum number of files that can exist in a given folder? For example, if I had a folder for sales reports, I might want to set the maximum number of reports to ten, i.e., I don't want the sales folder to have more than ten…
user219454
  • 81
  • 1
  • 8
1
vote
1 answer

SSRS: Horizontal alignment on a group

On my dataset I select information from four different years sorted by date and how many subscriptions I had on said date, which looks something like this: Date Year Subs Day 15/09/2014 2015 57 1 16/09/2014 2015 18 …
Flares
  • 13
  • 2
1
vote
3 answers

SSRS-Datasource won't change when reupload report

I got a report with 2 data sources and both are Shared Data source. I am trying to change both of them to Custom Data Source but when I re-upload the report in my Report Manager, it won't work. Edit: I don't have an error because the report…
Marie-Catherine Richard
  • 13
  • 5
1
vote
1 answer

Trigger SSRS Data Driven Subscription - with Parameters supplied

I have an SSRS (2016) report that accepts a date parameter. The user selects a date and the report runs and returns one page per customer. The report also has a data driven subscription which when triggered, emails the output relevant to the…
Harry
  • 2,636
  • 1
  • 17
  • 29
1
vote
0 answers

Reusing the service account in an SSRS data source

SQL Server 2016 reporting. The SSRS service runs as an account that has read access in the database I'd like to run reports from. I'd like to create a server level data source object that would use the Windows service account to connect, instead of…
Seva Alekseyev
  • 59,826
  • 25
  • 160
  • 281
1 2 3
…
30 31