Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

formula in Crystal Report 8

Comment:

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??

Package Migration Wizard

Sql query to stop a servi...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Need help with formula: Example: If you have a product that is priced by the hundreds, I would put the letter "M" in cell next to the price and a formula in another cell that would multiply the qua...

Summary: I am trying to use DCount in a report and running into an issue with setting one of the criteria to a string variable. When the report is opened, an input box pops up and asks the user for a parish id...

Summary: Do you mean the next time you EXIT the workbook and open it again? Formula's really do not work like that. They are more like calculators. And because the data hasn't changed since you last exitted th...