SSRS 2022 subscription - user can't enter a Comment
My user can create a subscription but if she tries to enter anything in the Comment field, she sees an error message "A delivery error has occurred". Looking in the log on the Report Server, I found this message: One of the extension parameters…
existing ssrs reports work however when we try to create a new or modify the existing file it won't work
existing ssrs reports work however when we try to create a new or modify the existing file it won't work. It throws the error Value does not fall in the certain Range Database using - Postgres SQL Connector - PGNP OLEDB Provider This issue happened even…
Can SSRS 2019 consume data from databases on SQL server 2022?
Is is possible for SSRS 2019 to consume data from databases created with SQL server 2022?
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…
HSTS for Default page on SSRS
Hi, Our SSRS server is failing a vulnerability (Nessus) scan for HSTS. I have been able to add the SQL CustomHeader for HSTS and I can confirm this is working. SQL CustomHeader XML string…
SSRS Dataset using #Temp Tables
I could have sworn I have done this before. I have multiple Datasets in my SSRS .rdl. The first Dataset creates the #Temp Tables which subsequent Sub-Reports and SQL Server Stored Procedures and Datasets utilize. Also, utilizing the Use single…
Powershell script to report user OneDrive site collection
Good afternoon, I’m looking for help with scripting a report to show all users OneDrive Notebooks storage usage. I’m aware of the usage reports in admin, but I would like to drill down further to the users site collection for notebooks. The reason…
SQL Server 2022 Kurulum Hatası
Microsoft SQL Server Geliştirici indirip 3. seçenekten Basic olanı seçtim. Ekran Görüntüsünde görüldüğü üzere bu hatayla karşılaştım.
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…
How to install Report Authoring Extension in Visual Studio Community 2022? Tried all methods available on Blogs.
How to install Report Authoring Extension in Visual Studio Community 2022? Tried all methods available on Blogs.
Deploying dashboard to power bi report server using power shell script
when try to execute the above query it's showing the Failed to create a session to the report server. Could someone please help to this issue. Actually I try to deploy the power bi report server dashboard with power shell script.
SQL 2018 SSRS not able to display X-Frame-Options set to sameorigin
Hello All, I am facing an issue where our web app is calling sql server and it was all working fine until we used ssms 2012, Now we have upgraded to sql server 2018 and now I am not able to embed my ssrs report in web page. It says refused to connect to…
has inline function got any catch?
hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have to…
Need to filter data in Tablix
I have created a tablix where I need to filter the data, I have used the following expression in the Tablix properties and I am not getting the expected results IIf(IsNothing(field1.Value) OR IsNothing(field2.Value), 1, 0) The above formula is…
Maps in SSRS coming back with status 401: Unauthorized
We have reports written in SSRS that have Map components in them. They have been working well, but recently they have been producing intermittent 401: Unauthorized and not displaying the base map layer (Bing map imagery), see the attached image. No…
SSRS not available in Azure VM with SQL Web version
SSRS not available in Azure VM with SQL Web version
SSRS stops exporting to Excel
We are having a weird issue with SSRS where by reports stop exporting to Excel from time to time. We are using SQL 2016 standard, SP2 Every few days we experience this and sometimes multiple times in a day. The report runs to screen without issue but…
SCCM Report issue
Dear All, Could you please assist with the issue I'm encountering in Report Server Configuration Manager? I have configured the Report Server Configuration Manager, and both the web service URL and web portal URL are working fine. However, I can't find…
SSRS Report 2014- Dynamic Image Pagination
I have a report in SSRS 2014 that has Tablix table with dynamic images being populated from a SQL stored procedure (url's). When I view the report I can see all the images in the right order... basically ex: Accessible route 1 scrolls all the way to…
Why does SSRS Report Viewer control render error on some machines?
Using ReportViewerControl 150.1449.0 to render SSRS (rdl files) in a Delphi application Click the report from the Delphi application and it opens the parameter box. Enter in parameters and it renders results on working machine. Click the report from…