Questions tagged [report-builder]
Use for questions relating to Microsoft's report authoring and publishing tool.
21
questions
0
votes
1
answer
2k
views
PL/SQL: Selecting multiple values from the same column
We have a table in which all kinds of different Words are stored with a unique id each. In other tables, certain fields which should contain words instead only contain the id of these words. Let's ...
0
votes
0
answers
450
views
Highlight Rows with Duplicate Column in SSRS Report Builder
I have used the below expression to highlight duplicate column
=IIf(Fields!BankAccount.Value=Previous(Fields!BankAccount.Value),"Firebrick","LightSteelBlue")
I have added another ...
1
vote
0
answers
32
views
SQL Server Report how to create multiple groups with hidden details
I have created a report that has multiple rows returned from one query.
I have a chart that is created for all the row and I have it grouped on the server location. the group properties of the ...
1
vote
1
answer
1k
views
Query Editor Connection Error With Unattended Service Account
ERROR:
When editing a report in report builder, opening the query editor gives the following error
You have specified integrated security or
credentials in the connection string for the
data ...
0
votes
1
answer
1k
views
How to use OR in IIF statement in row visibility?
How to use OR in IIF statement in SSRS
=IIF((Fields!txtCurrentSubjectReportName.Value="",
Fields!txtSubjectArchivedName.Value,
Fields!txtCurrentSubjectReportName.Value) = "School Life"
...
0
votes
1
answer
335
views
How to use the COUNT function to count up to the current row for each row?
I had trouble phrasing the question, but I think the following example will clear things up.
Context: Trying to create a query for Microsoft Report Builder, need to perform some logic on the data in ...
0
votes
1
answer
1k
views
I cannot get my data source to connect to an SQL Server named instance using SSRS Report Builder
I have a report in SSRS and I want to update the data source to use a named instance instead of the default instance. The server host will remain the same.
I thought this would be easy. I simply ...
2
votes
1
answer
3k
views
SSRS 2017 - Client found response content type of '', but expected 'text/xml'
I've got SQL Server 2017 Developer installed on my workstation, and just installed SSRS 2017. I am able to navigate in the SSRS portal, and upload files of dummy data, and create KPIs. However, when ...
1
vote
0
answers
296
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
0
answers
34
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
1
answer
1k
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
1
answer
126
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
1
answer
311
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
1
answer
169
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
1
answer
4k
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
1
answer
173
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!...
2
votes
1
answer
358
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
0
answers
556
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
1
answer
212
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
1
answer
372
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 ...
5
votes
3
answers
10k
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 ...