VarChar to Numeric in SSRS
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]

Answer Question   |  May 14, 2013  3:25 PM
SSRS 2008, SSRS reports

Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]

Answer Question   |  March 29, 2013  9:37 AM
Microsoft Excel 2003, SSRS 2008

SSRS 2008 R2 Trendlines
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.

Answer Question   |  October 25, 2011  8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

How to configure parameters display in SSRS 2008?
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia

Answer Question   |  March 31, 2012  11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008

SSRS Report switch for Operational DB to DWH
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]

Answer Question   |  February 16, 2011  2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

SSRS 2008 from SSRS 2005, Authentication
Currently I am running a 2005 SSRS Website, and 7/9 of my reports are done in 2005, and when I try access the 2 reports in 2008, it prompts me to enter my user name and password again, with this converter, will it solve this issue? I need a solution to get around the authentication [...]

Answer Question   |  October 21, 2010  10:32 AM
SQL Server, SQL Server authentication, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2005, SSRS 2008

Converting 2008 RDL to 2005 version
Dear All, 2008 RDL can be converted to 2005 version easily through a software. Please visit: applybi.com   Thanks & Regards, Amar Sale

Answer Question   |  October 22, 2012  2:08 PM
Database reporting, Microsoft Business Reporting Service, RDL, Report Server, SSRS 2005, SSRS 2008

Using Report Server in SharePoint 2010
In SharePoint Integrated Mode of SSRS 2008, how do you get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods? This question is from the Microsoft Live Chat which took place on June 1st.

Answer Question   |  March 2, 2012  8:15 PM
Report Server, ReportService 2006, Sharepoint 2010, SSRS 2008

SSRS 2008 and SharePoint programmatically
In SharePoint Integrated Mode of SSRS 2008, how to get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods?

Answer Question   |  April 23, 2010  3:49 AM
SharePoint, SharePoint administration, SQL Server, SSRS 2008, SSRS 2008 Sharepoint integrated mode

User defined function for an expression
I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008?  If so, how?  Thanks.

Answer Question   |  March 25, 2010  10:17 PM
SSRS 2008, UDF, user-defined function

(rsErrorOpeningConnection) Could not obtain information about Windows NT
I am trying to deploy a report to the Reporting Services Server 2008 but keep running up against this error:

Answer Question   |  December 8, 2009  6:41 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008, Windows NT

Refresh Reporting Services to view newly added sproc fields
How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008

Answer Question   |  November 8, 2009  4:27 PM
SQL Server Reporting Services, SSRS, SSRS 2008, SSRS reports

Additional SSL SSRS site within 2008 SSRS Integrated mode
We are installing OCS 2007 R2 that requires a secured (SSL – https) SSRS Site for their Monitoring piece.  We have an existing Windows 2008 Enterprise 64bit - SSRS 2008 Enterprise 64bit site that is integrated to Sharepoint 2007.  Could we use this environment for the additional SSL SSRS site?  Can two 2008 SSRS sites exist on the [...]

Answer Question   |  August 20, 2009  6:17 PM
OCS 2007, OCS 2007 R2, SSRS 2008

SSRS 2008 – Connection to Oracle 10g seems to be timing out
I’m running SSRS 2008 via Visual Studio on my desktop. The data source for my report is an Oracle 10g database. The report runs fine when the parameters are set to limit the number of rows returned, but when I change them to return more data it eventually times out. The same query runs in [...]

Answer Question   |  June 17, 2009  9:13 PM
Connection timeout, Oracle 10g, Oracle 10g connectivity, SQL Server Reporting Services, SSRS 2008