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,614
questions
0
votes
0
answers
15
views
Azure VM: SSRS data driven subscription intermittent error
I have Azure VM database which I use as a source for my DB Source. My SSRS server generates Data Driven report emails out of this db and always have intermittent problems while running my process (...
0
votes
0
answers
15
views
SSRS subscription parameters storing numeric values instead of names
I am working on extracting the subscription parameters from the SSRS report server DB. I have parsed the XML out so that I get the parameter name and its value. See here. However, a lot of the values ...
0
votes
0
answers
23
views
Is there a way to get a RunningValue using a ReportItems! value?
I've created a report that tallies inbound and outbound shipments and conditionally adds an expected monthly usage amount IF the outbound shipment value is 0.
Report
The 'Last Day of Month Allotment' ...
0
votes
0
answers
16
views
MS Report Builder : Group totals are false due to the join in my dataset
I'm designing a report in Report Builder (with Business Central) and I'm having an issue when working with a temporary table.
I have a dataset of two dataitems. The first dataitem is my production ...
0
votes
1
answer
22
views
How can I get Hebrew formatting (rtl) for my .rdl report
This is one of many text boxes, and I can't get this to properly format the text left to right.
="<span style='direction:rtl !important; text-align:right !important; font-family:Roboto !...
0
votes
0
answers
38
views
WPF - Async SSRS Report generating using WindowsFormsHost
I have helper static method to "automatize" generating SSRS reports
public static WindowsFormsHost CreateSSRSReport(string reportServerUrl, string reportSystemName, string reportPath,
...
-5
votes
0
answers
33
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
20
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
33
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
30
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 ...
-1
votes
0
answers
11
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
45
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
25
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
33
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
28
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]' ...