Category "reporting-services"

SSRS Nested IIF statements in expression throwing error

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

Get (Exception from HRESULT:0x800300002 (STG_E_FILENOTFOUND)) when running a new SSRS Report

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

SSRS - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - As user viewing the report

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

Connection to SSRS API via NTLM : handshake rejected

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

Links from internet explorer 11 not working in edge

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 ytd last year up to the same months this year in ssrs

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

SQL Reporting - No report servers were found

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

Time Flow Chart in SSRS (2016)?

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

Why SSRS colour from expression is not working?

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

How can we pass url parameter to rdl file?

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

How to display time in hours overshooting 24 hours in SSRS

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

SSRS avoid WHERE clause if select all is selected

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

SSRS Data Driven File share account - impersonation error

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

Reporting Services - show multiple values for a column horizontally rather than vertically

I have a report where row data can have the same data, apart from the data in the last column. Just adding the data to a table results in this: Column 1 Column

The version of the report server database is either in a format that is not valid, or it cannot be read

I had an SQL Server 2012 database instance installed on server A. I then installed SSRS 2016 only (not the the complete SQL Server 2016) on server B but point

SSRS Tablix border size inconsistent

I am using a totally standard tablix table (no embedded sub-tables or anything) in a SSRS report with a 1pt solid border around all cells which looks as I would

Setting a list of several values to one SSRS parameter in "Available values"

I have an (integer) multi-value parameter in my SSRS report. The "Available Values" for this parameter are currently gotten from a query returning an integer fr

SSRS Reporting in Blazor

Has anyone had any success with integrating SSRS reporting with Blazor? If so how and what did you use? I would like to utilize my existing rdl files in Blazor

Strange issue in SSRS 2016. I am unable to select parameters or run the report intermittently, it works fine most of the time

I am having a strange issue with SSRS 2016. We setup a new server and uploaded some reports, the reports ran fine for few days. The issue is, randomly the repor

SQL server report error - "rsInternalError"

When I try to access the Report Server (or open up a report), I get the following error, An internal error occurred on the report server. See the error log fo