Joined: 30 Dec 2008
Online Status: Offline
Posts: 8
Topic: Formatting Results of Concatenated Fields Posted: 12 Jan 2009 at 9:20am
I am trying to put 2 fields together, but it's not easy as straight concantenation...
First, field one is a timestamp / field two is a number. Both fields need to be 'brought together' with a dash between them. Second, field one has to be formatted YYYYMMDDHHMMSS (no spaces, no separators). Field two has to be formatted as a whole number, NO Decimals (currently comes up 1.00, 2.00, etc) So, the output for 1/12/2009 10:58:33AM with the added number 1 should end up looking like: 20090112105833-1 (Currently I get 1/12/2009 10:58:33AM-1.00)
Field one is the result of a formula (that I received from this forum http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5114) and field two is the result of a formula using PageN as the starting point. The report will be formatted for labels - 14 per page and there will only be one page.
I may change the timestamp use CurrentDateTime as I may not need the functionality of the formulas documented above. Therefore the CurrentDateTime will be field one.
After all is said and done, THEN I can barcode it...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum