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!
-
Joining Padded and Non Padded Fields (JD Edwards)
Thank you for your reply. Since I'm joining 2 different databases in Crystal Reports, I cannot edit the SQL statement through Crystal. I guess a custom view (arrrgh!) is my only solution. Thanks again, P Manney- manney
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Joining Padded and Non Padded Fields (JD Edwards)
I'd like to report against our company Job-tracking database and JDE OneWorld. The only commonality is our company Job Cost Number (JCN). Our implementation of JD Edwards OneWorld uses fields which are padded with spaces; our Job Tracking system uses an unpadded field. When the two tables are...- manney
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Memo fields in formulas Aarrgghh!!!
A memo field can be parsed into 256 byte segments by use of the SQL SUBSTRING function. The resultant field(s) can be tested, concatenated, etc. The SQL expression is fn SUBSTRING ({Table.MemoField}, StartChar, EndChar) This does not work on all systems (depends on the SQL implementation of...- manney
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
