Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: How to compare Costing Date and Accounting Date Post Reply Post New Topic
Author Message
angelyin1984
Newbie
Newbie
Avatar

Joined: 08 May 2009
Location: Malaysia
Online Status: Offline
Posts: 30
Quote angelyin1984 Replybullet Topic: How to compare Costing Date and Accounting Date
    Posted: 29 Dec 2009 at 1:31am

helo..hope somebody can help me in this problem....thanks in advance.....


Table1:
Company| Division| Year | Accounting Date| Item Number  |  CO No
999         |  101     | 2009| 02/Feb/2009     |  FKAFF000      |  0011012704
999         |  101     | 2009| 03/Feb/2009     |  FFAAZ010      |   0011012705
 
Data type for Accounting Date is Date Time.
 
Table2:
Company| Facility|  Costing Date| Item Number  |  Value Component1
999         |  11     |  20081224     |  FKAFF000      |  0.3938
999         |  11     |  20071201     |  FFAAZ010      |  0.8393
999         |  11     |  20080601     |  FKAFF000      |  0.4633
999         |  11     |  20070101     |  FFAAZ010      |  0.8685
 
Data type for Costing Date is Number.
 
My Report need look like this:
 
Accounting Date | Item No    | CO No          |Value Cost  |Costing Date
02/Feb/2009      | FKAFF000  | 0011012704| 0.3938       | 20081224
03/Feb/2009      | FFAAZ010 | 0011012705 | 0.8393       | 20071201
 
Based on the Accounting Date and choose the nearest costing date value to display.
 
How to do for this. I have no idea to do this. Please help.
 
Really need HELP! Thank you very much.....


Edited by angelyin1984 - 29 Dec 2009 at 1:32am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 29 Dec 2009 at 11:13am
Please don't cross-post.  I have already answered this question here.
 
-Dell
 
IP IP Logged
angelyin1984
Newbie
Newbie
Avatar

Joined: 08 May 2009
Location: Malaysia
Online Status: Offline
Posts: 30
Quote angelyin1984 Replybullet Posted: 30 Dec 2009 at 5:34pm
ok. sorry.Pinch
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.