Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Linking tables/formula problem Post Reply Post New Topic
Author Message
Barb
Newbie
Newbie


Joined: 15 Nov 2011
Online Status: Offline
Posts: 29
Quote Barb Replybullet Topic: Linking tables/formula problem
     Posted: 15 Nov 2011 at 4:59am
Hi All
 
 
Please help.
 
I am trying to generate a simple account listing with description filed dispalying Journal Entry filed from JDT1 or Line description from PCH1 table (SAP). I can get JDT1 description but ideally I would like to cerate a formula along the lines:
 
if jdt1 description=pch1 description than use jdt1 but if pch1 is null than use jdt1 description.
 
 
How should I do it?
 
 
Many thanks
Barb
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 15 Nov 2011 at 12:27pm
if jdt1 description=pch1 description then jdt1 description else
if isnull(pch1 description) then  jdt1 description else pch1 description

Edited by kostya1122 - 18 Nov 2011 at 4:51am
IP IP Logged
Barb
Newbie
Newbie


Joined: 15 Nov 2011
Online Status: Offline
Posts: 29
Quote Barb Replybullet Posted: 18 Nov 2011 at 5:02am

Thanks very much for that.

 

The formula is working but my parameter is not working correctly since I added this formula. For example: an account has 3 transactions posted in October 2011 but 9 in total for ytd the result shows 9 transactions *3 = 27 lines.  So if 1 invoice dated 1.10.11 there are 9 lines dated 1.10.11 and have the same reference number but description is picked up from each different 9 transaction therefore only 1 transaction out of 9 is correct, and so on with other 2 invoices for October.

 

 

I am very new to Crystal, your help is very appreciated.

 

please please please help
 

Thanks



Edited by Barb - 18 Nov 2011 at 6:03am
Many thanks
Barb
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 18 Nov 2011 at 10:17am
try to
group on {transaction number}
then move all the fields from Details to that group header
then suppress details.
IP IP Logged
Barb
Newbie
Newbie


Joined: 15 Nov 2011
Online Status: Offline
Posts: 29
Quote Barb Replybullet Posted: 21 Nov 2011 at 3:36am

Hi

 

Tried, partly works. Now the line details field is not correctly displayed against each transaction number and the total for each account is incorrect.



Edited by Barb - 21 Nov 2011 at 4:45am
Many thanks
Barb
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.