Hi Julie

Just as you respond I found the issue. I am using data from a third party which is in the form of a Consolidated Plan containing 40+ projects. However!!!!!!!! He has consolidated plans within consolidated plans within consolidated plans within consolidated plans........ If you get my meaning :-). Once I split the plans out and just consolidated the "individual" 40+ plans it works perfectly.
Hope this helps others working with Visual Reports and want to report down to weekly Resource Usage level which is what I am doing.
Many thanks for your response.
Kind regards
Tony
p.s. I am only a "trainee" programmer" :-) but I get by with help from John on the MSDN Forum.