Post reply

Date period Expresssion

  • February 16, 2012 at 2:58 am

    #250762

    Hi everyone

    I know how to use an expression within a text box to show the period the report represents when there are paramaters in the report but how do I do this when there are not paramaters in the report? In other words how would I get the expression to recognise the max and min dates from a given date field so that this could be indicated in the text box?

    Any help greatly appreciated...

  • February 16, 2012 at 3:05 am

    #1447722

    Hi

    You should be able to use the built in MAX and MIN functions in Reporting Services on the date field

    http://msdn.microsoft.com/en-us/library/ms155828(v=sql.90).aspx

    http://msdn.microsoft.com/en-us/library/ms160317(v=sql.90).aspx

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • February 16, 2012 at 7:42 am

    #1447885

    Thanks for the prompt response!

    Is this possible in a text box where there won't be an associated dataset?

  • February 16, 2012 at 8:51 am

    #1447962

    No thats not possible but couldn't you assosiate the dataset with the texboxs and just take the MAX / MIN assosiated values from that column within the dataset?

    I'm making the assumption that the values that you are looking for are contained within your report detail somewhere so they should have a dataset to take the values from?

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • February 16, 2012 at 9:05 am

    #1447972

    I'll give it a go!

    Thanks for your help!

  • February 16, 2012 at 9:11 am

    #1447980

    No Problem - hope it works for you!

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

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

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