Thanks Eddie.

I try to folow your advise not to use group by, however the error message below is appeared. How do I get around with this ?

Thanks again 

An error occurred...

I also have the same problem

even though I have force my date time to UK but when I use date picker always says that the value is not correct.

so I...

Thanks for that.

works well now.

Yes - I have done it using drill down.

btw - I have another question if we want the report to appear in lanscape format - How do we do it?

The...

I tried your suggestion and you are right a bit messy.

I would like to have a reports with not many columns 

unfortunately only this report can't...

Hi Martin,

I have tried your method before it still doesn't work.

I have even troed every possible way but still...

well I guess right now I will use your 1st advice and...

Thanks Martin.

I follow your suggestion.

However I could not set my @startdate and @enddate as datetime type in report parameter  only as ‘STRING’

It...

I think you have similar problem with mine.

I guess you can try Martin's suggestion or try below

This is what I do

Edit your dataset

SELECT     NULL AS Code, 'None' AS Description

UNION

SELECT     Code,...

Additional info :

 if I manually force to fill startdate and enddate with ‘yyyy/mm/dd’ format in preview ( VS2005), it works.