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 code...

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layo...

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 SSR...

any advice appreciated I have as a column heading the expression =WeekdayName(weekday(fields!date.value)) This returns the day of the week, however, it is returning a day of the week one day in a...

When I try to preview report in Visual Studio 2012 Designer I am getting an error: An error occurred during local report processing. An unexpected error occurred in Report Processing. An error occ...

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 expr...

I am trying to connect to Datasource but getting this error: An error occurred during local report processing. An error has occurred during report processing. Cannot create a connection to data ...

I've one main report with 5 sub reports. Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So I've used Join method to pass value from Main report to Sub Report) I'...

I'm using Join(Lookupset) to find unique group values which returns a sequence number. This is my function: Join(LookupSet(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Val...

Is there any chance to do vertical merge of fields in tablix? I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.

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...

I try to configure the report manager. It is sql2008r2 report service running on server 2013. There is no problem to pull the report. But I can not open the drop-down arrow besides the report to ad...

I have a field in SSRS that i need to filter on. For 3 table I can use a IN filter. But I am in need to use a NOT IN operator. The field contains numeric values. I need to be able to say not in (30...

I have the following query: SELECT TOP ( 10 ) EMPLOYEE , NAME , SUM(QTYFINISHED) AS QTY , SUM(HOURS) AS REALTIME , SUM(PROCESSTIME * QTYFINISHED / PROCESSQTY / 60) AS CALCTIME , SUM(PROCESST...

Earlier my client was using SSRS 2008R2 with Oracle as transaction database. Recently they have upgraded to SSRS 2017 and now many reports are throwing following error: ERROR: Throwing Microsof...

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 thi...

Is it possible to replace 0 with blank in ssrs matrix. The expression =IIF(IsNothing(Count(Fields!referralNo.Value)),0,Count(Fields!referralNo.Value)) is same as =Count(Fields!referralNo.Value). W...

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 t...

I've gone through quite a few examples on here and I apologize if I'm asking a repeat question, as far as I can tell, I am not. I have an SSRS report made that shows gross sales for certain aspect...

Solution: Wow.. just found the problem and answer to my question below. Had to do with Compatibility settings in IE 9. Once I added my reporting server url to my Compatibility View websites, every...

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 ser...

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 ...

Part of my query is like so: SELECT * FROM TableA WHERE ColumnA >= DATEADD(DAY, - 30, GETDATE()) With the expression at the where clause above, you can pull a rolling 30 days data without h...

To start with, I am completely new to SSRS reporting. Please excuse me if I miss any basic details here. I am trying to create a reporting service. Accidently, I have selected an existing Report Se...

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 ...