Date Range Query Q

[elead]

Here is my dilema. I need to generate a report that would be derived from a start date parameter and a stop date parameter. These 2 params would always be in the current month. They will calcualte a percentage and average for the week specified in the params. That same report also needs to do the same calculation for month-to-date figures as well. How can I get all the data I need for the total month calculations and only show the week results based on the day start and day stop params.

Thanks

 

[dcm]

elead: 2 suggestions - make your record selections based upon month to date to the end date and then return your wekk results as either formulas or running totals which are based upon date in start to end

or

create a subreport with record selection for month to date of end param and therefore contains month values and join this to week results main report through the use of the end date param

HTH David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner