1
  • SSRS 2008 R2 Trendlines

    I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet 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.

    NHSNick30 pointsBadges:
  • 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...

    tonyhid10 pointsBadges:
  • 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 be done after I convert each...

    DhivyaJ10 pointsBadges:
  • 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

    SoniaA5 pointsBadges:
  • 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...

    ITKE352,595 pointsBadges:
  • 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 data in...

    An2795055 pointsBadges:
  • 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 of 2008 (with...

    MrPryor15 pointsBadges:
  • 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?

    PrashantGupta5 pointsBadges:
  • 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.

    TheRicker5 pointsBadges:
  • (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:

    Amcintryre5 pointsBadges:
  • 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

    Deeanna5 pointsBadges:
  • 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...

    DrakeTeran5 pointsBadges:
  • 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 less than...

    Jeffkopsa20 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following