Search results

Hi, Help would be appreciated. Using CR 9 is there a function I can put in a formula which means it calculates the date a year before? For example, if todays date is 09/04/08, I want the formula to produce 09/04/07. This is similar to a previous posting by Eany but I don't want to use...

Hi I do not know what an SP is but I do know that formulas fields can be picked up by selection formula. Perhaps if you created CurrentDate and CurrentDate-365 as two formulas fields these can be selected to give you your automatic date range.

Hi I have a subreport which lists a table of information:- Jan 123 Feb 124 Mar 456 Apr 567 I then want the main report to search down the first column and pick out the corresponding figure in the second column. ie. for Feb it would return '124'. I also need it to return '0' if the month being...

I'm not sure what this means but I will see if I can get it to select only the ones with earliest date using a formula. Thanks this has given me something to try.

Thanks for your reply. I have tried this and it doesn't do it.

Hi Help would be grately appreciated. Date Code Amount 09/03/2007 ABC001 £5,915.50 23/04/2007 ABC001 £4,074.00 20/05/2007 ABC001 £120.23 16/05/2007 CAD012 £479.50 20/05/2007 CAD012 £125.50 21/03/2007 QWE098 £54.50 The above are group headers where the Amount is a sum of...