Crystal Reports can do everything you need. You can setup a parameter field for the select and have CR do a SQL SELECT against the data. It can then sort, group, total, etc.

>Hi,
>
>With CR, what is the best way to had all the need data in the rpt file.
>I don't want to use a PRG file to pull all the data.
>
>Please kindly give me some guide on this area so that I can had all
>my needed data in the CR
>