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

SSRS authentication from the "new" Microsoft Edge

For the last 3-4 weeks now, when I login to our SSRS from home, I have to re-enter my credentials no less than 15 times (this is NOT an exaggeration) before I can use the site. Internally, it never asked for credentials until this time. On the…
Jim Powers
  • 79
  • 10
0
votes
1 answer

How can I use nested aggregation on both row and column groups?

I have a row group for Tenants (which has a page break on) and a column group for Floors. The data output is in the following format, as you can see because of other data items the TotalArea is duplicated, I need to take the first/max TotalArea and…
AMouat
  • 685
  • 15
  • 27
0
votes
0 answers

SSRS Report tablix - wrap 2 columns on page, with group page break

I have a report requirement to print tablix rows in two columns per page. The Customer group needs to page break to a new page. If the customer has enough records it will wrap on the same page into two columns. I was able to get a solution working…
SherlockSpreadsheets
  • 2,062
  • 3
  • 27
  • 47
0
votes
0 answers

SSRS 2016 external images not displaying when using AWS Route53 HTTPS URL

I have 2 Windows EC2 instances with SQL 2016 and SSRS installed on it with SSL certificate. These 2 instances are under the target group of an NLB. The NLB is referenced using the Route53 HTTPS URL. Same SSRS database has been deployed on both the…
Romanshu Goel
  • 103
  • 3
  • 9
0
votes
2 answers

automatically manage a failed ssrs subscription

So, I want to automatically re-fire failed ssrs subscriptions (most of them are data-driven subscriptions) : during the weekend (mainly saturday) we have many data-driven subscriptions that run and almost every weekend we have failures, so, monday,…
Med-2022
  • 1
  • 1
0
votes
1 answer

SSRS 2016 Oracle ODP.NET intermittent ORA-12571

We have run for the last 7 years without issue against the same oracle 11g database using SSRS 2008 with an OracleClient data source. As soon as we upgraded to SSRS 2016 and had to switch to ODP.NET, we are randomly getting ORA-12571 errors. It…
user1134307
  • 218
  • 2
  • 5
  • 16
0
votes
1 answer

How to set the maximum horizontal axis range in a line chart in SSRS?

I have a line chart with markers in ssrs that is currently displaying 4 months of data (Jan through Apr). I would like the maximum horizontal chart range to extend from Jan to Dec. It's automatically filling the chart window up to Apr because I…
Kurt Cederholm
  • 29
  • 7
0
votes
2 answers

Why is SQL Server database function performing slow | SSRS multi-valued parameter with stored procedure

I'm looking for insights into some intriguing issues while working with SQL Server. Background We have few SSRS reports running on APS (SQL Server PDW/MPP) The reports datasets have the embedded queries are run directly on the database. Now one of…
Ankur
  • 11,239
  • 22
  • 63
  • 66
0
votes
1 answer

SSRS Report Parameter Pick Lists Are Disabled When Creating/Editing Subscriptions

I see a lot of similar questions posted, but none quite exactly like what I am experiencing. The parameter pick lists for the SSRS report work properly when running the report as you normally would, but certain ones do not work when trying to create…
Neil Galloway
  • 141
  • 1
  • 1
  • 5
0
votes
1 answer

SSRS 2012 to SSRS 2016 causing reports to show different NLS parameters (Oracle 12c (12.1.0.2.0) )

We've recently updated SSRS to 2016 from 2012 - once we updated the server and installed the ODAC we noticed the NLS settings change for reports (for example if we run SELECT * FROM V$NLS_PARAMETERS locally the NLS settings default to UK however…
Blake_SO
  • 1
  • 1
0
votes
1 answer

SSRS Migration from 2008R2 to 2017 Error RSPortal

I was migrating our reporting services from the version 2008R2 to the version 2017 restoring the db and all seems to work fine unless for some report for which I cannot open the subscriptions page. For those report every time I enter in the report…
TooFast
  • 93
  • 7
0
votes
1 answer

Manually Setting SSRS Report Subscription Parameters and Want to Set a Parameter to NULL

I am manually setting and running an SSRS report subscription. It has worked fine up until now, but I need to make a change to the report to set one of the parameters to NULL (this is a valid selection for the parameter to select "All" options of…
Neil Galloway
  • 141
  • 1
  • 1
  • 5
0
votes
1 answer

Select counts from two tables, and output the results in a specified format

I have two tables with different overall structures, but they share 3 column names: dbo.[Moves] Id | DeviceId | TL_Event_Date | ... ---|------------|--------------------------|------ 1 | D810 | 2020-01-28 09:19:55.587 | ... …
AChrapko
  • 166
  • 2
  • 2
  • 13
0
votes
1 answer

Using Javascript to create POP UP sub report in ssrs not working

Hi I have been using SSRS for 10 years now but have not had to use the Go to URL Action method to pass through a SSRS report and parameters for a while (2008R2). So the concepts could have changed etc. My full expression was based on various post…
Ian W
  • 385
  • 2
  • 10
  • 30
0
votes
2 answers

Filter SSRS Tablix into 2 columns that updates dynamically for menu page links

I have this SSRS report which I'm using as a menu page, with an action assigned to each report name to take the user to it. But as you can see with more and more reports being added, it's slipping over the page. I want to create a menu page which…
Pinkybloo
  • 15
  • 7
1 2 3
…
30 31