Questions tagged [report-builder]

Use for questions relating to Microsoft's report authoring and publishing tool.

Filter by
Sorted by
Tagged with
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 ...
  • 103
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,973
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=...
  • 784
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 ...
  • 292
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
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 ...
  • 133
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 ...
  • 133
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 ...
  • 1,890