76 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
72
views
SSRS 2019 - How to Change Maximum Height of Parameters Panel?
Using a browser, we found that SSRS 2016's Parameter Panel has a maximum height of 100% for report generation. Using SSRS 2019, we see that the Parameters Panel has a maximum height of 40% with ...
1
vote
0
answers
65
views
Custom Security Extension in SSRS – "Could not load Authorization extension" error despite correct configuration
I'm working on implementing a custom security extension for SQL Server Reporting Services (SSRS) 2019 Developer Edition. I'm following the official sample provided by Microsoft on GitHub (...
0
votes
1
answer
68
views
SSRS 2019 report running extremely slow - Oracle SQL query that runs fast
I'm in a situation where I have an Oracle SQL query that runs fast in SQL Developer but takes forever to run in SSRS.
I have the following lines embedded into my query for all 3 of my parameters:
...
0
votes
0
answers
20
views
SSRS Expression for Date Frequency (Year, Quarter # and Year, Month, Date)
I have an SSRS tablix that I need to group the data based on date (mm/dd/yyyy). I need to write an SSRS expression to group the data by year, quarter # and year and month, but i can only write the ...
0
votes
0
answers
23
views
Can you use different environment settings in SSRS as per configuration manager setup in Visual Studio
Can you use different environment settings in SSRS as per configuration manager setup in Visual Studio?
The answer to Promoting SSRS Report through different environments - Datasource is ok if you are ...
1
vote
0
answers
45
views
Is there a way to rename PDF attachments dynamically in SSRS 2019 through data-driven subscription?
I'm trying to get a PDF attachment that gets sent through email to be renamed to the backorder #. Currently, it's being named the report name as default.
I have a dataset field that I want to use as ...
0
votes
1
answer
33
views
API / Command line to add domain account access to SSRS report folders
Is there any way either via API or Command line of being able to add a domain user account to be able to access reports in a named folder / named folder in Data Sources in SSRS?
Thanks.
0
votes
0
answers
337
views
SSRS Shared Data Source Error with Snowflake Key Pair Authentication (ODBC)
I'm encountering an error while creating a shared data source on SSRS using Key Pair Authentication for Snowflake. Currently, we have a working shared data source with Username/Password authentication ...
1
vote
0
answers
59
views
SSRS Report Pagination: Dynamic Page Count and Row Limits Across Multiple Sections and Subreports
I have successfully achieved the desired results for the first page. However, I am struggling with implementing the pagination logic from the second page onwards. Specifically, I need guidance on how ...
0
votes
0
answers
89
views
SSRS 2019 not rendering row groups correctly
Our SSRS reports that use row groups have stopped rendering correctly in the last 2-3 weeks. We have a virtual server that has a Microsoft Windows Server 2019 Standard OS and SQL Server 2019 standard ...
0
votes
1
answer
1k
views
Expand/collapse all Report Builder without using parameter
Is it possible to expand collapse all grouped items on SSRS Report builder like in example on the page below: https://www.sqlchick.com/entries/2010/9/19/expand-or-collapse-all-grouped-items-on-ssrs-...
0
votes
1
answer
116
views
SQL Server Reporting Services: how to use a report parameter in the data-driven query?
I have a report in Reporting Services which should use a data-driven query to create a dynamic file name.
For that I created a stored procedure that accepts 3 parameters:
ALTER PROCEDURE [dbo].[...
0
votes
0
answers
130
views
SSRS 2019 PDF export issue
Getting the following error while exporting SSRS report to PDF. Excel export is working fine. Only issue with PDF. Any help on this issue would be welcome.
RenderFromSession('/Test/TestReport')
...
0
votes
1
answer
39
views
Parameters Collapsable fields on SSRS report work in browser but not in webforms report viewer
Using SSRS 2019
.net 4.6
Webforms reportviewer 15
I have a report with parameters and collapsable rows, to allow drilling down to specific items. This works fine in Visual studio and via the web. ...
0
votes
1
answer
58
views
SSRS Report column percentage formatting not displaying correctly
I've recently been made aware by one of my colleagues that a report that I have created does not show percentage column values correctly when viewed on a mobile device. When viewed via desktop, either ...