Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Crystal Rpts XI Post Reply Post New Topic
Author Message
JackVol
Newbie
Newbie


Joined: 29 Apr 2010
Location: United States
Online Status: Offline
Posts: 2
Quote JackVol Replybullet Topic: Crystal Rpts XI
    Posted: 29 Apr 2010 at 10:30am
Is there a way to Combine 2 Date Fields From a DataSource into 1 Field on Report and sort on it ? I'm aware of Sql Query Method, but this is based on Epicor XML Data File.
 
Thanks
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 29 Apr 2010 at 3:05pm
You can create a formula and sort on the formula. For example

{table.field1} & {table.field2};
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
JackVol
Newbie
Newbie


Joined: 29 Apr 2010
Location: United States
Online Status: Offline
Posts: 2
Quote JackVol Replybullet Posted: 30 Apr 2010 at 2:13am
Thanks for reply. Let me explain it better. I have a Customer Statement with Invoice Date and Transaction Date  on  Statment one is on Group header and one on detail line underneath, but user wants them sorted as 1 column(see example) Do you know if this is possible The data is in an XML Epicor File which we don't really have control over to query . When I concatenate fields and sort it only sorts on first field , so they aren't really sorted on all fields
 
Now:
 
Grp Hdr         3/1/2010
Grp Hdr         10/1/2010
Detail Line    1/1/2010
Detail            2/1/2010
Grp hdr         1/1/2010
 
Desired:       1/1/2010
                     1/1/2010
                     2/1/2010
                     3/1/2010
                    10/1/2010
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.