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
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?Hide the Parent Group total
Hi, I am working SSRS table report. I have added a parent group at Row level and subgroup has categories and I have added parent group as Total. So for each subgroup it will display the total. Below is my SQL Query Result: I have added parent group at row level by group on the below expression: =LEFT(Fields!SubCategory.Value, INSTR(Fields!SubCategory.Value, ".")-1) It was giving expected result. However, if we have more than one value in subcategory then it should add the total else it should display the only category. After applying the above expression at group level, the result would be as below. For Women and Infant it is fine as we have subcategories and we need total women and total infants. But in Children category we won't've any sub rows. So, I need to ignore total Children row and result should like below. I tried to hide the total row by applying different conditions at group level but no luck. Thanks, MG
