Menu
I had a request come through asking me to create an AD Security group that could be used in SSRS for users to get reports. There are currently other AD groups that work but the one I have created does not allow users to connect. Creating AD groups isn't real difficult and I know I have it set up correctly. Does anyone have any input as to why the group is not working? I have no knowledge of SSRS or SQL in general so any help would be appreciated.
919
Deprecated features in SQL Server 2022 Reporting ServicesNo features were deprecated in SQL Server 2022 Reporting Services.
Ad hoc reporting enables you to analyze data and create custom, reusable reports. Users control what data is included in a report and how that data appears. Benefits of this feature include: Insight into previously unknown trends and relationships between processes, resources, and other data sources via data analysis.
At the bottom of the report builder, you will see two boxes, Row Groups and Column Groups. Select the Column Groups drop down, click "Advanced Mode" and then in Row groups highlight "Details". In Properties under the "Other" section, select "True" for Keep Together. and save.
You have to assign that AD group an SSRS Role in SSRS Manager
Depending on permission you want to give it.
103
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
