Questions tagged [reporting-services]
SQL Server Reporting Services (SSRS) is a server-based report generator from Microsoft. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization.
reporting-services
25,618
questions
-4
votes
0
answers
22
views
Using "openpyxl" Excel lib. With Python [closed]
Currently I am Using openpyxl Lib with Python to Generate and customize Reports as a task for my job, for a small scale it works fine,
but when dealing with lots of Rows and Columns and more sheets or ...
0
votes
0
answers
7
views
How do I write an IIF based on value in group summary
Im using a date dimension table to populate a 'calendar' of days...from today for a full year. It pulls inbound and outbound shipping quantities that are scheduled on any particular day and lets the ...
0
votes
0
answers
15
views
SSRS Powershell Rest API "The given key was not present in the dictionary"
I am trying to create a subscription to a report via SSRS Rest API 2.0, but I am getting the error "The given key was not present in the dictionary".
I am on SSRS Version 15.0.8863.19101 ...
0
votes
1
answer
29
views
Is there a way in SSRS to only display specific parts of a report when rendered in MHTML, vs when it is rendered in the Report Viewer?
I have created a fairly long SSRS report which is to be sent out daily via email and embedded in the email in MHTML format. The whole report is not necessarily needed for the email however and we'd ...
0
votes
0
answers
29
views
Query Designer - SSRS Report - Restrict Parameters by Other Parameters
We have a report in SSRS build using query designer that lives on top of data that comes from the data warehouse. The set up looks like this.
How do I restrict one column by another column. Only ...
0
votes
0
answers
9
views
I want to represent my data in SSRS based on certain grouping. It should be visible like grouping should be in top and then data is shown below
As shown Field- contains group Name and then data is followed by the particular groupName
I tried adding a table and giving my data and did grouping based on my group name it became like this
after ...
1
vote
0
answers
38
views
How to Remove 'Select All' Option in SSRS While Allowing Multiple Values?
I'm working on an SSRS report where I need to allow users to select multiple values for a parameter. However, I want to hide the default "Select All" option that appears when "Allow ...
0
votes
0
answers
18
views
Groups and Group totals in Paginated Report
I am working on a Paginated Report by using data source as Power BI dataset. I was trying to create group on below columns and add the totals to each group.
Vendor
CategoryCode
SubCategoryCode
...
-1
votes
1
answer
30
views
Trying to add sum in one of a column in SSRS table Report
Employee ID
Full Name
Credit Loss
FTE
1
ABC
13.55
1.00
2
XYZ
9.55
0.60
2
XYZ
9.55
0.80
3
DEF
3.44
0.55
4
GHI
6.66
1.00
5
JKL
12.44
0.45
5
JKL
12.44
0.55
Basically, I have these 4 columns, all ...
-1
votes
0
answers
27
views
SSRS Report #error displayed in the table
Severity Code Description Project File Line Suppression State
Warning [rsAggregateOfInvalidExpressionDataType] The Value expression for the textrun 'Textbox8.Paragraphs[0].TextRuns[0]' ...
0
votes
0
answers
34
views
SSRS Subscription Jobs in AG
We use SSRS (SQL Server Reporting Services) for reporting purpose.
The report server is part of AG (Availability Group). We have one primary and three secondary servers. When we create an SSRS ...
0
votes
1
answer
19
views
PBIRS 2023 data driven subscription is causing error in XML?
An error has occurred.
The input XML does not conform to the schema. XML grammar is described in the API documentation. For XML in reports, refer to Report Definition Language syntax.
This error ...
0
votes
0
answers
26
views
SSRS Rest API Error "The definition of this report is not valid or supported by this version of Reporting Services."
I am using powershell to upload a RDL file to a specific folder in a SSRS instance (SQL Server 2019 Reporting Services Version 15.0.8863.19101)
$sourceItemPath = 'C:\Temp\ReportFolder\Report.rdl'
...
0
votes
0
answers
23
views
Filter rows based off selected date for Paginated Report/SSRS to get a historical snapshot of what the org looked like at that selected time
I have a table of employees summarized like below that is connected to a Power BI dataset. The business is asking for an exported paginated report to be able to filter this data to a certain date to ...
0
votes
1
answer
18
views
How do I add an additional value to a SLECT DISTINCT
I have a parameter in SSRS that uses a query to retrieve a list of values.
SELECT DISTINCT LTRIM(RTRIM(user_def_fld_5)) AS user_def_fld_5
FROM imitmidx_sql AS IMITMIDX
What I need to do is ...