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
Filter report table with a string name value
This is the data set I am trying to filter in Report Builder.
All columns have numerical values(blacked out) except for the first 'name' column.
I want to filter this table based on the row's string value from this 'name' column.
Complete table
I…
Clifford Piehl
- 483
- 1
- 4
- 11
0
votes
0 answers
SSRS , show negative results as zeros in the textbox
Currently I am using this as custom Format of the text box in SSRS to show negative numbers as zeros
Is this correct format
'$'#,0.00;-'$',0.00
Swara
- 15
- 7
0
votes
1 answer
adding http headers to SSRS 2016
Is there a way to add in custom http response headers to the response from SSRS?
Something similar to adding the following to an IIS web.config file?
I tried adding it in C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER2016\Reporting…
Moisés
- 105
- 1
- 8
0
votes
0 answers
Report Viewer cannot render SQL SERVER 2016 ssrs report
I wrote an application that renders an SSRS report from a 2012 report server using the winforms Report Viewer control and there was no problem. The reports were moved to a new 2016 report server and although the report opens without any problems…
0
votes
2 answers
SSRS - Add a value from previous rows based on value which start with ~
I am working on a complicated scenario where I need to show a dollar amount of previous lines until a tilde is present. Here is an example :
example image
As per the above example, if the line starts with ~ [tilde], it should show its own retail…
pam
- 7
- 3
0
votes
0 answers
Can't select Properties when logging into Reporting Services
SQL Server/SSRS 2016 Developer, installed on my local laptop, Windows 10 Pro.
My login is an admin to SQL Server, I'm able to do everything. For SSRS, when I try to connect to my web portal url I'm told "You are not allowed to view this folder. …
Rich Uchytil
- 457
- 1
- 7
- 16
0
votes
1 answer
SSRS Pass Date Parameter in URL
I have been trying to figure this out for a while now and I cannot seems to get it to work. I am trying to pass 2 date parameters to an SSRS report. I am using SSRS 2016. The link that gets you to the report…
Holmes IV
- 1,673
- 2
- 23
- 47
0
votes
1 answer
SSRS adding extra characters when exporting to CSV
I am creating an expression combining multiple fields into a single field in SSRS. However when I am exporting to CSV, some of the records are being appended with additional double quotes. How do I fix this?
Original…
Julaayi
- 403
- 2
- 8
- 23
0
votes
1 answer
Embed SSRS Report Viewer in Flask application
Context: I have a web application written in Python using Flask. I need to embed some reporting utility in the application and would like to use SSRS.
Question: I've investigated a few MSDN resources including the…
emalcolmb
- 1,585
- 4
- 18
- 43
0
votes
1 answer
How to Run SSRS Subscription multiple times with different parameters?
Is this possible without editing subscription table and SSRS SQL Job?
Let say I have a report that takes one parameter. The parameter1 is either EAST and WEST. SO I want to create ONE subscription that will programmatically run the report (in this…
BobNoobGuy
- 1,551
- 2
- 30
- 62
0
votes
1 answer
SSRS 2016 Report - Populate table from string parameter
Let's assume I have the following C# object:
public class BusinessDetails
{
public string Name { get; set; }
public string Address1 { get; set; }
public string Address2 { get; set; }
}
Long story short my solution…
tom33pr
- 853
- 2
- 12
- 30
0
votes
0 answers
SSRS Parameter value list always empty
I'm using the new Report Builder for SSRS in SQL Server 2019, and I'm trying to create a paginated report with one multi-value parameter.
I've given my report two datasets, both from the same shared Data Source. One data set is all the report data,…
Whistler
- 174
- 6
0
votes
1 answer
Generate 128 barcode font in ssrs 2016 and visual studio 2017
I am working with reports in Visual Studio 2017 and Reporting Service 2017,
and I have to use 128 barcode font in my report.
I want free way to do that.
I tried to use with IDAutomation dll but I didnt work for me.
Any one have some easy and free…
Tehila
- 61
- 2
- 7
0
votes
0 answers
ReportViewer show error when selecting first parameter
When I select first parameter in report viewer an error is occurred and does not allow me to select date parameters. screen shot is given.
Another issue is that when I select start date and end date on report viewer and click on View Report button,…
Syed Imran Shah
- 43
- 9
0
votes
0 answers
Error occurs when trying to allow multiple values in a parameter to select all when running the report
I have a parameter in my SSRS report which is a simple list of text values. What I want to do is to allow the person running the report to do so and show the whole report, then allow them to filter once run using the parameter.
I have selected the…
Becky Purland
- 89
- 10