Questions tagged [report-builder]
Use for questions relating to Microsoft's report authoring and publishing tool.
24
questions
0
votes
0answers
8 views
Report Builder - databases missing in connection properties drop down
I'm putting together a new paginated report using Report Builder, but when it comes to adding the datasource, there are a number of databases that aren't showing in the drop down after entering the ...
0
votes
0answers
13 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 ...
0
votes
0answers
79 views
An item with the same key has already been added Error in Report Builder
An item with the same key has already been added Error in Report Builder
Relevant SQL Server stored procedure executed successfully when we attach the data set to the Report builder after refreshing ...
0
votes
0answers
8 views
need help on query to get only yesterday's event completion report where column is Compl_date and string is Date Time
I need a query to get only yestreday's learning completed in the report where we use Completion date with string as Date Time both as filter let me know how to write an query to get above Delta ...
0
votes
0answers
83 views
Add a page for Terms and Conditions after Footer SSRS
I need to add some terms and conditions to print after my report on a separate page. So what I’ve done is add a rectangle, after the tablix that contains the detail of the report. Set that to add a ...
1
vote
0answers
24 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
1answer
101 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
1answer
72 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
1answer
69 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
475 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
1answer
541 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
85 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
437 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
1answer
30 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
191 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
64 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
3k 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
97 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
274 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
250 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
113 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
106 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 ...
4
votes
3answers
5k 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 ...
