Questions tagged [report-builder]
Use for questions relating to Microsoft's report authoring and publishing tool.
0
votes
0answers
6 views
SSRS 2016 / VS 2015 Editing text in tablix's textbox very slow in designer
Same issue as described here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6bf89cd-75de-49f9-8a3a-743419ecd631/ssrs-2016-editing-text-in-a-textbox-very-slow-in-the-designer?forum=...
0
votes
0answers
25 views
MySQL Query to Display Organized by Date
I'm good with basic types of queries but this has me stumped. I have the table schema listed below, I need display the results in a table, with each row displaying the available results for a given ...
1
vote
1answer
56 views
How can I override the default values for a parameter in a report?
I have a report with a parameter that usually gets its default values by running a query that takes another parameter as it's input. This works fine when the report is run interactively.
However, I ...
0
votes
0answers
26 views
SSRS 2016 (under Power BI RS) Shared data source change won't save for paginated reports!
I am running the Jan 2019 build of Power BI Report Server. For paginated (SSRS) reports, I am UNABLE to change a report to use a different shared data source on the portal. I click "Manage" on the ...
0
votes
1answer
16 views
Report-builder: How can I show the labels in a List when the dataset is empty?
An equivalent question was answered for a tablix, but I would like to do this for a list:
"how to keep the structure of a tablix where there is no data".
I am showing about half a dozen fields in the ...
1
vote
1answer
94 views
SSRS Reports Blank on Zebra Printer
I need assistance getting labels to print from SSRS 2014 to a Zebra GK420D direct thermal label printer. The labels show up when running the report but when I print them to the label printer, all that ...
0
votes
1answer
22 views
SSRS Label Orientation
I'm trying to print labels on a Zebra printer in SSRS 2014 and the orientation is coming out wrong. In report builder, I set the page size to 4.15 x 1.15 with correct margins. Also, in report builder, ...
0
votes
1answer
1k views
How can I achieve conditional page breaks in SSRS 2016
I am using SSRS 2016 and Report Builder. I need the page breakinging with a group to be conditional on the value of a parameter. Does anyone know if this is even possible?
0
votes
1answer
37 views
Making Switches Work in SSRS
I'm trying to get my report to display different color cells, depending on the condition. This is my current code:
=Switch(Fields!DaysToExpiration.Value > 31, "Green",
Fields!...
1
vote
1answer
144 views
Report Builder Indicator showing incorrect symbol
I have a report on which I am using about a dozen indicators as a check boxes. The data source for the report is a SharePoint list. About half of the check boxes are displaying correctly. The other ...
1
vote
0answers
145 views
Catch SqlException on SSRS report
I am trying to catch a SqlException on a SSRS report and display it on a pop-up. So far I have not been able to find this configuration on Report Builder and I thought maybe adding some code on the ...
3
votes
1answer
66 views
How do I join 2 columns in query result (SQL report builder)
As the image below shows, on my DB I also have 2 columns that appear in the results pane separately - first name and last name - (lower part of image)
How do I join them together in the report ...
1
vote
1answer
73 views
How to use a list in a list in report builder?
I'm currently using Microsoft SQL Report Builder to create a custom report for my data. I have a table of customers, a table of devices and a table of jobs (each customer has a couple of devices, each ...
3
votes
3answers
2k views
Report Builder does not connect for a remote reporting Server
Current Environment
I am in a bit of trouble here, I have a Reporting Services installed on one server and SQL Server database engine installed on another server.
The users are connecting to ...
