Master and Subreport in Same Format, How to Make that Happen RRS feed

  • Question

  • User-934748391 posted


    I have this table in my database:

    Agency  Client   Amount

    A           25        $560

    A           30        $720

    B            25       $1000

    I want to build a report, once the client open the report, it should include:

    First page is titled All Agencies, and with group each Client togeter then show the total, like this:

    Agency: All

    Client ID   Number of Client      Amount

    25                    2                     $1560

    30                     1                    $720


    Total:                3                     $2280

    I know how to do this, but I want the second page just exactly the same format, but only for Agency A, then third page only for Agency B.

    I am not very familiar with CR, don't know how to do this, please point a direction, thanks.



    Friday, February 24, 2012 11:29 AM

All replies