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

C# 5 ReportExecutionService

I am using Visual Studio 2017 and C# 7.3 to execute data driven SSRS 2017 report execution. Visual Studio 2017 requires using C#5 for break points to function properly. I can change to C#5, but I can I can find no documentation on C#5 and…
Steve_Malcolm
  • 53
  • 1
  • 9
1
vote
0 answers

EDGE browser unable to render report - where as its working with IE and Chrome

I was referring this to configure report service : https://www.mssqltips.com/sqlservertip/5237/installing-sql-server-reporting-services-2017/ Regarding current report server credential,here is what I have done (along with other required…
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
vote
0 answers

What is the correct SSRS to SSAS connection string format?

Data Source=my-server-01\\SQLSERVER2017;Catalog=Catalog=TabularProjectTest_serviceaccount1_ffcd154a-5c55-4f69-8a40-76628f97227f; I'm using the above connection string in an SSRS visual studio project to connect to an SSAS tabular database with out…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
1
vote
0 answers

Filter/hide "empty" rows in matrix based on filtered columns

I have an SSRS matrix fed with data like this: Country Region Term Count ---------------------------------------- ---------------------------------------- ---- ----------- United…
bendodge
  • 470
  • 5
  • 12
1
vote
0 answers

How to properly plan and size for a SQL Server Reporting Server database

I am trying to understand how to properly plan and size for a SQL Server Report Server database. As a high level description, my environments will contain a production database, a reporting database (separate database that is a subscriber to the…
Mark
  • 53
  • 6
1
vote
2 answers

SSRS not showing any text in preview

I have a very frustrating issue. Visual Studio will not show any text in preview. All it will return is a blank table. Initially, I thought it had to do with my datasource, and therefore I decided to hardcode some text into my table and it still…
Redraidas
  • 139
  • 1
  • 1
  • 10
1
vote
0 answers

VS SSRS 2017 automated DAX bringing no results but fetching results in query designer

Today I had to upgrade my developer edition of SQL Server, going from 2014 to 2017. With this I also had to upgrade our reports using SSDT 2017. Our old report datasets where in MDX format, and it had no measures defined, which 2017 really kicked…
C. Brindle
  • 43
  • 6
1
vote
1 answer

Date format in SSRS Expression

I am trying to change the date format for one of my field to dd/MM/yyyy but every time I used the below expression I get dd/MM/yyyy as the value in the cell instead of changing the format. The data source that I am using is Teradata. Expression…
Priyanka2304
  • 200
  • 3
  • 16
1
vote
1 answer

subreport in rdlc only shows for one record in master

I have a report that shows expenses and a sub report to show all payments against expenses.and this is how i am passing data to master and sub report Dim datasource As New ReportDataSource("Expenses", Ds.Tables(0)) …
user3439450
  • 27
  • 6
1
vote
0 answers

SSRS 2017 report rendering issue when sending email to groups

I develop a report using SSRS 2017 and scheduled an email rendering the data into email body. If a send just to me I get the email with no problem. if a scheduled to a group the email will be received with no data. It is some limitation of…
Ricardo Castro
  • 157
  • 13
1
vote
1 answer

SSRS Report Custom Sort

I need to implement custom sort on SSRS report on a Payment-Range field obtained from one of the dateset Payment-Range is appearing like this: $0 - $200 $200.01 - $1000 $1,000.01 - $10,000 $10,000.01 - $20,000 $20,000.01 -…
nishant
  • 13
  • 2
1
vote
0 answers

SSRS 2017 Scaleout adding/editing Data Source issue in Chrome

I have setup SSRS 2017 Scaleout environment with two nodes and a load balancer. Users can login fine with both IE and Chrome but editing Data Sources works in IE but not in Chrome. Details below. Here are the high level Installation/Configuration…
Afroz
  • 1,017
  • 2
  • 12
  • 24
1
vote
3 answers

The version of the report server database is either in a format that is not valid, or it cannot be read

I had an SQL Server 2012 database instance installed on server A. I then installed SSRS 2016 only (not the the complete SQL Server 2016) on server B but pointed the SSRS instance to host its ReportServer database on the SQL Server 2012 instance…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
1
vote
1 answer

SSRS express 2017, Configuration manager does not connect to service; RPC issue

I just upgraded SSRS Express 2016 to SSRS Express 2017. When configuring the service I can set the web service url and the Web Portal url. When creating a new database I can use the wizard without any issue. Database credentials are ok, connection…
François Fournier
  • 306
  • 2
  • 10
1
vote
0 answers

SSRS - Power BI Reporting Server: Running subscriptions simultaneously

I'm running Power Bi Reporting Service 2018 Version 1.2.6648.38132 The problem I am running into is when running scheduled subscriptions, only 1 subscription can be run at a time. When starting the subscription manually through the SQL Agent (while…
theOGloc
  • 231
  • 4
  • 13
1 2
3
…
11 12