I'm not clear on what your data looks like so it makes it hard to answer your question. Could you elaborate and give an example of the data so we can try to give you suggestions.
Cathy
>I am need to create a report with counts for mulitple fields, with multiple values. I was hoping that the vfp9 upgrade would be able to do this without a lot of cursor prep,using multiple detail bands.
>
>The report would have the headings "Field", "Category", and "Counts", with totals for each group.
>
>There really aren't any good samples for something like this.
>
>Much thanks for any advice.
>NK
>
>Example of data to show:
>Field: Services Requested
>Categories with Counts: AE-Assessment 7
> AL-Advocacy Legal 3
> javascript:MessageSubmit()
>[Save this message so it will appear for other members immediately] C-Counseling 2
> -----
> TOTAL 12
>
>
>Field: Services Provided
>Categories with Counts: G-Group Services 5
> IR-Info Referral 2
> S-Shelter 3
> -----
> TOTAL 10