Thanks for the replies...

gkerscher, your solution seems like a better work around. I will definitely try and post if it works.

Thanks

RG

Sorry, I am unable to interpret. Please find the XML attached and suggest me where I went wrong

Thanks,

RG.

getting dates is not my issue here.I have done that by outer joining to another temp table (it is populated by dates)

My issue here is:

The records for employees who do...

Please find the desired O/P format

Luke,

Unfortunately I can not post the RDL file now. I have done the same as you did except for addding an expression for hours to format NULL value with '-'...

Luke,

Please find the attachement that has data and my code. I think this makes the idea clear.

Thanks,

RG

Thanks for your response Michael

Actually, it is not the problem with code. I was able to see the data correctly in SSMS. Everything is fine. But when I am...

Thanks for your response Luke,

I am displaying it in Matrix report.

There is grouping on employeename

But the issue is I was able to see the data correctly in data tab, but...