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
Navigate to different report from one SSRS Report
Sent by you: I have a Invoice SSRS report, for that I have format(SSRS Report) A, B and C, I want when user looking at format A then user should be able to switch to other format, here format means other report. although it isworking fine in visual studio but when i added that report in CRM, it show this error: Details are not available because the subreport is missing. For help adding the subreport to Microsoft Dynamics 365, contact your Microsoft Dynamics 365 administrator.
Mimic excel report in SSRS using VS 2019
Hi All, I have a user who wants the SSRS report to look exactly the same as the current excel sheet. I have done my best, but I am stuck at the tail end. Hope I get some advice. The first screen shot is my SSRS Report using Matrix table (mimicking excel ). Until now I am good , now I need to add a calculated field Total=(casecount+casecount1), which should look like the second screen shot. Here the "Total" needs to be next 2024, Facility should be empty , the rest will be the same. I tried adding total to row group, column group and many more things nothing worked. Any advice? Thanks
Chart Series Label Format Issue
I have a chart with 1 series. I set the labels to have a format of 0.00%. When I run the preview or run the report, the output acts like the ".00" is a literal string to add to the number. So, it displays "18.00%" instead of "18.31%", for example. Is this a bug, or do I have my format string wrong? Thanks, Gregg
How to merge 3 rows
Hi All, I have a report when I export to excel must auto merge first 3 rows for columns (A to N), when the user opens the report , instead of the user doing it manually, is this possible. Please see the below screen shot. After exporting I manually did merge and center and named it, I want it to be it automated, similarly for columns B and C thanks
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
Connecting SSRS with snowflake as user viewing the report
As of now I am using the SSRS reports by connecting to my snowflake account by specifying the credentials or by using a shared connection. But now we should be able to view the reports with respect to each user by using the user specific snowflake account. So whenever a user logs in to the ssrs report, In the backed the queries should be fired from the current user snowflake account insted of using the shared connection or creds provided . Basically I want to use the feature shown in the image Need some help in setting the connection this way.
