Stack Overflow
Stack Overflow

Questions tagged [ssrs-2017]

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

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2017 in October 2017. More info in the tag.

169 questions
0
votes
1 answer

SSRS prompting for credentials HTTPS but not HTTP

I have an SSRS 2017 install that does not prompt for credentials when going to the HTTP URL for a report. When I change the URL to HTTPS, regardless of the browser or user, credentials are required/prompted for. How can this be bypassed??
larryr
  • 1,536
  • 3
  • 17
  • 27
0
votes
0 answers

How can I catch and log details about exceptions when rendering an SSRS report?

I work with applications in ASP.Net. Some are MVC, some are WebForms, most use .Net Framework, a few use .Net Core 3; almost all of them have reports. Sometimes when rendering an SSRS report in Viewer.aspx, something goes wrong. It might be that…
MDD
  • 147
  • 9
0
votes
1 answer

SSRS Report - Badges

Is there an easy way to do a page of badges in an SSRS report? I am looking at 2 across and 3 down per page based on a list. I have built one so far of a single column using a list box but the problem is that it is not advancing to the next record…
Jayson Larner
  • 73
  • 6
0
votes
2 answers

SSRS 2017 Export to XLSX shows "We found a problem with some content..." error when rendering through web forms app

We're using SSRS 2017 as our report server with ReportService2010.asmx and ReportExecution2005.asmx as the web references. When I export the report to Excel in the reporting server or project, it exports to .xlsx file and I'm able to open it without…
Ram
  • 661
  • 2
  • 12
  • 37
0
votes
1 answer

I am trying to display a view to see multiple units of measure for a set of data I have in SSRS

I have to generate a report from a SQL query. The report contains trade data in a certain unit of measure, the users want to be able to see the data in three different units of measure. Is there a way of adding a parameter where you can to pick a…
Zakariya Kasu
  • 1
  • 1
0
votes
1 answer

I am trying to create a parameter with a drop down function in SSRS

The report parameter 'Region' has a DefaultValue or a ValidValue that depends on the report parameter "Region". Forward dependencies are not valid. This is the error I keep receiving when trying to use this parameter. I also have a DeliveryDate…
Zakariya Kasu
  • 1
  • 1
0
votes
0 answers

show abbreviated timezone name from datetimeoffset field in SSRS

I need to show abbreviated timezone name from datetimeoffset field in SSRS. E.g. Value In Database Expected Output 2021-01-13 8:00 +5:30 2021-01-13 8:00 IST 2021-01-13 23:00 -6:00 2021-01-13 23:00 CST What's the best practice to…
UVData
  • 459
  • 2
  • 6
  • 13
0
votes
0 answers

SSRS line chart count when date not null breaks only if there are future dates

I have a line chart created that displays the counts of rowIDs grouped by the month of an associated date. However, not every row has the date. If there is no date, I don't want it counted at all. My current semi-fix for this is adding a filter in…
erosebe
  • 927
  • 3
  • 16
  • 31
0
votes
1 answer

SSRS drill through report, How do I locate the referencing report name from main report

I have a report (developed by a previous employee), some of the columns(data) are clickable, when clicking the number(data on some of the columns) it opens another report. But when in the design mode from the first report, I could not figure out the…
SQlOra
  • 13
  • 4
0
votes
1 answer

SSRS - how to list separate values of a group combined into a merged row

In Microsoft Report Builder, I have a report designed like below: Name Email Value [Name], [Email], [Value] where the data source is like: select name,email,value from mytable The output of the report is like: Name Email …
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

How to execute multiple reports in SSRS 2017

[![enter image description here][1]][1]I have an SSRS 2017 report that consists of a main report and multiple sub reports. This report is published to the SSRS Portal, and then called by a web application. The report currently accepts one parameter…
Jay
  • 65
  • 1
  • 9
0
votes
1 answer

How to get Start Time of currently running SSRS Subscriptions

Can anyone help me in getting the currently running SSRS Subscription report Start Time. I queried dbo.Notifications table, but the columns NotificationEntered , ProcessStart and ProcessAfter is quite confusing. Please help. Thank you
Santhosh Reddy
  • 13
  • 2
0
votes
1 answer

isdate query (ssrs update to 2017)

we recently migrated to ssrs 2017 from an older version and on certain reports, where we utilize ISDATE the report returns an argument and does not run, here is the case statement in the query CASE WHEN ISDATE(or_shby) = 1 THEN CONVERT(DATE,or_shby)…
lmags
  • 11
  • 2
0
votes
1 answer

SSRS Subscription using REST API

Can we create/modify SSRS Subscription using REST API as SQL Server Reporting services 2017 supports REST API calls?
sanket
  • 59
  • 8
0
votes
1 answer

Report column is showing #Error when using Subscriptions

As titled, when using SSRS 2017 subscriptions to generate a report, a column with expression is showing #Error. However, when I try to run manual in web and in the report builder, it can be shown. The Expression…
Karl Chin
  • 1
  • 2
1 2 3
…
11 12