Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Unanswered: Expressions in SQL Server Reporting Services

    Does any one know what the expression is within SQL Server Reporting Services report manager to get the day of year part from an input parameter?

    I have the following but it keeps throwing an error:

    =Datepart("dy", Parameter!CurrentDate.Value)

    Anyone know what am doing wrong?

  2. #2
    Join Date
    Nov 2002
    ok, gotta admit I never used MSRS

    And I went looking for it

    I installed visual studio....

    Then the "tutorial" say to open up Business Intelligence studio

    In any case, I do, and it launches VS

    OK, so now I find another "wizard" the it asks me to connect using a connection string....what?? they're "wizard" can't use the usual dialog or reference an aliases I already have set up

    What a joke

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts