• sgmunson - Friday, March 9, 2018 12:31 PM

    clai_shock008 - Thursday, March 8, 2018 7:09 PM

    sgmunson - Thursday, March 8, 2018 8:06 AM

    Seems likely that you have a data type issue.   What data types does MySQL support?   If they only support datetime as opposed to just a date (without time), then you may have no alternative but to use either OPENQUERY or OPENROWSET as part of your overall query.     That portion would specify the Linked Server (existing or temporary) and the native MySQL query, which would become a table you could use as part of a T-SQL query that could then CONVERT the relevant column to date as opposed to datetime.   However, we don't have any detail here as to exactly how you connect to the MySQL instance, so let us know...

    mySQL does support DATETIME but I think it's all about the incompatibility of the mysql syntax using SSRS.

    I finally found a way to fix the issue in this grouping of dates. I just managed to create a group expression in my chart report. 
    under Category Group Properties i added:
    =Year(Fields!collecteddate.Value)
    =Month(Fields!collecteddate.Value)
    =Day(Fields!collecteddate.Value)
     🙂

    SSRS doesn't support mySQL syntax.  SQL Server can if you use either OPENQUERY or OPENROWSET as part of the query, although at that point, you would access the mySQL instance via a Linked Server as opposed to connecting directly to it.

    will it minimize the performance using OPENQUERY/OPENROWSET?