Yes, I worked out to add the customer join - eventually!

Any thoughts on how I could measure the date difference between the first ever order of a given customer and...

Thank you both for responding so quickly and for the code.

I was looking to get the differences between each purchase date rather than the average, if that's possible.....

Thanks Scott - that looks great.

(Un)fortunately I have left the office for the day but will test this first thing Monday.

Thanks again.

This is perfect - just what I was looking for!

Thanks for taking time out to write the code - much appreciated.

Thanks for the pointers. Using 2008 so will try using the row number function in a cte.

BO

Thanks John - got the report working the way I want it to.

BO

Cheers Laurie

I guess it's always better to do these things in T-SQL rather than SSRS.

BO

Cheers Chris

I'll give this a whirl.

Thanks for the really speedy response!

BO

Steve - that's what was missing....

I really appreciate your help with this - it was driving me mad!!

Thanks again

BO

Thanks for getting back Steve. I'm still struggling to get this to work. I create the new field as suggested and add a filter using this field in the child...

An update....

When I add the format(parameter name, "MMM yyyy") to the linked report parameters it does bring back the months relevant data but only for the first day of the...

Cheers guys - all really, really helpful.

I'm not sure which method I'll use - going to play around a bit with your suggestions.

Thanks again.

Thanks Phil for responding so quickly...

That's exactly what I'm looking for...

Will do!! 😀

Cheers Sean for this - greatly appreciated...