Hello,

I really have a big problem,

I am building this report (in data access page format!!!) that will
list a summary of my service
bills.

----------------------------------
Bill ID  /  Productivity  / Gross
1000     /  90%           /   70%
1001     /  87 %          /   60%
etc.
----------------------------------


Now, what is important to know is that the list up there sometimes
includes many lines and the numbers are only a sum of calculation. 
When I read my list, I would like to have the liberty to simply click
on the bill ID (hyperlink) and go directly on a detailed report.  I
have not been able to do this since the bill ID change daily.  HOWEVER
I have been able to group them in a DATA ACCESS page and just click on
a + to view some details.

This proccess is good but seems to be limited.  I order to get all my
data listed, I need to create many groups and It get all mixed up
after a while:

this is what I want:
  ----------------------------------
  Bill ID  /  Productivity  / Gross     (groupe A)
  1000     /  90%           /   70%
- 1001     /  87 %          /   60%
  *(groupe expansion)

     Details for Bill id 1001:          (groupe B)
     Milleage / model   / close date
   -  20 000  / sunfire / 23 may 02
     *(groupe expansion)

        Line # / time done / time sold / productivity   (groupe C)

            1        .5           .5          100 %
            2        1            .8          80 %
     
        Line # / Labor cost / Labor sold / gross         (groupe D)

            1        20$          50$          60%
            2        30$          60$          50%


-------------------------------------------------------


The problem is on Group C  and D  and the others that will follow. 
Right now they are linked one under the other.  I would actually like
to have groupe B-C-D-etc all linked to A.  So I can configure that
when I click on A all the other expand automaticly and SEPERATLY. 
This is my problem because right now they are crossed like this:

---------------------------------------------------------------
   -  20 000  / sunfire / 23 may 02
     *(groupe expansion)

        Line # / time done / time sold / productivity   (groupe C)
            1        .5           .5           100 %
        Line # / Labor cost / Labor sold / gross         (groupe D)
            1        20$          50$          60%
        

        Line # / time done / time sold / productivity   (groupe C)
            2        1            .8          80 %
        Line # / Labor cost / Labor sold / gross         (groupe D)
            2        30$          60$         50 %

-----------------------------------------------------------------

Basicly I can solve this by only expanding manualy the last line of
each group but I want it automatic.

Does anyone know how to solve this?

I think that one way to do it would be to have subreport in data
access pages but it seems to be limited to reports!

You may want to provide a basic table structure in order to help
answer the question.