Database Administrators

Questions tagged [report-builder]

Ask Question

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

17 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0
votes
1answer
56 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
1answer
55 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 ...
1
vote
1answer
48 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 ...
0
votes
0answers
19 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
27 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
203 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
51 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
23 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
118 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
40 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
2k 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
59 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
202 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
188 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
71 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
76 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
3k 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 ...