Forum Widgets
Latest Discussions
Shared schedules getting set to expired
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
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
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
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 adviseSSRS Use Excel WorksheetFunction.Round method in custom code
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. ThanksSQL Report Builder rendering error.
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 TimSSRS-generated Word .doc files don't render correctly in MS Word 2505
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
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 ?
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
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?
