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

Configure SSRS for SSL

I have a SSRS instance, running SSRS 2014, and I want configure it for usage over SSL. The server is available at http://reports.mydomain2.com I purchased a multi SSL certificate from GoDaddy, on domain www.mydomain.com, and I added…
bzamfir
  • 4,698
  • 10
  • 54
  • 89
8
votes
3 answers

"XML parsing failed at line xxx, column 36: illegal xml character" when importing to Power Pivot from SSRS report

Excel 2016 (16.0.6965.2076) SQL Server 2014 (12.0.4213.0) I have an SSRS report with 10 parameters - two are dates and the other 8 are text dropdowns using a query to populate the options. If I try to fetch this report into a Power Pivot Data Model…
3N1GM4
  • 3,372
  • 3
  • 19
  • 40
8
votes
2 answers

Update Shared Datasource Path of all SSRS reports to different path

I'm working on SSRS Report. Recently I have changed my folder location of all SSRS report to different path. Also I need to change Datasource path. (As I have moved the reports again I need to set Datasource) So I can no it manually by going to…
Pedram
  • 6,256
  • 10
  • 65
  • 87
5
votes
2 answers

SSRS Report Parameter Default Null Value not Applied

I have a SSRS report with a single integer parameter. Using Report Builder I've: changed the parameter to allow null values. set the default value to Null. saved the report. However, when the report is requested from the server, the parameter is…
John
  • 1,043
  • 15
  • 20
4
votes
2 answers

Installation of Report Server 2014 freezes

Asked by: Avatar of Renato G Sabo Hi, im having a issue trying to install SSRS 2014 on my Windows 2012 Standard Server. I was having trouble trying to install SQL 2014 Standard (downloaded from my partner account), and was failing. So i started it…
Renato Sabo
  • 41
  • 3
3
votes
1 answer

What credentials need to be passed when accessing an SSRS report through URL?

I know this is repeat question, but I have searched almost all the threads about this and have not found any solution to my problem. Some of threads show a solution like: &dsu:DataSourceName=username&dsp:DataSourceName=password But this doesn't…
Snehal
  • 1,070
  • 12
  • 20
3
votes
2 answers

SSRS textbox hanging indent

I currently have a text box within a table that displays multiple stores based on user parameter input. The problem that I am experiencing that I would like to have a hanging indent that will force the store name to indent once it wraps to the next…
Istaley
  • 359
  • 1
  • 6
  • 24
3
votes
1 answer

Access Subreport Values In Main Report - SSRS

I have a Main Report within a Sub Report Using reporting services, How to get the value from Sub report to the Main report? I am calling sub report, based on main report's tablix data. So for example I have tablix on main report, that passes @Number…
Pedram
  • 6,256
  • 10
  • 65
  • 87
2
votes
1 answer

Running a SSIS package from a SSRS report - SSRS 2014-2016

I need to launch a SSIS package from a SSRS report. I know that SSRS isn't an input data system, but I need to run interactively a SSIS package, without specifying any input data. Is it possible a such operation? If possible, I'd like to use a code…
Pasquale
  • 21
  • 4
2
votes
0 answers

SSRS The request failed with HTTP status 502: notresolvable

I use Visual Studio 2015 for editing reports on Report Server 2014. All of a sudden I could not publish my editions anymore. I got the error: The request failed with HTTP status 502: notresolvable. (Microsoft.ReportingServices.RsClient). Every…
ASPaiva
  • 143
  • 9
2
votes
1 answer

How can I tell if my SSRS report is running as a subreport?

I have a report. The report has a header. Sometimes, users view my report by itself. Other times, they view it as part of a larger combined report. The combined report also has a header. So, in 'subreport mode' my report ends up with two…
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
2
votes
1 answer

How to build and deploy SSRS project through VSTS?

I created simple SSRS project in VS2015. I want to build and deploy the SSRS project using VSTS by creating the build definition and release definition steps. Is there any third party VSTS extension available or for SSRS build and SSRS Deploy not…
Pradeep
  • 5,101
  • 14
  • 68
  • 140
2
votes
3 answers

Formatting YYYYMM to MMMYYYY in SSRS

I would like to to format one of my data fields to be in the date format of MMM YYYY. For example, if "201209" is being returned, then I would like it to be displayed as Sep 2012. On the SQL side I am using a CAST to only look at the Year and…
Istaley
  • 359
  • 1
  • 6
  • 24
2
votes
1 answer

How to make SSRS report table transparent

i am using SSRS-2014 report for showing the table data but my table rows are having panels which are having background colors, because of that i am having one background image on report is not visible. Is it possible that will make the table rows…
Liquid
  • 648
  • 1
  • 7
  • 20
2
votes
1 answer

Dynamically changing Report's Shared Data Source at Runtime

I'm looking to use SSRS for multi-tenant reporting and I'd like the ability to have runtime-chosen Shared Data Sources for my reports. What do I mean by this? Well, I could be flexible but I think the two most likely possibilities are (however, I'm…
Jaxidian
  • 13,081
  • 8
  • 83
  • 125
1
2 3
…
12 13