Crystal Rpts XI
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9864
Printed Date: 02 May 2025 at 5:43pm
Topic: Crystal Rpts XI
Posted By: JackVol
Subject: Crystal Rpts XI
Date 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
|
Replies:
Posted By: BrianBischof
Date 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>
|
Posted By: JackVol
Date 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
|
|