Post reply

SSRS Unable to save report

  • January 29, 2010 at 3:31 am

    #215137

    I have a report which uses date parameters and when the parameter choices are made the report runs without any issues, however I need to change it to use a relative date (yesterday) so that the report can be automated.

    When I make the changes to the current report (using report builder) I get the following error when I try and save the report.

    The Expression 'expr3' contains a Function 'In' with an invalid Argument '2': Literal without a-Path is required.

    The only change that is made is to the filter used by the report.

    Has anyone seen this before, Google is failing me today.

    Cheers

    Craig

  • January 29, 2010 at 4:21 am

    #1110615

    What does expr3 look like?

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

  • January 29, 2010 at 5:08 am

    #1110628

    I think this it

    ="To : " & Parameters!LastOrderDate.Value

    Thanks

  • January 29, 2010 at 5:13 am

    #1110630

    What is the expression you are using to assign the default value of yesterday to your parameter?

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

  • January 29, 2010 at 5:16 am

    #1110632

    I'm just using the filter menu in report builder, and selecting the relative date of 'yesterday', I've also tried 'n' day ago - but get the same result.

    As you might have guessed, this isn't a talent of mine 😀

Viewing 5 posts - 1 through 4 (of 4 total)

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