| | |
formula in Crystal Report 8
Please support our Computer Science advertiser: Learn about neural networks and artificial intelligence.
![]() |
•
•
Join Date: Jan 2009
Posts: 1
Reputation:
Solved Threads: 0
hi all,
sorry, if my thread in wrong place
i have 1 formula in my CR 8 like this
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
how the best formula for my case in condition if I run my report for 2 year period or above??
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??
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
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
![]() |
Similar Threads
- Issue about passing parameter to Crystal Report 11.. (Visual Basic 4 / 5 / 6)
- FiLtEr CrYsTaL RePoRt (VB.NET)
- Visual Studio 2005 Crystal Report (Defining a path to a Picture) (C#)
- Parameters in crystal report + vb.net (VB.NET)
- Passing values at run time through a JSP page to selection formula to crystal report (JSP)
- crystal report selection formula help pls (Visual Basic 4 / 5 / 6)
- Crystal Report + Stored Procedure returns no data (Visual Basic 4 / 5 / 6)
- Pass Criteria to Crystal Report 8 Using Visual Basic 6 (Visual Basic 4 / 5 / 6)
- crystal report related.........simple one......Please take 2 min to read this... (VB.NET)
- selction formula (Visual Basic 4 / 5 / 6)
Other Threads in the Computer Science Forum
- Previous Thread: Plz help me wid this program!! thankss
- Next Thread: Lets see if I did this right
| Thread Tools | Search this Thread |
ai algorithm algorithms amazon assignmenthelp automata battery bigbrother binary bittorrent bizarre bletchleypark blogging bomb business cern codebreaker compiler computer computers computerscience computertrackingsoftware connect csc data dataanalysis dataintepretation development dfa dissertation dissertations dissertationthesis dissertationtopic ebook employment energy extensions floatingpoint foreclosure foreclosuresoftware fuel gadgets givemetehcodez government graphics hardware history homeowners homeworkassignment homeworkhelp humor ibm idea ideas internet iphone ipod itcontracts jobs kindle laser laws linkbait lsmeans mainframes marketing mining mobileapplication msaccess nano netbeans networking news os piracy piratebay principles programming rasterizer research sam-being-cute sas science sex software spying sql stephenfry study supercomputer supercomputing sweden technology textfield turing turingtest two'scompliment uk warehouse ww2






