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

SSRS 2017 use windows authentication

How can I bypass entering a user name/password in SSRS?? We have a TV that displays a report. I need the report to open & display without having to enter the user name/password. I have attempted making changes in the rsreportserver.config based on…
larryr
  • 1,536
  • 3
  • 17
  • 27
0
votes
0 answers

ReportViewer control not displaying on page

I'm trying to access the SSRS 2017 through an ASP.NET project but getting the below error. I'm facing the issue on ASPX page at line which is in bold below. Server Error in '/' Application. The request failed with HTTP status 404: Not Found.…
user13771247
  • 1
  • 1
0
votes
0 answers

How do I show all values of a particular field when I have coded it in an expression

I created a report, and I have a parameter(Sort) that allows me to choose multiple options to show the data(volume) for those options chosen. I have a second table at the bottom which has expressions, to show the % change in the values from the…
cyriac jacob
  • 27
  • 3
0
votes
1 answer

SSRS - Domain Migration and Subscription Ownership

We are in the process of migrating from one domain to another and it seems users cannot see the subscriptions they created when they were logged in using the old domain credentials. How can I, in bulk, make the users new domain credentials able to…
larryr
  • 1,536
  • 3
  • 17
  • 27
0
votes
1 answer

SSRS 2008 to SSRS 2017 Migration - Subscription issues

We have migrated from SQL 2008/SSRS 2008 to SQL 2017/SSRS 2017. We still have one issue where I cannot see the subscriptions I created in 2008. Below is the error I get. I have my domain account setup as System Administrator/System User in Site…
larryr
  • 1,536
  • 3
  • 17
  • 27
0
votes
1 answer

SSIS/SSRS -- I am getting this error, when I am creating a new project for SSIS in VS 2017

New to Reporting Services, I am getting this error when creating a new project
bensonissac
  • 635
  • 5
  • 10
0
votes
2 answers

Can a report parameter label have more than one value in SSRS

I have a parameter that has it's values and labels: Lithuania, Baltics, Europe 1, Europe 2, Europe 3, Europe 4, Europe 5 and ALL as null SSRS parameter Labels and Values How can I add a new label that has more than one of those values, for…
ERud
  • 17
  • 5
0
votes
1 answer

How to get total for top n rows (not for whole dataset) in SSRS 2017

I need to get SUM for TOP 10 rows only by counting unique claim numbers. Not for the whole dataset. for that in a group properties I set Filter with expression: But the total sum reflected for the whole dataset, not for top 10. I tried using…
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
0 answers

SSRS - Best way to run SSRS report for multiple integer ID values passed to single parameter?

*I'm using SSRS 2017. I've got a SSRS report with two parameters: a datetime and an integer (ID value). It uses the ID value as a filter in the main tablix in the body, and also for expressions in the header and footer. I need to change the report…
kfinn360
  • 25
  • 6
0
votes
1 answer

SSRS - Next/Previous Record Button Based on Date

I have a report in SSRS that shows various tablixes based on a date parameter. The user will select a date and the report will populate based on that date. This works fine. However, I would also like the user to be able to click on a "next record"…
Billy B
  • 37
  • 5
0
votes
0 answers

Dataset is not retrieving results in SSRS designer

I am trying to execute oracle stored procedure with input parameters as startdate and enddate. When i tried to add dataset with Oracle stored procedure. create or replace PROCEDURE Getsummary_data(i_start_date IN DATE …
AMDI
  • 895
  • 2
  • 17
  • 40
0
votes
1 answer

SSRS report multiple concatenate

I'm trying to join two data sets in my SSRS table report. The problem is that I can only concatenate two columns in my lookup statement. The third is being ignored. I need to do more than two. how can I achieve this? my values are duplicating in my…
Tdubs
  • 29
  • 7
0
votes
1 answer

SSRS Migration from 2008R2 to 2017 Error RSPortal

I was migrating our reporting services from the version 2008R2 to the version 2017 restoring the db and all seems to work fine unless for some report for which I cannot open the subscriptions page. For those report every time I enter in the report…
TooFast
  • 93
  • 7
0
votes
1 answer

SSRS 2019, summarizing calculated expression

I'm using a matrix to show salespersons orders for each month of the year. rows - state, salesperson name columns - year, month data - number of orders for each salesperson I have the total number of orders per year. based on that I have a…
Adia Shahar
  • 1
  • 1
0
votes
2 answers

Data-Driven subscription not working properly

I am using Data driven subscription to send report in Email body and as an excel attachment. In email,I am seeing the report as Body,but report as excel attachment is missing. The requirement is I need report to be send as an attachment and in Body…
AMDI
  • 895
  • 2
  • 17
  • 40
1 2 3
…
11 12