beltmanjr,
Thanks for your answer. Yes I think that may be the best solution, simplify and work from there. I will check out the link you provided with interest.
Thanks again
Mr Tanner
Tatertot45,
Unfortunately I don't need a YTD figure but a figure of the debtors as at the same time in the previous year.
Thanks for offering your help and I will keep those formulas in mind for future reference
Mr Tanner
Hi Guys,
Got another problem with prior year formulas. I am using an Oracle 9 database with Crystal Reports XI. This is the formula I am trying to edit but with no success:-
select
d.descr as department,
n.refno as bill,
m.fileid,
c.name,
c.nclient...
Mate,
It seems to be working now...Don't know why but I'm not complaining..Thanks for all your time and help with this problem.It really is appreciated..
Mr Tanner
Ok, I got a result. I used the record selection ( I guess thats what you meant) of greater than or equal to 01/07/2005 since that is the earliest data we have. The total doesn't equal the total shown in our reports but at least we have data.
Was the record selection what you wanted me to do...
lbass,
I don't have a record selection.
Here is the info from Ken's tips which as far as I can see says that there is no record selection for this and there isn't in his example and should just give info for the previous year to current date:
69. Calculating fiscal YTD (Report 67)
The Crystal...
lbass,
Yes I am putting the formulas in details and then summing them in the report footer. The only thing I can see that's different from Ken Hamadys formula is that when I browse the data for @fiscal year, all years show where as in mine the only year I get is 2008?
This is his formula...
Thanks lbass. Forgot to put these in.
Here they are-
Fiscal Year:
Year ({NMEMO.DISPATCHED}+184)
Current Fiscal Year:
Year (Currentdate + 184)
Our Fiscal Year is from 1st July to 30 June.
Thanks again
Mr Tanner
Hi Guys,
I have checked out all the threads to do with this and nothing seems to work. I have downloaded Ken Hamadys formulas and have been using them but can't get this to work. I have created formulas for fiscal year and current fiscal year. The formula for YTD works beautifully but when I...
Hi,
I am using CRXI and have to do a report that shows data as at whatever date I put in the paramater and then for same time 12 months prior and even 24 months prior.. I am only reasonably new to this however I have searched for days on something that would help me..
Hoping someone here has...
I have created a forumla that give me a % figure of Net Profit to Gross Income. It involves various summaries. My problem is that it doesn't give me the right answer, although when I browse the data of the formula, there are two totals, one negative which is wrong and the correct one below it...
The only errors in the event viewer states:A fatal error occured while creating an ssl server credential. I don't use the web server in exchange so I didn't think this would be the source of the problem
Gary
The SMTP is receiving mail from the outside world but not sending. It is staying in the que on the server. I have rebooted the server and stoped and restarted the smtp service without any success.
Any ideas anyone
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.