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 advise
SSRS 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. Thanks
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
Fixed Rectangle or Table
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
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 Measure aggregation
Hi community, It is my first post, so I'm working with report builder, I have a semantic model on power bi service so the report is live connection. In the model I have the dimensions and measures: dimension: Country, city Measures: stock, orders, avg sell this ultimate is actually: function ( orders , stock ). So in the report I summarized the measures with total. So the Sum function measures are OK, but the avg sell NOT(aggregation) the values are wrong, so which aggregate should be work? if the measure is operation between orders and stock Is it possible to use measures predefined in model? or do I have to make a custom measure in report builder (expression) ? thanks in advance.Authentication error when refreshing SSRS 2019 report
We are encountering authentication issue when refreshing the report in SSRS web portal. Report Server is configured to run using Virtual Service Account. In the RSReportServer.config file, RSWindowsNTLM authentication type is used. The report is connecting to the data source (internal product) using custom ADO.NET Data Provider. Data source is configured with "As the user viewing the report" credentials. Test connection works. When the user opens the report for the first time, report opens successfully. In our product log, we see that the connection was made using logged on domain user account. When the user refreshes the report after some time (3 minutes), report fails to load due to authentication error. In our product log, we see that the connection was made using service account (machine account of the SSRS server) and authentication fails because the service (machine) account is not allowed to access our product. The same configuration works successfully in SSRS 2016. Not sure why the report in SSRS 2019 is connecting to data source using service account instead of logged on domain user account even though it's configured to use the user account viewing the report. I have experimented with RSWindowsNegotiate and EnableAuthPersistence in RSReportServer.config. The issue still exists. Any help/guidance would be appreciated.
Backup and Restore of Native SSRS Site Restores as Sharepoint mode
I tried posting a similar message a couple of days ago but am not seeing it on the forum. As such I am reposting. I have a customer with an SSRS site that was setup with their original Dynamics GP implementation. We are in the process of moving them to a new server and upgrading GP. As part of the switch the reporting services site must also move over. I looked at their current Reporting Services Configuration manager and it showed setup in "Native" mode. But when I restored the database and attempted to set it up on the new server I received a message saying the database was in Sharepoint mode. Is there a way to set it up in Native mode? JG
ODBC driver problem
After changing the Microsoft Access Engine odbc driver from version 14 to version 16, I cannot connect to the excel file. I have a connection as follows: Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path.xlsx;ReadOnly=1;HDR=No; error with this is: ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks When switching to the OLE DB driver I get the error: Unspecified error On the Microsoft Access Engine version everything works fine. SSRS: Version 13.0.7050.2