Stack Overflow
Stack Overflow

Questions tagged [ssrs-2016]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2016.

463 questions
1
vote
0 answers

SSRS error NT Authority\Anonymous Logon failed for new client machine

I’m in a situation that we have sql server and ssrs in one ad domain and the machines accessing the ssrs (client) is in a different ad domain. The login process is impersonated and user login as anonymous user. Both ad domains have trust setup and…
K Akram
  • 11
  • 1
1
vote
1 answer

In Microsoft report bulider, how to convert integer to string

I have one integer data in my dataset column. I want to convert the integer value to string. For example: I have a column like class ID: 100, 200,300,...etc I need to change the "Class ID"data like 100 means it displays "Class A" 200 means it…
Yuvaraj A
  • 11
  • 1
1
vote
1 answer

Row visibility expression using ReportItem collection not working

This is major edit from the previous version of this question, which would hold little of value for future readers anyway. I have a report where I want to hide certain rows depending on the data in certain fields, but also be able to override this…
Tab Alleman
  • 31,483
  • 7
  • 36
  • 52
1
vote
1 answer

Connect to SSRS from different computer on home network

I am trying to access the SSRS web portal. I have SQL Server and Report Server installed on laptop with Windows 10. I want to access this from another laptop running windows 11 that is connected to the same home internet network. The web portal…
Chris Kiniry
  • 499
  • 3
  • 13
1
vote
0 answers

PowerShell code to copy Sql Server Reporting Services report security/permissions from one user to another

I'm new to Powershell. But I need to find out whether it is possible to mimic a user's permissions on different SSRS reports (as some of these users have permissions to hundreds of reports) and grant these permissions to other AD users. I looked…
imranH2018
  • 11
  • 2
1
vote
2 answers

SSRS Row Group with non-aggregated measure column

I'm not finding any other questions exactly like mine, so it's time to ask. I have an SSRS 2016 report. It's got a regional hierarchy (State, City, Location). And it's got one measure column that is a calculation performed in the stored procedure.…
Tab Alleman
  • 31,483
  • 7
  • 36
  • 52
1
vote
1 answer

How to query SSRS data driven subscription detail

I would like to retrieve SSRS data-driven subscription detail from the ReportServer DB. I am able to retrieve most of the detail from the table Subscriptions but I need the dataset information (SQL Query itself) which is used for Data-driven…
alex
  • 51
  • 4
  • 10
1
vote
1 answer

Is there any suitable approach to display dynamic columns and tables in SSRS report?

I have a requirement in which I have to display dynamic columns and tables in SSRS. I have to create a generic report RDL which can have 1 or 2 or 3 tables and each table can have any number of columns and is configurable based on report type. This…
Nishant
  • 11
  • 1
1
vote
0 answers

SSRS 2016 Report Subscription running on wrong month

I have an SSRS report subscription with a Report Schedule defined as:- At 11:45 PM on day(s) 30 of Apr, Jun, Sep, Nov, starting 11/28/2018 Yet it ran on March 30 ... 11:45pm pm on 30th of April, June, September & November Enabled Standard E-Mail …
andyabel
  • 335
  • 4
  • 15
1
vote
1 answer

Can we disable "Include Report" option in the SSRS Email subscription page?

I am trying to find a way on how to disable the "Include report" option from the Email subscription page. As per our requirement, users will create their own subscriptions for specific reports. But as a DBA we would like to control their ability to…
Lucky
  • 21
  • 4
1
vote
1 answer

Optimizing queries that search for text

I have SSRS report that uses a query that searches for specific text in the Where clause. I know using IDs is the preferred method of filtering data down, but this table only makes use of varchar strings...Very long strings I might add. There are 5…
JerrySeinfeld
  • 91
  • 9
1
vote
1 answer

With PowerShell and ReportingService2010, how to change empty shared datasource or custom datasource to shared datasource?

I'm quite in an impasse here. I started writing a script with PowerShell to handle setting Shared Datasources to all the reports of a folder. My logic : For each report in the folder and For each datasource of the report : If the datasource name…
Beb
  • 67
  • 6
1
vote
0 answers

SQL Reporting Service 2016: "Could not load folder contents."

I'm getting the error: "Could not load folder." when I want to open the webportal (http:///Reports). Here is the error message in logfile: Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!14!09/21/2020-11:25:31:: e…
jul taps
  • 43
  • 7
1
vote
1 answer

SSRS report stuck loading state even executionlog3 says completed

Hope you are all doing good. I have a problem with SSRS as it is stuck in the loading state (tried with several different browsers) even though executionlog3 says execution has been completed. I agree with executionlog3 as I don't see any running…
alex
  • 51
  • 4
  • 10
1
vote
2 answers

Reporting Services: Position of Textbox or Tablix depending on parameter or dataset field

In SSRS 2016, I have one report for multiple customers. Each customer have individual letterheads which are stitched behind the report after creation. Now I want to change the position a textbox or tablix during runtime based on a x/y position…
Ulli
  • 500
  • 1
  • 7
  • 19
1 2 3
…
30 31