SQL Server Reporting Services

Emailed Reports

In Reporting Services, My Subscriptions section is empty but I get emailed reports each week. How do I change which reports I get emailed?

Request to Save Default Report Filters

To improve efficiency when pulling the Survey Verbatims report, I would like to save my seven standard filter selections as a default or reusable report view. This would allow the selected options to automatically load each time I access the report,…

SQL Server Reporting Services 2022 Licensing

Hi, We want to install SSRS on a separate server to our SQL Clusters and not have SQL installed directly on the host server. Is there a way to get a license key specifically for SSRS?

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.