Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trying to format a field from SQL to Crystal.
Fantastic this worked very well! Thank You so much for the help!- 32ndFlava
- Post #6
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Trying to format a field from SQL to Crystal.
It also says that "This array must be subscripted. For example: Array [i]." refering to the 'x' in the split(x," ") statement.- 32ndFlava
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Trying to format a field from SQL to Crystal.
OK, Say the Field I want to pull in from SQL is named "FullName" how would I incorporate that into the formula? Would the "FullName" go in place of the 'x' in the following formula you created? //{@Firstname}: stringvar array x := split(x," "); if ubound(x) = 3 then stringvar fname := x[3]...- 32ndFlava
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Trying to format a field from SQL to Crystal.
I am building a report and need some help with formating the name field. In the SQL database I am using the name field shows the "Last, Middle First" all in the same field under a title of "Name". I need to create some sort of formula to put the input of "Last, Middle First" onto the report as...- 32ndFlava
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
