Category "reporting-services"

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

Tabbed Reports in SSRS

I have been working on reports in Sql Server Reporting services and I am trying to create a tabbed report. I wish to have a main report which read in parameter

SSRS - Disabling export options (eg. PDF) for individual reports

We have many reports which we use on the website. While exporting some reports as PDF, the file size gets huge and the server crashes due to load. So it would b

A timeout (30000 milliseconds) was reached while waiting for a transaction response from the ReportServer service

I get the following error in EventViewer A timeout (30000 milliseconds) was reached while waiting for a transaction response from the ReportServer service. Di

SSRS fixed position of tablix in body of the document. Visual Studio

I have a set of two tablixes which I would like to have fixed in the position marked in red (Bottom of the body). I've tried to put them both in a rectangle but

ORA 01797- operator must be followed by any or all

I am testing a condition like this in the where clause of a subquery. But I am getting the error "operator must be followed by any or all" when I execute the SS

Report wont run when using OLE DB connection

I have an SSRS Report it works perfectly when I use Oracle data source. However, when I tried to connect using OLEDB connection I am running into some issues. 0