Home Forums Reporting Services Reporting Services Trying to add a date parameter in Report Builder 3.0 RE: Trying to add a date parameter in Report Builder 3.0

  • July 31, 2014 at 9:00 am

    #1734109

    Thanks for the prompt reply.

    I tried this:

    Select create_time,

    From ticket_history

    WHERE create_time = @BeginningDate

    And I got this error message:

    TITLE: Microsoft SQL Server Report Builder

    ------------------------------

    An error occurred while executing the query.

    ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'From ticket_history

    WHERE create_time = @BeginningDate' at line 2

    ------------------------------

    ADDITIONAL INFORMATION:

    ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'From ticket_history

    WHERE create_time = @BeginningDate' at line 2 (myodbc3.dll)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------