SQL19 express installation Error
I'm trying to install 'Microsoft SQL Server 2019 Express' with below steps: Used Custom Installation step From SQL Server Installation Center: I've selected 'New SQL Server Standalone installation' In the feature selection, I've selected a.…
Microsoft (R) Visual Basic Compiler asking the upgrade the version.
We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…
How to get Page number in RDLC body
I need to read page number in RDLC body. Based on page number value, I need to display subtotals from table. I'm using Visual studio 2008 designer for RDLC design.
Compiling SSAS, SSRS, and SSIS projects under Build Tools for Visual Studio 2022?
I have a build server using Build Tools for Visual Studio 2022 to compile projects. We have several systems that are currently not using the build server because they use SSAS, SSRS, and SSIS projects. Investigating, it looks like Build Tools does not…
Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)
After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…
After upgrading PBIRS to jan 2023, can't use report server configuration manager "Provider load failure"
Hi, I upgraded Power BI report server to the latest version (January 2023), after that I launched the report server configuration manager, I have the server name which is the name of the server where PBIRS is installed but the instance field is grayed…
SSRS Report Server 22 Native Scale Out with a network Load Balancer not working as expected.
I have setup a 2022 SQL Instance. Using the DB from a 2012 r2 instance. I have looked over documentation. I can only get the last report server joined to the instance to display the webserver and the reports server. Example node1, 2 and 3 were installed…
Connecting Azure web app service (.net8) to SSRS on Azure VM by using private DNS
My azure web app service(.net8) connect to SSRS on VM by using the private DNS name provided by Azure to the VM, but my credentials did not work when I run the report on my azure web app server. The private DNS name works fine with my credentials via url…
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
SSRS UnhandledReportRenderingException
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). When we…
Is It Possible To View Which Users Belong To Which Security Group In SSRS
Hi I am new to Sql/SSRS and I have been looking at security roles. It looks like the secrity roles are applied at group level. I was wondering if there is a way I can tell which users belong to which security group from the reporting server. If it is…
Why isn't code working as an expression for parameters in SQL Server Reporting with connection to Databricks SQL Warehouse using Simba Spark
Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)…
Reporting Services logs and database tables
hi all, Do the RS logs and various log database tables contain the same information? I have no access to the admin page for the production environment RS, however I am responsible for fixing issues with reports being scheduled in that…
Microsoft.ReportingServices.ReportViewerControl.WebForms version 150.1404.0 returns invalid HTML for Reserved.ReportViewerWebControl.axd?ResourceStreamID=Blank.gif
The HTML returned by the reporting services viewer is missing the " at the end of the src attribute. It's resulting in: <img…
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
does report builder work with AWS RDS MySQL database instances
Hi, I am trying to use ms Report builder with a AWS RDS MySQL database, but am struggling to set up the datasourse. Can you help ? Thanks
why ssms 20.1 Cannot Open ?
Why my ssms 20.1 that was downloaded on 04/14/24, always run the same popup page message as in the attatchment ? if i choose repaired and wait it finishes and then reboot the computer, the same popup message pops again. Even that I have uninstall the…
Which .NET Framework versions can be used for installing Microsoft Report Builder
My question refers to this page: https://www.microsoft.com/en-us/download/details.aspx?id=53613 I need to install Microsoft Report Builder. According to the install instructions, it says .NET framework version 4.6 needs to be installed first. If I…