Never name it.

Crosstab report. It can be done in many ways, ideally people love to take some granular level data and manipulate and apply that in different template. Advantage of granular level data : We can use it for some other RTF template. We can show that the way we need to. If you pre-group, then your report will be faster. But you use the flex of using the same data for showing it different layout. since you pre-grouped it, its fixed data for some layout. You use this flex here. its a trade off on flex or performance, i choose go on the balanced line of these two. Forums thread with issue 1. it should be pretty simple in BIP template too. 2. have a look the thread link , i answered how to do it in Datatemplate. 3. Db rollup is also good option but for the answer at OPTION 1 look at this picture.

How to sum up , row and column in the template ?

Got an good question from shahcsanjay who has done the dymanic column , then then got the sum in the horizontal manner, but what he wanted is sum up through the vertical too :) ?for-each-group@cell:current-group()/G_TIME;./TIME? ?sum(current-group()/TV)? ?end for-each-group?, he got struck wiht, i asked his template, after snoozing through that, gave him that loop, which solved it. again a cup of thanks :0 from Sanjay. Opps, i wanted to write all the cases in this blog, but time is not permitting and iam facing similiar issues, daily, got to give a shot, that some generic stuffs like what Tim is delivering there in his Den. hope i will start that soon :)