Post reply

Using several values from database in comments field for email delivery extension in data-driven subscription

  • July 31, 2008 at 5:26 pm

    #188862

    In data-driven subscription one of values for delivery extension settings for Report Server Email is "Comment". I can (and do) select a value from database for it.

    How can I select SEVERAL values to be included in comment plus some static text between them?

    For example, now I select "Order number" as comment, but I would like the comment to be something like that:

    ='Order ' + DatabaseValues.Order_number.value + ' for customer ' + DatabaseValues.Customer_Id.value + ' has been shipped on ' + DatabaseValues.Shipment_Date.value

    So, Comment will be rendered as

    Order 07-7801802 for Customer 3073 has been shipped on 2007-10-04

    Can someone enlighten me how to do that?

    Thanks!!

    p.s. DatabaseValues is how I would call that collection if I would be designing the feature I am asking for, it probably does not exist (yet)...

  • July 31, 2008 at 9:16 pm

    #851631

    a function should be able to do what you want, although it's probably not the best solution. if you're doing a loop, you can also SELECT the fields into variables, then use them in your code.

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

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