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
0 answers
SSRS open file link in new tab or window
I have a few reports that show a link to invoices (.pdf files) that are held on our network share.
I use this on the text box property to to action to allow the user to click on it and view the…
Harry
- 2,636
- 1
- 17
- 29
0
votes
1 answer
IIF and DATEADD Issue in SSRS Report
I’m trying to add three new columns into a report I’ve already created. I’d like to sum up the item quantities by their age. So, the first column would be the total quantity for each item for the last 0-7 days, second would be for the last 7-14 days…
grimestan
- 5
- 2
0
votes
1 answer
SSRS Expressions Nested IIF with SUM not working
I am using SSRS 2016 / Report Builder and I am trying to get a nested IIF expression to SUM number of minutes spent in one particular Room (P241). There are some other conditions to deal with as well, which complicate matters.
I am able to…
tomorrowgrl
- 3
- 3
0
votes
2 answers
SSRS no data label for 100% chart
I have created a SSRS 2017 report with a pie chart. The dataset returns the number of 3 different values/sections (total "green", total "yellow", total "red").
Now I want to show the data labels (-> pictures). I switched to line-chart, added the…
JuMa
- 1
- 1
0
votes
0 answers
SSRS - Exporting grouped report to Excel shows top row twice when expanding the group
It seems whenever I export an expandable report to Excel, it reads the first line as a header or footer or something and duplicates that line so it shows up at the top and bottom of the group.
Example of one grouped item in Excel
As you can see the…
scorbin
- 9
- 5
0
votes
1 answer
SSRS email subscription link only opens to the home folder
My email link when clicked takes me to the Report Server login and after I log in it takes me to the home folder screen instead of the report. How can I fix this?
My URLroot in Report Server configuration is
…
0
votes
1 answer
How can I use the Report folder name as a parameter to chose the appropriate dataset?
I am using MS Reporting Services at a school board. I have a single report that is stored on the SSRS web server and then two linked reports are created to it so it exists in two different folders that have different security access. One is for…
0
votes
1 answer
SSRS Group Formatting
Building a report and I am trying to get specific formatting of a group I have. I have a list of tasks with times and these fall under specific days. I want to group these by the days so that the report shows me the information as such. I have…
Jayson Larner
- 73
- 6
0
votes
2 answers
Highlight Alternating Color Rows SSRS 2016
I have a table below with transaction data with names and amounts. I created a flag column called "Related" which identifies if the transactions are related or not based on if the “ParentID” column is matching. If so, the first will start with 1 and…
jwalls91
- 341
- 1
- 5
- 14
0
votes
1 answer
SSRS add Horizontal gridlines on Tablix to occupy the remaining space of report body in PDF format
I know this question has been asked multiple times and were already answered using workarounds multiple times also. But just in case this 2021, someone might have a better solution for this.
What I have tried so far:
Background Image - It's…
redz0323
- 56
- 10
0
votes
1 answer
Service parameter set other parameters to null in SSRS
I have a report with a multi param query that consumes a wcf service.
I set some params with some values:
@param1 = 1
@param2 = 2
@param3 = "some string"
and report works fine but when I set @param4 = 1 or any other value, then
@param1 = null…
0
votes
2 answers
In SSRS, is it possible to code for at least one parameter needs to be populated, but not all them need to be?
Using SSRS 2016. Have a request to use 2 parameters for the report, but only one of them needs to be populated before you view report.
If report has ParmA and ParmB, only one needs to have data selected or entered. But at least one needs to have…
Dwight T
- 1,457
- 2
- 11
- 20
0
votes
1 answer
i want headers to appear in every after of each month in my SSRS report
i want row headers to appear in every after of each month in my SSRS report like in the picture below
reference
Diana Bernal
- 3
- 1
0
votes
1 answer
Columns/ReportBody based on Parameter Selection in SSRS
SSRS Report with one Parameter-selection as BusinessUnit with 3 Options( CustomerService, Sales, Inventory).
As per requirement, with the option Selected, User should be able to View Columns/Fields and Rows respective to choosen…
Aniel
- 39
- 5
0
votes
1 answer
how to create ssrs report that shows database names as a dropdown filter and user can select the database dynamically and run the report
how to create ssrs report that shows database names as a dropdown filter and user can select the database name and connect dynamically and run the report.
The Server name is same, just the databases must by dynamic.
Please let me know.
Akhira
- 203
- 2
- 5
- 16