SQL Server Reporting Services topics

Shared schedules getting set to expired

chuckh1958 — Tue, 07 Oct 2025 18:28:00 GMT

SQL 2019 , SSRS 15.0.1102.675 native mode.

Does anyone have a solution to this problem? It started about 3 weeks ago after the server was rebooted. The SQL instance came up but the Agent timed out and was down for a few days before anyone noticed. I restarted the agent but since then any time a report or subscription runs from any shared schedule, it runs one time and then the schedule gets set to "expired" even though there is no stop date for the schedule.

SSRS Report Input Validation

sumesh22 — Thu, 25 Sep 2025 15:58:19 GMT

Hi Team, currently our webportal was tested by the security team and they have opened a ticket saying the SSRS report called within the webportal in vulnerable to Input validations and are saying that Cross-site scripting vulnerabilities arise when data is copied from a request and echoed into the application's immediate response in an unsafe way. An attacker can use the vulnerability to construct a request that, if issued by another application user, will cause JavaScript code supplied by the attacker to execute within the user's browser in the context of that user's session with the application. Could you please help how to resolve the same. As we are only passing SQL parameters to the SSRS report how can we validate these.

Font Issue in SSRS Report for Microsoft Dynamics CRM v9.0 On-Premises

rchaar — Sun, 14 Sep 2025 09:48:54 GMT

Hello,

I’ve developed an SSRS report for Microsoft Dynamics CRM v9.0 (on-premises) using SQL queries. The report functions correctly overall, but I’m encountering an issue with the font rendering.

The report is designed to use "DIN Next LT Arabic". When I run the report using the CRM Report Viewer or directly from SQL Reporting Services, the font displays correctly. However, when the report is generated from within CRM or the SSRS server, the font is replaced with a different one.

Troubleshooting Steps Taken:

I tried using SSRS expressions to explicitly set the font.
I verified that the font is installed on the SSRS server and CRM server.
Installed PDF X

Despite these attempts, the issue persists.

Noting that Font package has been installed on all the Server - Local C >> Windows

Has anyone encountered a similar font issue in SSRS reports for Dynamics CRM v9.0 on-premises?

SSRS.csv Export Issue

Sandeepguptasg — Sat, 13 Sep 2025 20:35:22 GMT

We are currently facing an issue with the CSV export functionality in SSRS reports-both through manual export and via subscriptions. Specifically, the column headers in the exported.csv file are not matching the header names defined in the report layout.

For example, a column labeled "Customer Name" in the report layout is appearing as "Customer_Name" in the exported CSV file. This discrepancy is causing challenges in downstream processes that rely on consistent header naming.

Due to access limitations I can not make changes to server config file so I am looking for help on report level solution or advise

SSRS Use Excel WorksheetFunction.Round method in custom code

bvuHH — Sun, 06 Jul 2025 19:18:58 GMT

Hi,

I'm trying to implement a custom code function to be used in an expression of my SSRS report but I'm unable to get it running.

Here's what I have so far:

Report Properties - References:

Assembly Microsoft.Office.Interop.Excel, Version=15.0.0.0

Report Properties - Code

Public Function fRunden(Wert as Double, Dec as Double) as Double Dim excelApp As New Microsoft.Office.Interop.Excel.Application dim roundval as double roundval = excelApp.WorksheetFunction.Round (Wert, Dec) Return roundval end function

In the Tablix Textbox I've added the following expression:

=Code.fRunden((sum(Fields!Hours.Value,"GroupDataset")/sum(Fields!Hours.Value,"TotalDataset"))*100,2)

Howerver, rendering the report results in #Error in the textbox

From the Microsoft language documentation the WorksheetFunction is implemented as an interface.

So I'm not sure if I correctly use the objects in my custom code.

Any help is greatly appreciated.

Thanks

SQL Report Builder rendering error.

TimMaslin — Tue, 01 Jul 2025 08:51:54 GMT

Hello

Recently a colleague who uses Report Builder regularly has been getting a weird error when the reports are rendering properly. He thinks it's since his laptop has completed some updates.

I've attached a screen shot as an example. We know that this doesn't appear to be a system issues as other users are not reporting any problems. From looking at the screen shot it's almost like the report is out scale.

Thanks

Tim

SSRS-generated Word .doc files don't render correctly in MS Word 2505

ZoltanTakacs — Thu, 12 Jun 2025 21:12:22 GMT

Hi All,

SSRS 2022 version 16.0.9276.19198 generates Word 97-2003 .doc files which can be opened fine in MS Word 2504. Word 2505 doesn't display the same .doc files correctly, the document layout is off.

Is there a version of SSRS that generates Word .docx version 2007 files?
Alternatively, is it possible to correctly display Word 97-2003 files in Word v. 2505?

Thanks!

SSRS Subscriptions "To" Field Not User Email

jdcollier136 — Fri, 06 Jun 2025 18:21:42 GMT

Hi, I know this has numerous other posts, but I could not find crystal clear, satisfactory answers in any of them.

SSRS 2019

