Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Use of Split Function in Reports Expand / Collapse
Author
Message
Posted Monday, August 31, 2009 6:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 16, 2010 10:58 PM
Points: 14, Visits: 98
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
Post #779821
Posted Monday, August 31, 2009 7:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 10:36 AM
Points: 171, Visits: 405
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

Post #779890
Posted Monday, August 31, 2009 7:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 14, 2010 9:09 AM
Points: 141, Visits: 187
Hi, talk2riya15.
Maybe you can try RAQ Report, 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
Post #779895
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse