Search results for query: *

Ok, thanks for all you have done anyways, lets see if someone knows if a way exsit to set the date/time off a prompt.

OOo sorry I kind of missed the point there. Since these formals are populating an finical aging report and they would like to run historical aging reports so that is what the date parameter will be dictating, Aging as of {?date}

Ok, thanks – I was working on something similar to this and I see what I was missing now. It was not the system date I was looking to change but in Crystal (ver10) If you click on reports menu> set print date and time. The help menu said when you use aged0to30days it will directly effect the...

Ok, new problem/challenge I am working on with this same formula. I have no been asked if I can setup the report up with a date parameter. I know how to do some basic parameters but I can not see how to get it to work with this formula. It seems the built in aging function that crystal has runs...

LB, Ok yes your code works after I find the right table to pull from. I cna not use {RM00401.RMDTYPAL} I have to use {RM20101.RMDTYPAL} otherwise I get a couple of thousand recoreds returned. So it was bad info on my part there. Thanks for your help!

Does this help you at all? This is the output from the definition file. Crystal Report Professional v10.0 (32-bit) - Report Definition 1.0 File Information Report File: Version: 10.2 2.0 Record Sort Fields 3.0 Group Sort Fields 4.0 Formulas 4.1 Record Selection Formula 4.2 Group...

Here is the breakdown of what I am doing. I run an aging report based on all customers or just one customer. Here is what I get when I use the basic code to so 0/30/60/90plus days for aging. Here is an example output of the report with out checking for the 7 or 9...

That did not seem to work out, here was the basic code that I started with that gave me the results that I wanted minus the fact it shows all numbers as an absolute value. I really just need to find a way to add in an addition check against {RM00401.RMDTYPAL} to see if it is a 7 or 9 then I can...

I am working on an aging report and I am new to crystal. Here is the criteral that I have to meet. 1) RM00401.RMDTYPAL if this equals 7 or 9 and it falls in the 0 to 30 day range then the amount in CURTRXAM needs to be displayed as a negative in the report. 2) RM00401.RMDTYPAL if this is not...