YTD Totals 1

[mrtanner]

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 the answer for me

Thanks

Mr Tanner

 

[dgillz]

Enter a record selection formula of:

{YourDateField} in {?DateParameter} to dateadd("yyyy",-1,{?DateParameter})

This will return everything in the year prior to your date parameter. Read the help files on the dateadd() function to get the various agruments you can use in place of "yyyy". This is a very powerful function.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mrtanner]

Thanks for your speedy answer. Am about to try your suggestion.

Mr Tanner

 

[AndyMc]

Thanks, dgillz,

This is really helpful for me!! I've accomplished the same thing in the past much more painfully. I'll use this function going forward.

Andy