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.
Questions tagged [ssrs-2016]
463 questions
0
votes
1 answer
Is there a way to choose functions for dates when subscribing to an SSRS report?
I have a report that has a 'StartDate' and 'EndDate' parameter, with no default values. When subscribing to this report, the user chooses the dates that they would like to see. What I want to do is have options for them to choose, such as 'Today',…
Evie
- 1
0
votes
0 answers
In SRSS report, when using Parameter for Database Name, it clears out other report parameters
I have a copy of a report with a hardcoded Database name and everything works correctly, but the version of the report where I pass in database name as a parameter has some issue with the other parameters on the screen.
First issue - I have a…
DraxStorm
- 1
- 1
0
votes
0 answers
SSRS 2016: Export to Excel issue
When I try to export to Excel an SSRS Report, I have the following error:
Export to Excel error
Attached is the version of SSRS installed:
Version of SSRS
I am using the Virtual Service Account as a Service Account. I read in other forums that when…
0
votes
0 answers
SSRS 2019 - Applying user permissions to reports in bulk
First time posting on here.
I've deployed over 400 reports to SSRS and I'm trying to find a way to apply user permissions to the reports in bulk, but I'm having zero luck.
I don't want the reports to inherit the same permissions from the parent…
0
votes
1 answer
SSRS Data-Driven email only when query returns data
We are trying to develop integrity report to keep tables clean.
For example:
To: mail@mail.com
From: sender@sender.com
Subject: Individuals that have multiple primary email address
Body:
ID
Email Address
1
me@me.com
1
you@you.com
We…
XmalevolentX
- 121
- 1
- 2
- 9
0
votes
0 answers
How to calculate the date difference for each record, then average that?
I am totaling all open dates and all closed dates then taking the difference.
This is the expression I have that is not working for me.
=Avg(DateDiff("d",Fields!Opened_Date.Value, Fields!Closed_Date.Value))
It just displays error on the report in…
lovelydeatheater
- 1
- 2
0
votes
0 answers
SSIS duplicating records. Where should I look?
I recently migrated a SQL Server that sends out 3 reports daily. As part of the migration, I have been comparing the old server SSRS reports to the new server reports. Starting last Thursday, the all 3 new reports are showing exactly double the data…
Patrick
- 1
- 1
0
votes
1 answer
SSRS Switch Colour Expression multiple groups criteria
I trying to colour code a group within a group based on a value.
enter image description here
I am quite new to SSRS, and have tried various expressions, SWITCH, IIF etc but I cant seem to get them to reference the various criteria and groups…
clubmatty
- 1
- 1
0
votes
0 answers
Dynamic number and ranges of graphs in SQL server report services
I need to create a report for a process that spans from time t1 to t2.
In the report I need to have number of graphs, one for every 4 hours of the process, for example if t1=9:30 and t2=20:17 I need three graphs in total, one from 9:30 to 13:30, one…
ubs
- 1
- 2
0
votes
0 answers
SSRS Webservice GetItemReferences() returns empty
I am trying to leverage the ssrs webservice for our report sever in native mode to add a new datasource to all our current reports. I can return all the items available on the report server. I can get data sources and the info contained in them, but…
KeetsScrimalittle
- 93
- 3
- 15
0
votes
0 answers
SQL Server Migration- SSRS Reports don't match old server
I am looking for some direction on how to solve this SSRS problem. Basically, I am migrating a 2012 sql server to a 2016 server. I am on the last leg which was to ensure the SSRS reports being sent out match the old prod reports.
Two of the three…
Patrick
- 1
- 1
0
votes
0 answers
SSRS Report - Image always pushed to next page when converting to PDF
I have an SSRS report with two JPEG images of bar graphs.
The two images in my report designer are stacked on top of each other.
Both are contained in a Rectangle.
When I run the report, it displays correctly in my browser and report…
Matthew
- 158
- 1
- 1
- 5
0
votes
0 answers
The value provided for the report parameter 'ActionOwnerDate_from' is not valid for its type. (rsReportParameterTypeMismatch)
I am getting following error for my Reporting Services report:
Microsoft.Reporting.WinForms.ReportServerException: 'The value provided for the report parameter 'ActionOwnerDate_from' is not valid for its type. (rsReportParameterTypeMismatch)'
That…
Henry
- 537
- 1
- 9
- 22
0
votes
1 answer
SQL Server 2016 Reporting Services says I don't have permission to view local reporting server
The company requires we use SQL Server 2016 Reporting Services to generate reports. I attempted to restore a database from a backup, but have encountered permission errors when I go to the web portal URL.
I found some advice online about making sure…
0
votes
1 answer
SSRS 2016: Report Delivery Extension to send report email via MicrosoftGraph&AzureIdentity, but error in assembly version of Microsoft.Identity.Client
Microsoft announced the expiration of Basic Authentication in Exchange Online except STMP AUTH, but no guarantee on using it for long term. So, I decide to start the change with our Reports delivery in SSRS 2016 which mainly via SMTP email right…
Hai Nguyen
- 25
- 4