SQL Server Reporting Services

How to see reason code of stock adjustments

How do I generate a report where I can see adjustments to the Item Ledger Entries and the reason code used to adjust the items?

Alternatives to Crystal Reports for .NET compatible paginated reporting tools?

We're looking at tools for creating paginated reports. We have a couple of parameters: There needs to be up-to-date .NET libraries so we can have run the reports via C# wrappers in our code. Allows for pulling data from SQL Server We're…

How to stop my query editor from closing on its own

I'm constantly getting a pop up asking me to save queries I am still working on. Sometimes I open an instance that has been idle just to realize the query I had open has been closed or disappeared. Plus I have checked the copy with header option in the…

AdventureWorksDW2020 DB is missing a table

Hi, I'm trying to go through the PowerBI lab at this url: https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare I downloaded the AdventureWorksDW2020 from GitHub and loaded into SQL server management studio. 6 tables are…

How to access the accounts under SSRS Builtin\Administrators

PowerBI Report Server can't connect sql server (basic auth) in Direct Query Mode

I'm trying to connect to sql server using basic auth in PBIRS Direct query mode, it pass the connection test but when I open the report I get "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string…

Please advise if the system is down or if there are any reporting of an issue. I am getting this error message below-

clone a report

Can I clone a report in ssrs? Need to make a copy of a report where both reports will change when a report is uploaded.

Can I create a variable in my report to compare values?

I have an SSRS report that shows student grades. The user can choose to group the results by major, degree, instructor, etc. I need it to filter records if they do not fit the grouping choice. The only issue I am having is when I group by the instructor.…

How can I request access for my team to access Preform Certs

My team had access previously to http://ssrs2012/Reports_SSRS2012/report/Quality%20Control/Quality%20Control%20-%20NA/PreformCerts and now they are not able to access it.

Report Builder, SSRS Not Displaying One Column Data When Running

What the table looks like prior to running: What part of the report looks like after running: All of the fields seem to be populating correctly with the exception of the Notes column. The notes field should contain a few sentences of data for each…

Power BI Report Server - Shared Data Sources for PBIX reports

Does Power BI Report Server support Shared Data Sources for PBIX reports in the same way SSRS supports Shared Data Sources for RDL reports?

set date range to all records on dates parameters

I want to set my date range in parameters to all dates. how can I do that in parameters settings

Request for SQL Server 2022 Reporting Services Product Key

Hello Team, While installing Microsoft SQL Server 2022 Reporting Services, the installation wizard is prompting for a valid product key. Currently, we do not have the required license key available, which is preventing us from proceeding with the…

Add SSRS to my SQL Server Managed Instance

Hi, We created a SQL Server Managed Instance and Will like to add the report role and enable SSRS to generate report from the managed instance, How can we do that?

Error viewing custom reports on Dynamics 365 9.1 on-premise

We cannot run a custom report created in the report wizard. The standard reports seems to be working. We have the same solution running on TEST and Develop servers, where we dont get error. System infos: CRM server: Windows Server 2019 Standard…

auto send a report daily

how to have a report auto generate to a pdf and emailed to me and the other advisers, every morning. report in question is the "Service Adviser Performance" report for store 2115, Mercedes Benz of North Orlando.

Security rules violation exception when running subscriptions with SSRS Custom Authentication

I have implemented SSRS Custom Authentication using Microsoft.Samples.ReportingServices.CustomSecurity. Everything works correctly in SQL Server 2022 ReportServer- except for subscriptions. When I add new subscriptions and executed it, I get the…

SSRS URL certificate renewal

The SQL Server certificate associated with the SSRS URLs will expire on June 26th. A replacement certificate has been installed on the SQL Server, but instructions are needed for correctly binding it to the SSRS URLs. Could you please advise whether…

Problem upload .pbix file in power bi "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file."

Problem upload .pbix file in power bi "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file." Problem upload .pbix file in power bi "There was…