Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
8
votes
2 answers

Can I create SSRS Reports in VS 2015 using SQL Server 2008 R2?

I'm new to SSRS. Recently upgraded my development environment from Visual Studio 2010 to Visual Studio 2015 Enterprise Edition. Currently my reports are made using Crystal Reports. I would like to to use SSRS and I'm trying find out my current…
Brian
  • 101
  • 1
  • 1
  • 6
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
8
votes
4 answers

Could not load file or assembly error on adding custom libraries in SSRS reports

I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client. I added this custom Dll codelibrary.dll to my SSRS report. and the expression of…
perplexedDev
  • 857
  • 4
  • 17
  • 49
8
votes
3 answers

How to trigger a SSRS Subscription based on an event?

Is there a way by which I can trigger a SSRS subscription (Time based) whenever there is an event like file created in a shared folder? Can we do it with powershell or C#? Is there a out of box feature available in SSRS (though I don't think there…
AJ01
  • 235
  • 1
  • 3
  • 16
8
votes
2 answers

How to sum SSRS Matrix Columns on Row Group

I have a report that displays the total hours a person worked for each project they are assigned to, aggregated on month. I would like to sum the total hours for each person, for each month, in SSRS 2008 R2. So, for example, I have the follow data…
Rob
  • 161
  • 1
  • 1
  • 10
8
votes
4 answers

SSRS Column Width growing, Text not wrapping

I am creating a report with SSRS, SQL Server 2008-R2. The report has a few matrices, each with the same number of columns, pulling data from different data sets, to give the appearance of a single table. When I render the report in VS, the columns…
user1873604
  • 163
  • 1
  • 1
  • 12
7
votes
1 answer

Left with 0 client certificates to choose from when accessing SSRS management.

Environment: Reporting Services running on a SQL Server 2008 R2 SP3 installation on a Windows 2008 server with .Net 4.6.1 installed and .Net 3.5 enabled as feature. IIS, database and reporting service all in the local machine (custom login URL in a…
Ignacio Soler Garcia
  • 21,122
  • 31
  • 128
  • 207
7
votes
2 answers

Build tool to convert SSRS projects report RDL schema from 2016 to 2008 version

I have a number of SSRS reports that are currently in 2016 schema and need to be converted to 2008 R2 schema upon build. Does anyone know how I can achieve this? Is it actually possible to do this? Does Microsoft provide a tool for this purpose? It…
Mark
  • 501
  • 2
  • 11
  • 28
7
votes
1 answer

SSRS Formatting for negative numbers

Ok, so I am familiar with formatting the colors of a cell like this =IIF(SUM(Fields!Dollars.Value) < 0, "Red", "Black") but, I have inherited a report that has 80 columns and 4 rows of calculated fields which all print out black. I have been tasked…
Jmyster
  • 965
  • 2
  • 9
  • 27
7
votes
4 answers

SSRS Extract substring from string before the second string

I have a field which is like the following 4444-4444-TestingItem1. Is it possible for me to extract the field up until 4444-4444. if so how would I do this? What function would I use within SSRS. Please note It could be any number of characters…
a415
  • 359
  • 1
  • 6
  • 23
7
votes
5 answers

I want Datetime Parameter in DDMMYYYY Format in ssrs report

I want to change the Datetime parameter to DDMMYYYY format.its default value is MMddYYYY.when user will select date from date picker the date should be display in ddmmyyyy format. I tried all expression like =Format(Parameters!DateFrom.Value,…
Rock
  • 161
  • 2
  • 6
  • 17
7
votes
2 answers

SSRS and PowerShell: Get report as Excel

I'm trying to make PowerShell send a web request to our SSRS server and capture the results. I've hit a wall using the rs:FORMAT=EXCEL parameter in the SSRS url string. I have the following: First, init the credentials: $User =…
steenbergh
  • 1,642
  • 3
  • 22
  • 40
7
votes
1 answer

Is there any possibility to Deploy Single Report in SSRS

I'm having problem with SSRS Report Deployment. I've 2 Hundreds of Reports in my SSRS Report Solution. When, I deploy the Report it deploy all reports which is very time consuming. Now, what I'm looking for is, I want to re-deploy only the Report…
N Subedi
  • 2,858
  • 2
  • 22
  • 36
7
votes
1 answer

Show Window Account User's full name in report

I want to display the full username in my SSRS report. I used =User!UserID which gives domain\login. Can I get the full name of the user like Tom,Cruise, instead of abc\tcruise.
user1046415
  • 779
  • 4
  • 23
  • 43
6
votes
2 answers

SSRS - Excel data source error when report deployed to localhost report server

I need help with an SSRS report deployed to localhost which uses ODBC data source to retrieve data from excel file. When the same report is previewed through BIDS 2008, it displays the results as expected. But after deploying the report to the…
Romanshu Goel
  • 103
  • 3
  • 9
1
2
3
…
99 100