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

SSRS Interactive Sorting in rendered html

I have a simple report that displays department number and department name with interactive sorting enabled on those two column headers in the tablix. I am access this report via URL access from an MVC5 application. The report is being rendered in…
Mike Ramsey
  • 843
  • 8
  • 23
0
votes
1 answer

SSRS with UDF and dynamic SQL

I have an SSRS report with a datasource connecting to Oracle db, that then uses a transparent gateway to pull DB2 data. Due to using date range validation, and to have an optional parameter, I am using a udf to build the sql statement dynamically.…
ddog0823
  • 17
  • 1
  • 6
0
votes
1 answer

How do I change the height of a table row in an SSRS report to hide a subreport?

I am using SSRS 2014 with VS2013 rc5. Is it possible to change the row heigt forcing CanShrink property on a table cell in an SSRS report? I am able to hide the report if the value of the previous column is 0 but how do I shrink the row?
John Schultz
  • 672
  • 1
  • 10
  • 29
0
votes
2 answers

What is the proper way of referencing a field in a SSRS dataset?

I am using SSRS 2014 SP1 x64 and VS2013 Update 5. I have the following expressions to attempt to calculate ageing on a statement report. =SUM(IIF(DateDiff("d", (Fields!OrderDate.Value, "Invoice"), Now())<=0, (Fields!LineAmount.Value, "Invoice"),…
John Schultz
  • 672
  • 1
  • 10
  • 29
0
votes
3 answers

What will be missed if report server 2008R2 database gets restored in SQL server 2014

I'm planning to migrate all the SSRS reports from 2008R2 server to new sql server 2014 environment. As far as migration is concerned, I was asked to take the backup of 2008R2 report server database and restore it in 2014 server. I was not convinced…
Remi
  • 214
  • 5
  • 17
0
votes
2 answers

SSRS IIF statement to find if rounding up or down

I've found multiple ways to format a rounded number, but what I am looking for is how to tell which way a number is rounded, specifically in SSRS 2014: =IIF(Round(Fields!IMPERVIOUS_AREA.Value/4000,2,MidpointRounding.AwayFromZero)=Floor(0),"Round…
ltbehling
  • 3
  • 2
0
votes
2 answers

Reporting Services Preview Host has stopped working

I am having an issue previewing SSRS reports using Visual Studio Professional 2013. The first time I preview a report it works, however, if I go back to design and then preview again I get the following error: Problem signature: Problem Event…
BigDevJames
  • 2,650
  • 5
  • 21
  • 36
0
votes
1 answer

SSRS Report Viewer 10.0.0.0 Error

From my application, the user clicks a button that launches a new window that contains the Report Viewer control and from there the user chooses the parameters from dynamically generated dropdown lists. When they click the View Report button it will…
Shaun.S
  • 81
  • 4
0
votes
1 answer

How can you automate copying a report on an SSRS Report server?

Right now we use linked reports in many places. This causes subreports to link back to the original folder. Is there a good way to copy a report in SSRS to copy a report to another folder with C#. We don't want to manually open a report and save…
sclarson
  • 4,362
  • 3
  • 32
  • 44
-1
votes
1 answer

How do you launch URL by opening an SSRS report

I have the following scenario in my company: We have two BI tools One is a highly interactive reporting platform that reports from and generates the company data warehouse The other is SSRS which we use for our static form type reports. We also use…
user2944011
  • 21
  • 7
-1
votes
1 answer

Change rendered display to show chart horizontally (x number of columns)

I've got a report in SSRS (I believe version 2014) that has a chart within a tablix as shown: When I click "View Report" it shows like so: Notice how it displays each chart (per detail) going down vertically. Is there an easy way or property I…
JonH
  • 32,732
  • 12
  • 87
  • 145
-1
votes
1 answer

SSRS data driven subscriptions for valid email addresses

We have a tons of daily data driven subscriptions. Sometimes these subscriptions delivery fail due to even a single invalid email address (terminated employee). My question is there any way to create a parameter/code/expression that let's…
Shan
  • 13
  • 7
1 2 3
…
12
13