When a user subscribes to a report in SSRS, the "To" field is pre-populated. However, it is pre-populated with their username, not their email. In our case, the username is part of the email, e.g. "email address removed for privacy reasons". I tried altering the SendEmailToUserAlias attribute in the rsreportserver.config file, but changing this to False merely makes it editable, and we don't want it to be editable. We want the email to show up. (If it is editable, users could have control over the email a subscription it gets sent to, and the point of the feature is for them to be able to set up subscriptions for themselves.)

(Mine does let me edit because of elevated permissions, but "To" is appropriately greyed out for standard users)

Changing the DefaultHostName attribute doesn't seem to either update the pre-populated email nor does it seem to constrain the domain to which emails can be sent (which could maybe be okay if we really couldn't get the true email pre-populated, but isn't desirable either). I put the same host name that is used in Report Server Configuration Manager for the sender address, which is on the same domain as user email addresses.

In AD, the userPrincipalName is the full email address. The only attribute that seems to have just the username is sAMAccountName - is this indeed what SSRS is pulling from? I would rather not have to change this attribute, but I might be willing to if it meant that users could subscribe to emails themselves automatically.

Is there really NO way to have the "To" field pull in the users email address?

What are the risks associated with JavaScript hyperlinks on SSRS ?

Ian_Tseng — Fri, 02 May 2025 01:35:27 GMT

Hi everyone,

On January 6, 2025, Microsoft set the default configuration in SSRS so that the SupportedHyperlinkSchemes property no longer supports JavaScript.

My questions are:

1. Specifically, what are the risks associated with JavaScript hyperlinks on SSRS ?
2. Does this change affect only hyperlinks? Will other uses of JavaScript in SSRS be impacted as well ?

Thanks in advance,

Ian

Cannot Change Service Account After SSRS Migration

Jon_Howes — Fri, 14 Mar 2025 13:50:01 GMT

Apologies if this is posted in the wrong place.

Following the migration of a Report Server Database to a new server, i have imported the SEK and the SSRS website appears to be working as expected, but i need to change the service account from the default.

When i try to change the user and enter a location and a password for the Key file it then asks for administrator login credential for "applying grant rights script for the new windows service account", even though i am an administrator on the server and in SQL If i click OK i get a message saying

Report Server Configuration Manager

A connection could not be established with the information provided Hit OK to change your connection settings

A connection was successfully established with the server, but then an error occurred during the login process (Provider:SSSL Provider, error 0 - The certificate chain was issued by an authority that is not trusted)

Can anyone advise on how to resolve this?

GO To URL Action - Pass Parameters SSRS

Bochmelko — Mon, 24 Feb 2025 22:05:46 GMT

Hello!

I am trying to use the Go To URL action to open up another report and also pass the parameters stipulated by the user in the "Parent" report to the "Child" report.

I added the code below to a text box on the main report and it opens the Service Call Proposal-TAGR report successfully. Now I just need to pass the parameters in the URL as well and I don't know the syntax for doing that. Any help would be appreciated. Thanks!

javascript:void(window.open('http://sql-server11/Reports/report/TRC/Signature Service/Service Call Proposal-TAGR' ,' _blank'))

Where clause that looks up values from an outside source, using Report Builder in SSRS

kwoltman5157 — Mon, 24 Feb 2025 19:44:03 GMT

First off, I apologize if this is posted in the wrong place, but I didn't see anything that was dedicated to Report Builder.

Secondly, I'm in Finance and understand some level of SQL reporting so please bear with me on this question. I also realize that being within the corp walls, that my ask here might be something that I may not have permission to do, but I won’t know for sure until I attempt this.

I use SQL Server Management Studio 19.3 to create my queries. Once I have my query where I want it, I launch Report Builder from SSRS. I do not see a version # for Report Builder. I copy my query into the SSRS report and then publish it (save it, etc).

Example data:

Table 2 has a field called “Username”

I write lots of queries that ultimately end up being SSRS reports that rely on Table 2/Username. Many of these queries I hard-code in a list of Usernames. So, say I have 10 SSRS reports already created but then in the future the list of Usernames changes. It’s a pain to update all of the different queries/SSRS reports.

Say my query looks something like this:

Select t1.ID, t1.Field1, t1.Field2

From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID

Where t2.Username in (‘Username1’,’Username2’,’Username3’)

Is there a way to have the above WHERE clause look at another table where I store the values ONE time? Where I can manage that list of Usernames in ONE place? Basically ending up with something like the following?

Select t1.ID, t1.Field1, t1.Field2

From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID

Where t2.Username in Table3/External Source

If so, I would appreciate any insight on how to accomplish this. The more detail the better as I am a novice at this.

If you need more info, please let me know, but I believe this should cover what I’m after.

go to file Url, extended ascii gets converted

RBiems — Tue, 18 Feb 2025 13:33:15 GMT

Hi all,

I have a textbox action 'go to Url' that has links like

\\Myserver\Documents\Documents_Uploaded\Czekański DOC01_169645.pdf

When this link is clicked and the browser is opened (tried it with Edge, Chrome) the link is converted to

\\Myserver\Documents\Documents_Uploaded\CzekaÅski DOC01_169645.pdf which doesn't work obviously.

