you are right. i have already made this report in SSRS.

but my mgr wants it in dynamic report itself...

could you please help me? i really need some urgent help in this regard.