25,621 questions
0
votes
0
answers
13
views
SSRS - access column group values in row
I am working this SSRS report. This is a count of how many holidays staff have worked over a supplied date range. The report is "Row Grouped" with Officer name. It is also "Column ...
-2
votes
0
answers
29
views
SSRS VS 2019 preview report error 0xc0000005 - unexpected parameters [closed]
I have been fighting this error for quite a long time. details:
This issue does not occur on my old server which has vs 2012 (shell). everything works great.
on my 2 new servers that have vs 2019 ...
1
vote
0
answers
41
views
SSRS: trying to open a link in a new tab
I have a report where one of the fields to display in an actual url. However, if I set the action to "go to URL", it opens in the existing window and I lose the report. I've been reading ...
0
votes
0
answers
59
views
Create an SSRS report without a contract class in D365 FO
I'm trying to create an SSRS report in D365 FO, I have added an output menu item for SSRS report inside Warehouse Management-> All Loads -> Select a Load
That inside WHSLoadTable form action ...
0
votes
0
answers
24
views
How to combine detail rows in ssrs?
I have an SSRS report that requires certain rows to be combined vertically in contiguous blocks across a table environment. I am struggling to find the right way to shape the data or the row/column ...
- 113
0
votes
0
answers
48
views
Trouble embedding SSRS report in iframe – scripts fail to load from correct origin
I'm having trouble embedding an SSRS report in an <iframe> from an external application. The app calls the report server URL, and we've already configured CORS and switched to basic ...
2
votes
2
answers
79
views
Query on SSRS Content table for reports with hyperlink action returns all reports
I am trying to identify only reports with a hyperlink to another report. I am using SQL Server 2019 (150).
My SQL:
SELECT
C.ItemID,
C.Name AS ReportName,
C.Path AS ReportPath,
CONVERT(...
- 29
0
votes
1
answer
38
views
How to repeat single SSRS tablix footer on every page
I am new to SSRS and the report builder.
I have the following report that has a row group with a header and several footer rows. I need to repeat one of the footer rows on every page but when I do ...
- 23
0
votes
0
answers
28
views
SSRS Chart Striplines
How can I hide the top stripline in SSRS when the value is based on a user input of 0.01, but it's currently plotting both at the top and bottom of the 1% range? I only want to display the stripline ...
- 673
0
votes
0
answers
38
views
In SSRS Report preview tables are not aligned proper
When I try to preview the report it is breaking into next page.
Before preview
After Preview
Please provide me the solution.
Page size: Letter
Image view: Portrait
I tried in adjusting the report ...
0
votes
0
answers
19
views
Rank produced by code resets on a new Tablix in viewer but not in export
I am using the code provided as an answer to this question. How to assign Rank in SSRS report? to produce a rank on a SSRS report.
The rank is being created via code and not directly in a SQL script ...
- 473
0
votes
0
answers
26
views
How to add a reference line in SSRS Line chart
How can I add a reference line to a chart in SSRS using the following expression?
=IIF(UBound(Parameters!TFN.Value) = CountDistinct(Fields!DIALED_NUMBER.Value, "ds_details"),
Fields!SLA....
- 673
0
votes
0
answers
31
views
SSRS Line chart dual axis
I'm building a dual-axis line chart in SSRS to visualize Call Block % on the primary axis and SLA % on the secondary axis.
Logic:
If all TFNs are selected from the parameter, the secondary axis should ...
- 673
0
votes
0
answers
20
views
IIF using specifik dataset containing multiple rows
I have a simple SQL table
SELECT ID, Textvalue
INTO temptable1
FROM (
VALUES ('ID1', 'v1'), ('ID2','v2'), ('ID3','v3')
) AS x(ID, Textvalue)
which I import to SSRS as a dataset with the query
SELECT ...
- 1,242
0
votes
0
answers
28
views
RDLC: Page breaks with horizontal table / matrix
Ended up solving this myself
I set up a horizontal “table" in my RDLC using column groups on a matrix. However, I was frustrated that I could not add page breaks, as they are ignored in column ...
- 1
1
vote
0
answers
41
views
Specify a default value if a non-permitted value is provided for a parameter
I have an issue with two parameters, one being @MinValue and the other being @MaxValue. @MinValue has permitted values 90, 182, 365 whereas @MaxValue depends on @MinValue and its available values are ...
- 1,242
0
votes
0
answers
75
views
SSRS stored procedure dataset - "No Permission" error despite granting execute to user
I'm working with SQL Server Reporting Services (SSRS) and have run into a permission issue when using a stored procedure as the dataset source.
Here's what I've done so far:
Created a stored ...
0
votes
0
answers
87
views
SSRS Parameter Filter on Tablix, Strings with Special Characters
I have an SSRS report that returns records based on date span. My customer wants added filter options for a string field, all of which contain special characters, like 2025-01-1234. I created a Tablix ...
- 53
1
vote
0
answers
39
views
SSRS grey out / hide parameter based on result from other parameter
I have a parameter called UseLicenceExpiry with available values of "Yes" and "No", and a default of "No".
I have a dataset called ParameterLicenceExpiryDate which is set ...
- 11
0
votes
0
answers
44
views
In SSRS how to Sum values when duplicates exist without modifying the dataset
In SSRS 2016, I have a dataset that I cannot modify because it is too complex to add a ROW_NUMBER (it multiplies the rows too much).
Here is an excerpt from this dataset with the values relevant to my ...
- 57
0
votes
0
answers
35
views
SQL server reporting services wont connect to reportbuilder
enter image description here
I don't know why Report builder can't connect to my sql server reporting services , i am running everything localy.
I can connect to the site on my broweser i chcecked ...
0
votes
0
answers
16
views
Tablix inside of a list in RDLC
I am trying to make a rdlc report with this format (each Nave should in a new page)
+-----------------------------------------------------------------------------------+
| List (DataSet: DataSet1, ...
- 3,052
0
votes
0
answers
53
views
ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering
We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2):
https://www.nuget.org/packages/Microsoft.ReportingServices....
- 1
0
votes
0
answers
35
views
Issue with SSRS Cascading Parameters Using SnowSQL
I’m working with an SSRS report that includes three cascading parameters: Director, Manager, and Supervisor. The setup is such that:
Manager is dependent on the selected Director
Supervisor is ...
- 673
0
votes
0
answers
118
views
Use Unicode symbol in SSRS report
I need to add a globe symbol into a field on my SSRS report. I cannot find it in Webdings or any of the Wingdings. I found it in Unicode with the link below. 1F30E is the symbol I am trying to add. Is ...
- 47
1
vote
1
answer
33
views
How to add another row group level for displaying data in a tree hierarchy
I'm working on a report which was never completed and the previous person did something I'm unable to replicate. The report displays data for different levels in a hierarchy (like a tree) starting ...
- 305
1
vote
1
answer
36
views
SSRS - EXPRESSION - HANDLING NULL VALUES AND LINEBREAK FOR AN CONCATENATED FIELD
I have a column that is concatenated; separated by a semicolon. I wrote an expression to check for null values and to get a line break at the semicolon. It is doing the right thing where there is data ...
- 37
0
votes
0
answers
99
views
SSRS-generated Word .doc files don't render correctly in MS Word 2505
SQL Server Reporting Service (SSRS) 2022 version 16.0.9276.19198 generates Word 97-2003 .doc files which can be opened fine in MS Word 2504.
Word 2505 doesn't display the same .doc files correctly, ...
- 1
0
votes
0
answers
44
views
How do I see the underlying reason a textbox displays #Error?
I am using the Microsoft RDLC Report Designer in Visual Studio 2022 to create SQL Server Reporting Service reports. When I enter an expression that doesn't have syntax errors but also fails to produce ...
- 16.2k
0
votes
0
answers
28
views
How to Show or Hide a textbox or table and create Expression to show or hide "Cases continued on Page 2"?
In this table I want to Add "Cases continued on Page 2" at the bottom of the table but if the table has more than 6 row this "Cases continued on Page 2" will appear. Should I put ...
- 125
0
votes
0
answers
41
views
SSRS RDL Report: Unable to Use Different Datasets in Nested Data Regions (List → Table/Matrix)
I'm working with RDL reports and trying to nest data regions using different datasets. Specifically, I want to use a List data region (bound to Dataset A), and place a Table or Matrix inside it that ...
- 95
2
votes
1
answer
43
views
I'm not able to get new data from the same SSRS report on Reporting Services when calling from a Blazor application. What should I do differently?
Here is the class I call from my Report Viewer component:
public class SsrsReportService
{
private readonly IHttpClientFactory _httpClientFactory;
public SsrsReportService(IHttpClientFactory ...
- 45
1
vote
0
answers
53
views
Report Builder PDF export – Excessive empty space on next page
I'm facing an issue with SSRS Report Builder when exporting to PDF. The report includes a table with column grouping and also without grouping, and here's what's happening:
What Works:
The report ...
- 21
0
votes
1
answer
22
views
SSRS LookUp Is not working with Snowflake SQL
I have a reporting where i am using the LOOKUP syntax to look for CALLS based on VQ names using Snowflake code, but it is not working so i was wondering if LOOKUP syntax is recognize in snowflake.
...
- 673
1
vote
0
answers
67
views
SSRS 2019 - How to Change Maximum Height of Parameters Panel?
Using a browser, we found that SSRS 2016's Parameter Panel has a maximum height of 100% for report generation. Using SSRS 2019, we see that the Parameters Panel has a maximum height of 40% with ...
- 461
0
votes
0
answers
87
views
Problem on Stored Procedure render SSRS reports by using Invoke-WebRequest -Uri cmd
I built a stored procedure to render a SSRS report and save it to a specified location by using a combination of SQL statement and batch cmd.
Below is the code:
CREATE PROCEDURE sp_renderSSRS_doc
@...
0
votes
0
answers
14
views
SSRS - XML Data Source works in preview but not in distribution
When using the report in preview mode my XML data source works correctly:
="<Query>"&
"<XmlData>"&
"<root>" &
...
0
votes
2
answers
144
views
Force Cells to be Unmerged when Exporting to Excel
I have created a report that uses a tablix to pivot the data. (Tablix in SSRS/PowerBI = crosstab or pivot in other systems) By default, the row groups and column groups contain cells that are merged ...
- 3,163
0
votes
0
answers
27
views
SSRS: Complex IIf expression returns #Error
I'm working in SSRS and trying to implement a complex expression to calculate a suggested order quantity based on available inventory, pending purchase orders, sales, lead time, and minimum order ...
- 226
0
votes
1
answer
25
views
SSRS Report Manager not returning dataset result
How can I return the expected dataset (stored procedure) results from SSRS report Manager? SSRS report Manager is returning a different dataset (stored procedure) result than what's expected from ...
0
votes
1
answer
48
views
Adding a Groupby to a Count(IIF in Report Builder
I have a report in SSRS, built using Report Builder 15
There is a Count column that uses this expression:
=Count(IIf(Fields!DataValue.Value = "Value1"
, Fields!Amount.Value
, Nothing)...
0
votes
2
answers
60
views
SSRS CSV export via PHP cURL returns incorrect encoding (e.g. "–" instead of "–"), but works when downloaded via browser
I'm using PHP with cURL to programmatically download SSRS (SQL Server Reporting Services) reports in CSV format. The download works, but the character encoding is off. For example:
Text that should be ...
- 71
0
votes
1
answer
35
views
How to create dynamic connection string in shared datasource in SSRS report(.rdl)
I have a requirement to create dynamic connection for SSRS reports where the connection information (Server & DB) will be worked out in c# code, so no interaction with end user selecting(Server or ...
0
votes
0
answers
36
views
Blank Values Needed in FetcXML
I am busy migrating a SSRS report, which uses SQL datasets, to use FetchXML datasets.
I have two datasets. A main dataset and a list dataset which provides me the list of Conflicts Checks.
I am trying ...
0
votes
0
answers
18
views
SSRS group sort based on numeric value
I have a report that is grouped by TFN dialed, year, quart, month & VQ name with an aggregated offered and AHT. The ask is to display the top VQ name with the highest offered value, but i am ...
- 673
0
votes
1
answer
36
views
SSRS URL in textbox does not work after export to PowerPoint
I have created a SSRS report with a line chart, above the line chart I have added a text box that is part of the chart, and added some text into the textbox.
I have set the action on the textbox to go ...
0
votes
0
answers
21
views
Use different font color and sizes in a placeholder expression
I have a text field for which I need the value to have two different font colors (based on field value) and two different font sizes. I created a text box and added two placeholders in the text box. ...
- 21
-4
votes
1
answer
48
views
Passing Parameters to a URL
Ok, been looking at examples and answers given for this problem and so far none of them have worked. I either get the parameters aren't being passed or an error.
I have an SSRS report setup where when ...
- 15
1
vote
1
answer
139
views
How to access SSRS Reporting Services information after upgrading from .NET Framework to .NET 8?
After using Microsoft's Upgrade Assistant to upgrade from .NET Framework 4.6 (Winforms) to .NET 8 (Winforms) in Visual Studio 2022, my solution did not automatically provide a package for the ...
- 956
0
votes
1
answer
107
views
How to display formatted Stored Procedure text in SSRS
I have had a request to display the text from a set of stored procedures in an SSRS report. I can easily get this from the system tables, but the issue is the user wants the text to be displayed in ...
- 3