Post reply

Formatting the value of a parameter

  • March 14, 2011 at 5:43 pm

    #246912

    Hi All,

    I am new to this forum and looking forward to learning as much as possible from you all 🙂

    I am currently working on a reporting project in SSRS 2008. One of the parameters returns the following value:

    [Contract PC].[Contract_H].&[c05d50b60a0a7805005cbc56440827e4]&[3ee0df8c0a0a780501ff1bdfceaf3fb0]

    There are a few other cube based dataset which also use the above parameter and value, but the new dataset I have created is a SQL based dataset. The value I need from this parameter value is: 3ee0df8c0a0a780501ff1bdfceaf3fb0

    Without creating a new parameter, I need to extract the value I need (3ee0df8c0a0a780501ff1bdfceaf3fb0) from the parameter value.

    What would be the best way to extract or format the value I need from the Parameter value so it can be used in my SQL Dataset Query?

    Look forward to hearing from you.

    Regards,

    Robbie

  • March 15, 2011 at 6:13 am

    #1298782

    Is it the same number of characters all the time? Can you take the Right X number of characters?

  • March 15, 2011 at 9:55 pm

    #1299201

    I agree with Daniel. That "field" appears to be a GUID. GUID's of that nature will always be 32 bytes. You could simply take the RIGHT(33) and then the LEFT 32 to get your "field" of data.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 16, 2011 at 4:55 pm

    #1299726

    Thanks guys 🙂

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

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