All Questions
Tagged with microsoft-reporting or reporting-services
25,608 questions
0 votes
0 answers
44 views
How to create/update .rdl file in Visual Studio 2022
I want to update multiple reports for my project. Currently I am able to update the report using visual Studio 19, but I need to use Visual Studio 2022 to create and update the reports. Also for ...
Advice
0 votes
1 replies
27 views
SSRS Report External UNC Image File - If Not Found - Default Image
In my dataset for an SSRS report, I have a column that is comprised of a path and a file name of an image, dynamically created by each user's user id, as that's how the images for their pics are ...
0 votes
1 answer
53 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 ...
1 vote
0 answers
53 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
67 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
31 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 ...
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
84 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(...
0 votes
1 answer
45 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 ...
0 votes
0 answers
32 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 ...
0 votes
0 answers
39 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 ...
0 votes
0 answers
30 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....
0 votes
0 answers
35 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 ...
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 ...