Here is a crosstab SP that was posted a while back. I think this is what you are looking for.

EXEC sp_CrossTab

  @table       = 'TEST',

  @onrows      = 'sCalldate',

  @onrowsalias = 'dhours',

  @oncols     ...

I to have pulled my hair out trying to find a way to create a master child report. My work around is as follows. I...