formula in Crystal Report 8

Please support our Computer Science advertiser: Learn about neural networks and artificial intelligence.
Reply

Join Date: Jan 2009
Posts: 1
Reputation: angel.lim is an unknown quantity at this point 
Solved Threads: 0
angel.lim angel.lim is offline Offline
Newbie Poster

formula in Crystal Report 8

 
0
  #1
Jan 9th, 2009
hi all,

sorry, if my thread in wrong place

i have 1 formula in my CR 8 like this
if left(ToText({tbsubledger.subledgerdate}),4)=ToText({tblpercentage.percentyear}) then
     {tblpercentage.percent}

result from formula above will be suffixed with "ADM's EXPENCES". Formula work fine if I run report from 1/1/2007 - 31/12/2007 ( 1 year ),

but if I run report from 1/1/2007 - 31/12/2008 ( 2 year) or above, formula return me zero.
it should be

(percentage 2007 + percentage 2008) * ADM's EXPENCES

how the best formula for my case in condition if I run my report for 2 year period or above??
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: formula in Crystal Report 8

 
0
  #2
Jan 12th, 2009
Try to move your thread to C# or VB.NET forum.
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC