Stack Overflow
Stack Overflow

Questions tagged [reporting-services-2016]

SQL Server 2016 Reporting Services is a comprehensive, highly scalable solution that empowers real-time decision making. SQL Server 2016 enables the creation of operational reports for pixel-perfect printing and browser-based viewing as well as ad-hoc data exploration and visualization.

In Report Builder and SQL Server Data Tools, you can now create native DAX queries against supported SQL Server Analysis Services tabular data models. You can use the query designer in both tools to drag and drop the fields you want and have the DAX query generated for you instead of writing it yourself. Their new features

  • Reporting Services web portal
  • Custom branding for the web portal
  • Key performance indicators (KPI) in the web portal
  • Mobile Reports
35 questions
4
votes
1 answer

"Syntax error" on button click in iframe (SQL Report)

In an application I am showing a SQL report inside an iframe. Inside the report there are some buttons for expanding a tree view. When I open the URL directly in browser (Internet Explorer 11), I can use these buttons without any problem. When…
diiN__________
  • 7,393
  • 6
  • 42
  • 69
2
votes
1 answer

SSRS Forms Authentication - How To Pass Cookie Credentials To Report Server

I am currently attempting to render the SSRS report in my web application using forms authentication. My SSRS Report Version is 2016. Initially I was under the impression that NetworkCredentials would work, and after encountering errors, I found…
NeedMeds
  • 41
  • 1
  • 6
2
votes
3 answers

SSRS Barcodes broken in reports after upgrading to 2016

We recently upgraded our report server to 2016 and everything worked great except for the reports that contain barcodes. I tried going back through the same article I used the first time we started using barcodes but so far I have not had any luck.…
Stinkpile
  • 21
  • 3
1
vote
1 answer

SSRS - Using a Lookup in Background Color property changes the values of the entire row in the tablix

I have a dataset that contains balances for customer accounts by month: CustomerID Month Balance 1 1/1/2022 100.00 1 2/1/2022 -100.00 2 1/1/2022 100.00 2 2/1/2022 100.00 I am then simply displaying this dataset in a table, so…
C Black
  • 978
  • 6
  • 13
1
vote
1 answer

How to set `EnableExternalImages = true` for LocalReport

I am using reporting package - AspNetCore.Reporting -2.1.0. I want to print my RDLC report having an external image. During rendering to pdf an error occurred. An error occurred during local report processing.;Report 'Payslip' contains external…
Nandan Kumar Das
  • 33
  • 4
1
vote
0 answers

Problem in running SSRS report using custom dll in SSRS 2016. Failed to grant permission to execute

When i am running the report, it is supposed to access a custom assembly (which is not signed), But i am getting the below error. Failed to load expression host assembly. Details: Could not load file or assembly "xxxxxxx, Version=6.0.0.1,…
Subhash Makkena
  • 1,909
  • 2
  • 13
  • 15
1
vote
1 answer

what is report server and how it differ from local report and when to use it?

I'm confused about Reporting servers like ssrs,crystal report server ... why I'd need a report server when I can connect to sql and get the data then bind it to a local report and view it in report viewer what is the report server and how it differ…
Shadi Fayed
  • 376
  • 4
  • 16
1
vote
1 answer

Does SSRS in an Azure Virtual VM support Report Server Databases as Azure SQL Database and/or Azure SQL MAnaged Instance?

I installed SSRS into an Azure VM (IaaS). In the ssrs configuration manager, I tried the report server databases point to an Azure SQL Managed Instance database, but the connection didn't work. I would like to know if SSRS in an Azure VM support…
GMVS
  • 11
  • 1
1
vote
1 answer

ssrs:add null value to multi value parameter didn't work

in order to allow a selection of null value in multi value parameter in SSRS project we can use the query for the data set Select ID,Value From SpecificTable Union All Select NULL,'Other' in order to let null value returned from parameter when…
oula alshiekh
  • 843
  • 5
  • 14
  • 40
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
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

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

Can a SSRS tablix have two matrix elements in the same tablix?

I have a dataset that is made up of two sets of data. Old records - which are the historical values of current active records New records - the current values of active records The old records are the primary set of data, but not all old records…
A.Steer
  • 335
  • 3
  • 14
0
votes
1 answer

SSRS Report showing blank values but on export it is showing actual values

I have an report, which was working fine on my old laptope but when i use the same in my new laptop is showing blank in place of data values like image below:- enter image description here But when i use same report after publishing on report server…
AkJ
  • 1
  • 1
0
votes
0 answers

Sql Reporting Services 2019 can't create or modify Datasource after installation

I'm doing a fairly vanilla install of Sql Reporting Services 2019 on a VM with the Reporting database being created on a Sql 2019 cluster server. The service account is running as an Active Directory Domain user account following the instructions…
Andrew Wu
  • 3
  • 1
  • 10
1
2 3