SSRS , I am trying to make a table where the first row will be a aggregate value and remaining rows should be displayed as such from the \DB For Example :
I've used the join function to create a string out of an array of variables. =Join(Parameters!Variable.Value, ",") Let's say that the expression is using a par
Objective: Pull report usage statistics from MS SSRS ReportServer database. Then, link to another table in a separate database (same server) to pull in employee
This query is Based on the example in this Link https://www.sqlshack.com/using-multi-value-parameters-in-ssrs/. Let us assume that I have several Job Titles in
I have written the code to create the subscriptions by adding the reference to ReportService2010.asmx. Please see the below screenshot for code and result [Id =
I have a Power BI dataset as a data source to a paginated report builder. This dataset when display on a table, it looks like below This is a column picker rep
Azure SQL Database supports Full recovery model and we can't change the recovery model of Azure SQL Databases. As mentioned here while making
I keep getting an error [, is invalid. InvalidSyntax] when deploying this report in Visual Studio. I can't find the incorrect [ , ], also not sure if the bracet
I have created two SSRS reports within a Report Project using VS 2019 and they work fine. When I create a third report using the same procedure and attempt run
I'm trying to set a report in Report Server (SQL Server 2017 Reporting Services 14.0.600.1669) that use the Windows credentials of the user who is viewing the r
I try to connect to the SSRS REST API via NTLM and cURL, but the authentication fails. Here is my attempt: λ curl --ntlm -v -u localhost\osain http://loc
In reporting services I have reports which contains links to attachments: -When i using IE11 and clicking links everything is working fine -but when i do the sa
How to get the last year ytd vs the same months current year ytd in ssrs. Example, If my current year ytd is from Jan to March 2022, my last year ytd should be
I am trying to configure the SQL Reporting Services (local 2016 installation) but get this exception when I open the configuration manager and enter my host nam
I am trying to create a report table in SSRS 2016 but I am not sure how to go about it or if it is possible. I am trying to recreate something similar to that
I'm trying to have a dynamic color for some objects in my report (font color, background fill of text box etc.). I was trying to get it from either Parameter or
I have a requirement to show the static text of my report in different language. Steps that I am following: Create a url with query string parameter with Cultu
I have a report with a column displaying time cumulatively overshooting 24 hours. I'd like it to be displayed in hours. I've found a solution that when time exc
I am working on an SSRS report and a part of my sql query is like WHERE SuperVisorId IN (@SupervisorIDs) AND CreatedDate> @StartDate where the @SupervisorID
I am setting up SSRS data driven subscription with windows file share delivery option. In regular SSRS subscriptions with windows file share delivery there is