all extended ascii characters seems to be converted to some other extended character when the browser is opened, can I prevent this conversion from happening, in other words just accept to string the way it is?

And just to make clear when there are no extended ascii characters in the string it works as intended :-)

I tried the System.Uri.EscapeDataString(URL) and System.Web.HttpUtility.UrlEncode(URL).ToString
some sites suggested but that doesn't work for files locations only for web urls

Thanks in advance

Rbie

Fixed Rectangle or Table

SSRSUser2025 — Mon, 17 Feb 2025 14:11:34 GMT

Hello All,

I have a need to put multiple tables into a single report. Issue is that some of these tables can grow up to 2 pages or more pushing all the other tables into different pages. I want it somewhat like a dashboard where users can view all the tables/tablixes in one page and have the ability to scroll up/down and right/left. In order version of Report Builder, I recalled that rectangle you can set it to fixed size and place multiple tables in one page without having it push into multiple pages. However, it's been a while since I use Report Builder and do not see this option any more with newer version of Report Builder. Anyone have any suggestions how to get it to work similar to what I'm looking for?

SSRS Report Rendering Issues via ReportExecution2005 API

seylim — Fri, 14 Feb 2025 15:14:28 GMT

Hello everyone,

We are encountering intermittent issues while requesting PDF renders of large SSRS reports from our SSRS server using the ReportExecution2005 API from a .NET 6 backend. While this generally works, we occasionally run into unexplained failures.

For example, we have a report with approximately 47,000 pages. Every time we attempt to generate this report, the process fails after about 17.5 minutes. Examining the ExecutionLog and our own logs, we can confirm that:

The data query executes successfully
Report processing completes without errors
The rendering process runs for a few minutes before the SSRS service throws an error, terminating the connection with our backend

The ReportingService log file contains the following error:
System.Threading.ThreadAbortException: Thread was being aborted.

Additionally, ExecutionLog3 lists the status as: rsInternalError

Since this issue consistently occurs around the 17.5-minute mark, we initially suspected a timeout and increased all possible timeout values. However, this had no effect.

Interestingly, when we restart the SSRS service, the PDF sometimes renders successfully, taking about 40 minutes to complete. After that, all subsequent requests again fail with the same error.

This raises a few questions:

If the report sometimes completes successfully, can we rule out a timeout issue?
Memory usage remains well below the configured limits, and we can manually request and render multiple large reports simultaneously without issue.
Is there any known SSRS behavior that could cause this repeated failure over time?

As a temporary workaround, we’ve set up subscriptions to trigger SSRS to render the PDF independently, but we would prefer to resolve the API issue so we can use our direct request approach.

Has anyone encountered a similar issue or have insights into what might be happening?

Thanks in advance!

SSRS Subscription

MPelley — Wed, 05 Feb 2025 13:46:42 GMT

Hello~! I am trying to set up a subscription for one of my reports. I don't know what it means when it asks for this:

Any thoughts, please?

Thank you.

SSRS Styling parameters

Ominousdragon — Fri, 24 Jan 2025 13:56:05 GMT

Hello, I am encountering an issue or possibly a limitation of SSRS. I am trying to have parameter "A" be greyed out or hidden based off of the value inputted into parameter "B". Currently I am using cascading parameters to display different values in param "B" depending on param "A" inputted value however would it be to grey out or hide param "B" based off of the value of param "A"

SSRS Report with multiple parameters but can only use one

kcroteau79 — Thu, 23 Jan 2025 21:40:45 GMT

Hello All,

I have a report I am creating that has two parameters that can be used, but only one of them can be used.

If parameter 1 is used then I need parameter 2 to automatically select the empty value. If parameter 2 is used than parameter 1 will select the empty value.

Is this possible?

Thanks

Crote

SSRS error on sign in ERR_UNEXPECTED

jayvee — Tue, 21 Jan 2025 10:32:38 GMT

Hi All,

I have an error coming up when anyone tries signing into our company's Report Server Portal. The error appears for one or two seconds and then the portal starts loading successfully.

This is from an Azure VM running Windows Server 2019 Datacenter. Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64). SSRS SQL Server Developer edition 15.0.1102.675.

Below are links to log snippets from one of the attempts at signing in. This error occurs for all users and only on sign in, not while trying to run any reports. At the time of testing the issue, there were no other processes running or users running reports.

RSHostingService log snippet
RSPortal Log snippet

Any guidance or tips would be greatly appreciated.

Thanks

Reporting Functionality | Power BI paginated Reports| SSRS

shank89 — Sat, 11 Jan 2025 15:08:11 GMT

Hello,

I need to create a report on Power BI paginated report which is similar to SSRS ,where I need to show a report as given below.

From the report which I have created got the result as below.

Now I need to generate a new column called TestNo column which need to be included in my result shown above. But it should be based on SDIDATAITEMID value which I have shown above. It should give me the values as

TestNo

8043366 - 1

8043367 - 2

8043368 - 3

8043369 - 1

8043370 - 1

8043371 - 2 ,.... Likewise....

I can provide more info if someone could help me here.