Post reply

Use of Split Function in Reports

  • August 31, 2009 at 6:12 am

    #209321

    Hi EveryBody,

    Can you please telll me how to use Split Function in Reports.

    I have done in following way.but it displaying errors.

    1.=cstr(FieldName1.value).Split(",",1)

    Advance Thanks

  • August 31, 2009 at 7:29 am

    #1046863

    What are you attempting to do? A data example will help. I'm wondering if you're needing this function instead...this will take a multi-select parameter and parse them out by commas...

    =Join(Parameters!projectTypeID.Label,", ").ToString

  • August 31, 2009 at 7:38 am

    #1046867

    Hi, talk2riya15.

    Maybe you can try RAQ Report[/url], for it provides a great number of string functions for users. Of course, split() is one of them.

    Syntax:

    split( srcExp,sepExp{,boolExp})

    Argument:

    srcExp The string to be split.

    sepExp The separator.

    boolExp The parameter option which decides whether to split with the separator between two quotation marks, or brackets. True means to split, while false means not. The default value is false.

    Examples

    (1) =split("ab;cd;ef;tg;tt",";")

    The return value is ["ab","cd","ef","tg","tt"].

    (2) =split("ab;c'd;e'f;tg;tt",";",false)

    The return value is ["ab","c'd;e'f","tg","tt"].

    (3) =split("ab;c[d;e]f;tg;tt",";",true)

    The return value is ["ab","c[d","e]f","tg","tt"].

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

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

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