Post reply

Datetime Parameter in ssrs

  • March 18, 2010 at 2:35 am

    #216685

    Hi,

    have created a report with datetime field as parameter. Everything works fine in BI preview.

    But when i try to select the datetime option in Internet explorer

    Its giving follwoing messgae.

    The value provided for the report parameter 'filedate' is not valid for its type. (rsReportParameterTypeMismatch)

    Datetiime field in table is in format as below.

    2009-05-01 00:00:00.000

    Pl let me know how to fix the problem in IE.

  • March 22, 2010 at 11:59 am

    #1137734

    Try adding a "Calculated Field" to the Query you are polling for the available parameters. Set the formula for that =CDate([datetime field from your query]) and point your parameter values at that column for the "Value".

  • March 22, 2010 at 12:15 pm

    #1137752

    you could try to use

    =FormatDateTime(Fields!fieldname.Value, DateFormat.ShortDate)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply