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
2
votes
0 answers

How to check impact of schema change on all reports on SSRS Server?

I have more than 500 reports on the SSRS server. Now for any change in Schema of the database, I want to ensure that all of the reports using the object that has got changed in recent schema changes are working well. Is there a way to list down all…
Kasim Husaini
  • 392
  • 3
  • 14
2
votes
1 answer

Running a SSIS package from a SSRS report - SSRS 2014-2016

I need to launch a SSIS package from a SSRS report. I know that SSRS isn't an input data system, but I need to run interactively a SSIS package, without specifying any input data. Is it possible a such operation? If possible, I'd like to use a code…
Pasquale
  • 21
  • 4
2
votes
1 answer

SSRS group by multiple fields and groupings

I have a query that returns the following fields: GrantCode EmplID EmployeeFullName AssignedUnit DaysOff HourlyRate CalendarEventStart CalendarEventEnd NumberOfHours StatuteNumber ViolationDescription I want to have a stepped SSRS report…
Leslie
  • 3,604
  • 7
  • 38
  • 53
2
votes
1 answer

Long SSRS URL Works in IE and Edge, but not Chrome (The report server encountered an unhandled exception in HttpApplication.)

EDIT: Figured it out. Go to the server where SSRS is installed. Locate the installation directory for SSRS (C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer in my case) Edit the httpRunTime property of the…
user3908206
  • 45
  • 7
2
votes
2 answers

How to resend SSRS subscription emails?

If our report email subscriptions fail to get sent due to an issue like the SMTP server fails we have to manually re-send the report emails. Is there any way we can automatically re-fire the subscription emails and re-send them?
cspell
  • 161
  • 1
  • 6
2
votes
1 answer

SSRS export report to excel without rendering in browser and remove hidden columns

How I can direct export report from SSRS to Excel (xls, xlsx) without necessary rendering it in web browser because report is too big and rendering is very slow? And how I can remove hidden columns and rows from this exported report.
milenjao
  • 93
  • 5
  • 18
2
votes
3 answers

SSRS Color Expression Not Working When Deployed

In SSRS 2016 I have a matrix that is using a recursive parent hierarchy and have the following expression outside of the column groups, this textbox is the referenced for the Color property to set the text White or Black: =IIF(Level() = 0 And…
mheptinstall
  • 2,109
  • 3
  • 24
  • 44
2
votes
1 answer

SSRS Performance degradation

I have a fairly busy SSRS Instance and the redering performance is consistently degrading to the point where we have set the recyle time config to 60 as work around and im still getting significant reduction in rendering performance within the hour.…
ZedZim
  • 53
  • 1
  • 9
2
votes
1 answer

SSRS How to Get Report Cache Options With Powershell?

In SSRS web interface, after clicking on a report and going to Manage --> Caching if a report is configured to "Always run this report against pregenerated snapshots" there is a Cache snapshots section with an option "Create cache snapshots on a…
Fernando Vega
  • 525
  • 4
  • 13
2
votes
1 answer

delete deployed report ssrs

Is there a way that reports can be automatically deleted from folders on the SSRS site when the report no longer exists in the project? I created a solution in Data Tools that contains 10 projects. Each project contains a number of reports and…
Brian6400
  • 51
  • 2
2
votes
0 answers

SSRS 2016 Printing not responding

I have encoutnered the following problem. In SSRS 2016 Toolbar, the print widget is not working when I am trying to print a report. However, I can still save the file to .pdf or .xls format, open the file and print it. ClientPrinting is enabled on…
Gary J. Li
  • 21
  • 1
2
votes
0 answers

How do you save and retrieve reports that are favorites using reportservice2010 web service?

I am using SSRS web service to get report information but I am unable to figure out how to get favorite or set favorite for reports outside of reporting services without querying/inserting directly to the reporting service database (which I don't…
Emmie Lewis-Briggman
  • 855
  • 4
  • 12
2
votes
2 answers

SSRS 2016 - How to display a chart, based on a condition, in the same page location

I am creating a SSRS Report (PPT export) with multiple charts and fixed number of pages. Each page contains multiple charts. I want to display different charts in the same page location based on a condition. Now I know that ,we can Hide/Show a chart…
Denzil Soans
  • 667
  • 1
  • 7
  • 27
2
votes
1 answer

Gracefully migrate from SSRS2014/IE to SSRS2016/Edge

I have a chicken-egg-problem when upgrading from SSRS2014 to SSRS2016. I cannot move to the new reportviewer because I still have users on IE. The new report viewer cannot print nicely on Internet Explorer: if you click print, you can download a…
realbart
  • 3,497
  • 1
  • 25
  • 37
2
votes
2 answers

SSRS - How to show external image based on URL inside column

I am trying to show images for products inside a basic report. The image needs to be dynamic, meaning the image should change based on the SKU value. Right now I am inserting an image into a table, setting to external, and i've…
tnoons91
  • 41
  • 1
  • 1
  • 3
1 2
3
…
30 31