Hi

I want to do the following using  crsytal report xi.

I have a table which contains the following info:

a) Product Code, b) CurrencyCode , c) FOBAMT , d) DocDate and e) DocNo

Each record in the table will have different or same currencycode by productcode.

The requirement is to print the report as follows

Product Code ( Group)

    DocNo  DocDate  CurrencyCode   FOBAMT           ( Detail Printing)

     1         01/07/11  USD                     120
     2         01/07/11  SGD                     201
     3         04/07/11  USD                     120
     4         10/07/11  SGD                     205
      5         12/07/11 USD                     120

At the end of ProductCode Group break

we need to print the summary as

      CurrencyCode                   Sum (FOABMT)

           SGD                                406
           USD                                360

         Total                                766

At the end of the report to print the summary for all productcodes combine

CurrencyCode                   Sum (FOABMT)

           SGD                           99999
           USD                           99999   

         Total                           99999


Any help will be greatly apprecated

since this answered in another post recently, the statement was to make a cross tabs report for the summary.

you probably can't, not directly.  If a crosstabs object won't work, you will need to use a subreport...it's the only option left.