i am doing a summary report in such a way  when i click any of the data it should  drill down to it`s details.

 

this will be my summary report .

 

 

                           Part ID

Date                   50019     50013     50012     50010     Total

 

11/5/2006            3             5              14          1         23                             

 

12/27/2006          7             4               6           5         22

 

2/13/2007            9             7              7           12        35

 

3/7/2007              2            5              15           7          29

 

4/15/2007            6            9              11          12         38

 

total                     27          30            53          37        147 

 

 

i use cross tab to represent this data....

is it possible for me to use drill down on this cross tab???

 

if not what other method would u recommand me 

 

 

thanks