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
2
votes
1 answer

Axis object - Auto interval error in SSRS Drill Down Report

I am having an error message in my SSRS Drill Down-Chart report: "Axis object - Auto interval error due to invalid point values or axis minimum/maximum" It displays only for the certain values in my report, but not for all of them. Many others work…
Hell-1931
  • 489
  • 1
  • 6
  • 24
1
vote
1 answer

Summing to columns into a third column in SSRS

I have two columns in.column1, ou.column2. I would like to place a third column next to them that totals the number from both columns. I have tried an expression=sum(Fields!in.coulmn1.value,"new_dataset") +(Fields!in.coulmn2.value,"new_dataset")this…
Wickawicka
  • 11
  • 1
1
vote
1 answer

SSRS how to use SnowFlake as a data source

I created a 64-bit ODBC User DSN for SnowFlake driver. The SnowFlake data source is not showing in hte list of user or dsn when i'm trying to create a connection. Is snowflake driver allowed in MS Visual Studio 2017?
Arsee
  • 651
  • 2
  • 11
  • 36
1
vote
1 answer

How to schedule biweekly SSRS subscription on 2017 report server

I would like my report to be sent biweekly on a Monday. Right now, I created two different subscriptions that sends the report on every 2nd and 4th week. I am not sure it would be accurate considering, I would like the send the report Monday after…
Gloria_2015
  • 23
  • 6
1
vote
1 answer

SSRS 2017 for Form Authentication not working in Windows Server 2016

For SSRS 2017 Form Authentication, I have followed the instructions based on the Microsoft Sample (https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample) and also…
P S Felix
  • 11
  • 3
1
vote
0 answers

SSRS Dynamic Width for Body of Report

I have a report that currently has a table with 10 columns. I have visibility rules set on the last 5 columns to hide in some scenarios. When I hide those columns there is a large amount of white space on the right side of the report. I do not want…
Andy Jensen
  • 83
  • 2
  • 9
1
vote
1 answer

SSRS 2017 Subscription can't be created or edited because the credentials used to run the report are not stored

I have an ssrs server that is not allowing me to create subscriptions for some reports. There are 20+ reports in a folder which all use the same data source: /Data Sources/MyDataSource. The credentials are stored in the data source. I can add…
Mark Wojciechowicz
  • 4,287
  • 1
  • 17
  • 25
1
vote
1 answer

SSRS - An unexpected error occurred while compiling expressions. Native compiler return value: ‘255’

Since a server move, we've been experiencing issues with most of our SSRS reports when opening in Report Builder. Getting the error message: "Failed to preview report. An unexpected error occurred while compiling expressions. Native compiler return…
Rubix
  • 11
  • 4
1
vote
0 answers

How do I add columns based off a parameter in ssrs report

I am creating a report on Visual Studio and I need to sum the columns based on the year. My data has number of packages for the year 2019 and 2020. I want a grand total for 2019 and for 2020 as the last column on my report. I try to sum it up , and…
cyriac jacob
  • 27
  • 3
1
vote
1 answer

SSRS report collapsing and expanding part of the table

I have a table of many columns: Column names/table Is there a way to make collapse/expand feature to the table part "Product Shelf Life History"? Because the tablix is too big, the user has to scroll all the way to the right side. That part is not…
ERud
  • 17
  • 5
1
vote
1 answer

Sending custom HTTP headers with an SSRS Rendering Extension

There is a known problem with SSRS Rendering, which is that when rendering PDFs a Content-Disposition: attachment; ... header is sent which forces the file to download rather than open inline (here's an SO thread about it from 2009). I am wondering…
Goulash
  • 3,708
  • 6
  • 29
  • 48
1
vote
2 answers

Fill color based on values from other data set in SSRS

I'm trying to fill colors based on table records. From SQL Server AdventureWorks2017 database: select * from [HumanResources].[Department] I have two dataset: 1st : select * from [HumanResources].[Department] …
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
vote
2 answers

SSRS Export to Excel Very Slow

I've searched SO for help on this and I think I've exhausted all options. I have a report that generates about 320k rows and the export to Excel is very slow. So slow that, even after the rendering is over (as shown on the ExecutionLog3) the excel…
Geezer
  • 513
  • 5
  • 17
1
vote
1 answer

Pin chart from SSRS to Power BI not working

I’m trying to pin an chart from SSRS to Power BI. When I pin a chart in SSRS to a Power BI Dashboard I get ‘Pin Successful’. When I look add it in my Power BI Dashboard I get ‘We can’t load the content of this tile. Please delete it and try…
kp12345
  • 11
  • 1
1
vote
5 answers

Reporting service configuration manager unable to start currect report server - SSRS

SQL Server lunchpad and SQL Server reporting service not getting started. "Windows could not start the SQL Server reporting service on local computer" Error 1053: The service did not respond to the start or control request in a timely…
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
2
3
…
11 12