SSRS 2008 R2 Build Chart with WebService Data source RRS feed

  • Question

  • hi 

    I am using SSRS 2008 R2. 

    My data source is WebService and I trying to build Chart report, based on Dates from the WebService data. Which I cannot do because all data from WebService are just treated as String in SSRS. 

    Tried Cdate() didn't help in Chart type report.

    any suggestions or this is a show stopping limitation of the product? 

    Thanks Vivek SharePoint Foundation 2010 Book

    Thursday, July 16, 2015 4:12 AM

All replies

  • Hi Vivekthangaswamy,

    According to your description, you are using XML as data source to retrieve data, and you want to use the date type data in a chart, right?

    In Reporting Services, when using XML data source type to retrieve data, all data within the dataset are string. We can’t convert data to date type in dataset. So if we want to use date type data in a report, we could use CDate() function to convert date format values to date type values. In your scenario, since you mention data can’t be converted to date, would you please share the sample date?

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Qiuyun Yu
    TechNet Community Support

    Monday, July 20, 2015 9:13 AM