Apologies for my shopping list!

1)I'm running a QR that has 12 consecutive date ranges (months) from current backwards.The formula I am using for the current month is "if (Date+365-(30*12)in Current Fiscal Period then qty sold else 0". 12 is substituted by 11 etc for prior months. Am I missing a simpler way?

2)Also I would like the relative month name printed as header. The formula I have works but is quite a mouthful. Can you make any suggestions?

3)Can I build in more than 1 selectable range when running a report i.e. a customer and an item range?

4)Lastly (phew!) when details are suppressed and I suppress zero values, can I also suppess a subtotal line completely if all the values are zero for that line?

Thank you for a very helpful forum.

Kind regards,

Martin