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

SSRS Report Timeout From Site - From Report Builder Works Fine

I'm working on SSRS report. It works fine when I run it from Report Builder. Now, when I run the same report from my site, which uses Report viewer to show the report, timeout issue occurs. So I have observed that it times out after 90 seconds. Can…
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
3 answers

Ceiling not working properly in SSRS Report

Used below expression to show only 50 Rows per page. =Ceiling(RowNumber(Nothing)/50) But still it shows only 42 rows per page. Crystal report shows perfectly fine but SSRS report doesn't. Please help me to solve my problem!
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
1 answer

Reportmigration: CrystalReports to SSRS Parameter is applied but not used

Im currently trying to migrate a report from CrystalrReports to SSRS. Im very new to reporting and havent worked with eighter one of those reporting systems before. I have one main report, with 2 subreports. They are working correctly and showing…
Master Azazel
  • 612
  • 1
  • 12
  • 32
0
votes
2 answers

Can't change x axis format SSRS 2014

I'm trying to change the x axis format that now for ex. looks like this 201601012300 by right click on the x axic prop, number and choose the format (I try different formats). Strangely but it's not working. Just to be sure, when i change the font,…
Sara
  • 19
  • 5
0
votes
1 answer

SSRS data driven subscriptions - Error: Subreport could not be shown

Using SSRS 2014 enterprise. I have a data driven subscription that should be generating about 500 reports as PDF files. These reports are made up of a master report and two sub reports. If I view the report through the web portal, it works…
Neil P
  • 2,920
  • 5
  • 33
  • 64
0
votes
1 answer

Make footer appear at the bottom of Report Page even if there is no data

I'm working on SSRS Report. How to make footer appear at the bottom of Report page, when there is no data to show in tablix? Currently all reports footer is appearing immediate next to the Tablix Last Row. It should always appear at the bottom of…
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
1 answer

Conditionally count based on other field data in SSRS Report

I am working SSRS report, I have a field named as Details and I would like to get the count of other field SerialNumber. So in short I want to get the total count of SerialNumber which has no Details. I tried below but not working. It always give…
Pedram
  • 6,256
  • 10
  • 65
  • 87
0
votes
1 answer

SSRS access to URL

I've installed SQL Server 2014, and now when I go Report Manager URL I receive error: User 'Domain\name' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
0
votes
1 answer

Populating a parameter in SSRS 2014 report from URL

I have researched the heck out of this and as far as I can tell I am doing it correctly. I have created a report called Traveler using visual studio and deployed it. The report comes up but asks for a parameter even though I have included the…
TEC C
  • 153
  • 1
  • 3
  • 18
0
votes
1 answer

Installing Reporting Services - Native (SQL Server 2014) error

When I try to install Reporing Services on existing instance in SQL Server I receive the following error: I've tried to do steps described here (http://lokna.no/?p=1180), but it didn't help. How can I solve problem and install Reporting Services…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
0
votes
1 answer

SSRS 2014 - MHTML Email Formatting Issue

I am currently upgrading reports from SSRS 2008 R2 to SSRS 2014. I originally opened the reports from 2008 R2 and then saved them to 2014. This worked fine for all the reports...except one. All the reports I am upgrading are being emailed as…
0
votes
1 answer

SSRS - how to remove textbox white space on subsequent pages?

It seems so basic and surely resolved by SSRS 2014 SP1 but I can't find a way in Print Layout (for PDF ultimately, but this is simple display) to allow a tablix to render at the top of following pages when a text box displays above it on the first…
TickboxPhil
  • 151
  • 2
  • 10
0
votes
1 answer

SSRS Field from multi value parameter ReportBuilder

I am attempting to generate a report based off a SharePoint list to display each team members work load over a dynamic amount of weeks using an SSRS stacked bar chart. Essentially I want the report to look like this: Desired Report I am looking…
0
votes
0 answers

SSRS Migration 2008 to 2014 - InternalCatalogException secDesc != null

We're migrating side by side from SSRS 2008 Web to SSRS 2014 Enterprise. I followed the steps - backup encryption key, backup databases (ReportServer and ReportServerTempDB), restored databases, restore the encryption key and finally pointed SSRS…
Horia
  • 1,612
  • 11
  • 18
0
votes
1 answer

Reporting Services 2014 - Navigation Bar displays 0 of 0

Background: We recently migrated to SSRS 2014; our source database is SQL Server 2008 R2. We ran into some performance problems on a report where it simply would stop responding and ultimately timeout after 30 minutes when rendering the report. …
Russ
  • 678
  • 8
  • 26
1 2 3
12
13