hi ,

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

Because you need drilldown funtionality, I would recommend creating a formula for each PartID (if there is only those four or five parts in your table).

You can do it with Running total or creating your own formula with variables.

These formulas could be done also differently, but here is one suggestion. As you can see, this is not a good solution, if you have lots of columns to summarize, but with these four colums it is still working.

To group header (date group):
Global NumberVar Sum19Total;
Global NumberVar Sum13Total;
Global NumberVar Sum12Total;
Global NumberVar Sum10Total;
Global NumberVar SumAllTotal;
Global NumberVar Sum19;
Global NumberVar Sum13;
Global NumberVar Sum12;
Global NumberVar Sum10;
Global NumberVar SumAll;
Sum19Total := Sum19Total + Sum19;
Sum13Total := Sum13Total + Sum13;
Sum12Total := Sum12Total + Sum12;
Sum10Total := Sum10Total + Sum10;
SumAllTotal := SumAllTotal + SumAll;
Sum19:=0;
Sum13:=0;
Sum12:=0;
Sum10:=0;
SumAll:=0;

To Details section:
Global NumberVar Sum19;
Global NumberVar Sum13;
Global NumberVar Sum12;
Global NumberVar Sum10;
Global NumberVar SumAll;
//if you want only count, you can replace {Database.NumberToSum} with number 1
SumAll:=SumAll + {Database.NumberToSum};
Select {Database.NumberToSum}
Case '50019': Sum19:=Sum19 + {Database.NumberToSum};
Case '50013': Sum13:=Sum13 + {Database.NumberToSum};
Case '50012': Sum12:=Sum12 + {Database.NumberToSum};
Case '50010': Sum10:=Sum10 + {Database.NumberToSum};
)


You need add a formula for every variable to group footer (or where you want to print summarized data):
Global NumberVar Sum19;
Sum19;

Global NumberVar Sum13;
Sum13;
... and so on

And still totals for each column to i.e. page footer:
Global NumberVar Sum19Total;
Global NumberVar Sum19;
Sum19Total + Sum19;

Global NumberVar Sum13Total;
Global NumberVar Sum13;
Sum13Total + Sum13;

...and so on.