Post reply

Add Parameter to Report Title

  • May 10, 2010 at 1:23 am

    #222354

    My report needs to concatenate the following...

    String '333'

    +

    Parameter @start ( = date field - output needs to be in format 'YYYYMMDD')

    +

    String 'detail'

    I can put any one of these as my title but how do I put them all together and convert the date format of the @start parameter?

    Ged.

  • May 10, 2010 at 12:33 pm

    #1165174

    ged.burnett (5/10/2010)

    My report needs to concatenate the following...

    String '333'

    +

    Parameter @start ( = date field - output needs to be in format 'YYYYMMDD')

    +

    String 'detail'

    I can put any one of these as my title but how do I put them all together and convert the date format of the @start parameter?

    Ged.

    You want this all in one text box is that correct?

    if you open up the expression for that textbox. start with an equal sign and you'd have something like this....

    = "333 " & Format(Parameters!start.Value, “yyyyMMdd”) & " detail"

    you just have to be careful about where you put your spaces to separate the words.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • May 11, 2010 at 1:14 am

    #1165363

    Thanks Luke, That's cracked it!

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

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