For questions specific to SQL Server Reporting Services.
SQL Server Reporting Services, server-based report generating software system from Microsoft.
Questions tagged [ssrs]
19 questions
3
votes
0 answers
Could not load file or assembly in SSRS 2017
I have Visual Studio 2017 Enterprise installed on Windows 10. In a separate from SSRS solution I created a Visual Basic project named "CustomFunctionsVB". In this project I created a class library "DateFunctions.vb" that has one function. I built…
DmitryV
- 31
1
vote
1 answer
Sorting in SSRS 2008
I am trying to sort a column from largest value to smallest in SSRS 2008. These values are derived from an expression, not an actual data field. So I am wondering if there is a way to sort this column?
This is my expression that is used in this…
Kevin Brekke
- 43
1
vote
1 answer
How to edit SSRS 2008R2 Reports in Visual Studio 2012?
I'm a report writer who's been able to edit/update reports in Visual Studio 2008 (we use SSRS2008R2). I've just installed Visual Studio 2012 and when I go to convert my reports project it's not working as I appear to be missing a…
Michael A
- 203
1
vote
2 answers
Reporting Service web service endpoint - Could not connect to server: https://site/ReportService2005.asmx
I'm assigned to update reports for SSRS that a coworker designed years ago who has retired.
I review the instruction he left. He created a cmd that uses rs.exe to deploy the reports.
I perform the cmd but it errors with
Could not connect to server:…
Circle Hsiao
- 183
1
vote
0 answers
Culture error when loading subscriptions, SSRS 2016
When attempting to load subscriptions in Sql Reporting Services 2016 users are receiving this error:
Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!5f!05/31/2019-16:15:48::
e ERROR: [vby5m1jr]: OData exception occurred:
…
Chris Craven
- 11
1
vote
0 answers
SSRS in SharePoint integrated mode: subscriptions failing
We have a SSRS integrated inside a SharePoint farm. Recently we changed owner of all subscriptions to a different one (a technical account, 'ABC\XYZ'). The subscriptions target either a SharePoint library or a fileshare.
All the subscriptions are…
Petr Pařík
- 11
1
vote
0 answers
AZURE_KEY_VAULT provider in SSRS
I've recently set up Always Encryption on an on-prem SQL Server db with the column master key in Azure Key Vault. If I SELECT from the table in SSMS with 'Column Encryption Setting=Enabled' I can read the column in plain text so _I'm pretty…
dboliviaa
- 11
1
vote
1 answer
Check Status of All SQL Services
I wanted to List all the SQL Services including Reporting Services.
Wmic service where (PathName like '%Binn\%sql%') get caption, name, startmode, state, PathName, ProcessId
This one will give all except SSRS. anyone have an idea how for that as…
Sandesh
- 11
1
vote
1 answer
SSRS Generating Large Log Files, Filling Drive
I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB .mdmp file every minute or so. I haven't been…
Alex
- 111
- 6
1
vote
2 answers
How do I enable both PowerShell Remoting and SPN for SQL Server Reporting?
I have tried this question on Stack Exchange - Database Administrators (https://dba.stackexchange.com/q/129286/51925), but I don't get any responses, so I'll try here.
I'm struggling with remoting servers with SQL Server Reporting Services. My…
0
votes
1 answer
Why is RSKeyMgmt.exe unable to connect to instance SQLEXPRESS?
I am writing a post-image deployment script where one of the steps is to restore the SSRS encryption key that was lost after using sysprep to create the image.
Restoring the key using the GUI tool Report Server Configuration Manager works fine,…
Craig
- 475
0
votes
0 answers
Reporting services configuration manager cannot find Report Server instance (SQL server 2008 R2 standard)
I have SSRS and SQL server 2008 running on same server. However sometime I found Reporting services configuration manager cannot find Report Server instance and it is affecting reports.
The only way to resolve this is to reboot the server. This…
0
votes
0 answers
SSRS Error :Could not find stored procedure 'IsSegmentedChunk'
Open SSRS Reports we receive this error (sometimes)
(When opening reports or developing reports)
An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.…
0
votes
1 answer
Why is Text Parameter not accepting new value only when default value is blank or NULL?
I have a group of users who need to amend address details pulled in a report before it is printed out. We do not want these amendments to be saved or recorded on CRM.
I have worked out that using text parameters, to show the original values from…
Caroline Allen
- 11
- 4
0
votes
1 answer
Is it possible to extract some data for users to amend and then use the amended data in the report?
I am using SSRS 2008 r2. I have a group of users that need to amend address details before they are printed from a report in CRM onto a pre-printed form. However we do not want to save these amendments into CRM. I have set them up a report that…
Caroline Allen
- 11
- 4