Questions tagged [report-builder]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
69 views

Stop column names from being altered in SSRS Report Builder 15.0

I'm encountering an issue where Report Builder is arbitrarily removing characters from field names, and also adding spaces in front of capital letters in others. See image for example: two of them had ...
JohnH's user avatar
  • 1
0 votes
1 answer
3k 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 ...
Daniel Waczek's user avatar
1 vote
0 answers
98 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 ...
KeetsScrimalittle's user avatar
1 vote
1 answer
2k 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 ...
Arun Ramamurthy's user avatar
0 votes
1 answer
2k 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" ...
user192303's user avatar
0 votes
1 answer
590 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 ...
Daniel's user avatar
  • 103
0 votes
1 answer
2k 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 ...
cleverpaul's user avatar
2 votes
1 answer
4k 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 ...
SomeGuy's user avatar
  • 1,993
2 votes
0 answers
390 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=...
NateJ's user avatar
  • 804
0 votes
0 answers
42 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 ...
Shane Da Silva's user avatar
1 vote
1 answer
2k 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 ...
ChrisF's user avatar
  • 302
0 votes
1 answer
251 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 ...
Archie's user avatar
  • 1
1 vote
1 answer
403 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 ...
JonDBA5420's user avatar
0 votes
1 answer
296 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, ...
JonDBA5420's user avatar
0 votes
1 answer
5k 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?
Steve_Malcolm's user avatar
0 votes
1 answer
243 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!...
BoyGeorge's user avatar
1 vote
0 answers
658 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 ...
camaron182's user avatar
3 votes
1 answer
353 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 ...
TheAdmin's user avatar
  • 133
1 vote
1 answer
563 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 ...
Edeholland's user avatar
5 votes
3 answers
12k 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 ...
M.Ali's user avatar
  • 1,950