Stack Overflow
Stack Overflow

Questions tagged [ssrs-2014]

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

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

192 questions
1
vote
2 answers

How to get name and logo to repeat for every page of a table (tablix)

I'm trying to recreate a report created from Crystal Reports to SSRS. The report has the company name and logo on top, a chart below and a table that can span multiple pages. If the table for a company takes more than one page to display, the…
NoobDev
  • 13
  • 5
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
1 answer

Is there any problem if i have upgrade SSRS from 2014 to 2016 and the databases are still on SQL Server 2014?

Is there any problem if I have upgrade SSRS (hosted on server1) from 2014 to 2016 and its databases (which are on another server server2) are still on SQL Server 2014?
Sanky
  • 41
  • 8
1
vote
1 answer

Expression to set Legend SSRS

I have a report query that has "Year" as a parameter. If user selects 2016 in the parameter, the query produces 2016 values in a column named "SelectedYear", and 2015 values in a column called "PreviousYear". I want the legend for the bar chart to…
opperman.eric
  • 314
  • 1
  • 14
1
vote
0 answers

How to repeate normal column into multiple pages if that column is not column header in matrix ssrs

I am building a matrix based ssrs report and I want to repeat 2 column on multiple page( if extra pages is needed )and that column is not column header. it is static column. Please help me how its is possible
Sanjana Sharma
  • 21
  • 3
1
vote
1 answer

In SSRS, how to include first row from different dataset in tablix?

I am creating a report, the purpose of which is to print a letter to many different people. Obviously each person's name, email, etc. will be different. For this I am using a list, which I understand uses a tablix. Now inside each letter I also need…
Grant W
  • 27
  • 6
1
vote
1 answer

SSRS: How many reports have been sent out within 24hrs

I have a project that needs to list the reports that have been sent out for the last 24 hours via subscription. Is there a way to do this? Thanks in advance. For example 10 subscriptions were scheduled today but only 8 were successfully sent.
Moccassin
  • 169
  • 1
  • 4
  • 15
1
vote
1 answer

SSRS - Using database names as parameter

I have 2 databases both having same table structures but with different data. I want to display a report by giving a filter to choose the database name. I tried using connection string as expression in Embedded connection still it's not working.
akshay
  • 777
  • 4
  • 15
1
vote
0 answers

SSRS report URL - shows parameters but hide rest of header

I'm trying to use querystring parameters to suppress parts of the header of an SSRS report (using SSRS 12.0.4213.0). What I want to do is supress the breadcrumb and menu panel (marked in red above) at the very top and maybe also the toolbar below…
3N1GM4
  • 3,372
  • 3
  • 19
  • 40
1
vote
0 answers

SQL Server Reporting Services LocalDB doesn't exist error

I've been trying to view deployed reports in SSRS using Visual Studio 2015 and SQL Server 2014, but this is the error message I've been receiving: A network-related or instance-specific error occurred while establishing a connection to SQL…
user7397751
  • 11
  • 2
1
vote
3 answers

SSRS SDK For PHP : Not working from PHP 5.5

I'm using the SSRS SDK For PHP which has not been updated since years surprisingly (08.04.2010) . It works fine under PHP 5.4 (5.4.44) but not under 5.5+ (5.5.37, 5.6.28, 7.x) The error is : array ( )Failed to connect to Reporting Service Make…
pti_jul
  • 432
  • 1
  • 5
  • 18
1
vote
1 answer

SSRS report builder 2014 CDbl precision

I have some column in my report, calculated the Sum using this exepression : =SUM(IIF(Fields!Type.Value = 0, CDbl(Fields!Amount.Value), CDbl(0.0))) it works but gives me the sum with no precision. is there a way I can view the Sum with…
Amr Ibrahim
  • 167
  • 3
  • 14
1
vote
0 answers

Configure the SSRS web server for additional paths

I am using SSRS 2014, and on the server it runs, it binds to port 80 and exposes two paths, /Reports and /reportserver. I know how to configure these through the SSRS Configuration Manager. I am wondering about the web server in the backend running…
Michael Plautz
  • 3,578
  • 4
  • 27
  • 40
1
vote
1 answer

Can SSRS 2014 and SSRS 2016 operate concurrently in the Visual Studio development environment

I have developed and trialled a number of reports on my laptop using SQL Server 2014 and SSRS 2014 running in a VS 2013 Community Edition IDE. Can I install SQL Server 2016 and the 2016 SSDTs and run SSRS 2016 without removing SSRS 2014?
user7327707
  • 13
  • 4
1
vote
0 answers

SSRS2014, I can not send multi-parameters to MySQL via ODBC

I am using SSRS2014 to report data stored in MySQL database. I get the exception like : An error has occurred during report processing. (rsProcessingAborted) Cannot add multi value query parameter '?' for dataset 'DataSet1' because it is not…
Sittisak Po-ngam
  • 21
  • 5
1 2
3
…
12 13