Bubai Banerjee

Bubai Banerjee

  • 1.2k
  • 163
  • 45.1k

Pivot Result Display

Aug 16 2012 5:14 AM

Hi  Sir,

I have doubt can you please help me..I am very new in s/w Development.

below i am describing.

Original Table Structure.

ID                Date             TimeLogged        UserName

1             10/8/2012               5.50                      Bubai

2             11/8/2012               2.30                      Bubai

3             10/8/2012               3.30                      Bhanu

4             11/8/2012               7.30                      Bhanu


I want result like below. User Name should be dynamic. May be lot of

users. User name will come from Database table. Please give me broad

description as I am very new in the system, for my understanding.

Date                    Bubai               Bhanu                     Total

10/8/2012              5.30                   3                         8. 30

11/8/2012              2.30                  7.30                       10

  Total                      8                    10.30                   18.30

Please help me to solve this issue… It's really urgent

if you can reply early I'll really appreciate. Thanks in advance.

 

Thanks and Regards
Bubai Banerjee


Answers (8)