Hello All,

I am having an issue with grouping/sorting.  I have an Access Database, with about 70 records.  Of these 70 records, I have a field "category", that can have about 14 different "categories", and need to have all these records show.

However, when I select a category in the "select expert", after creating many groups, it only shows that one group.  It seems as if I change one of the groups to a different category, it changes them all.

Basically, I need to have a report that shows all these different groups, but separately.  I have tried using all subreports, but that will not work for my type of report.

Thanks,
Adrian

Oh yeah - if you want to display all groups, but separately then you can do page breaks after the group footer. Is that what you want?

Okay, I'll be a little more specific.

I have one table, with 70 records, in which I need separated by the 'category' field.  I have 14 different 'categories'.  In these categories, I have a field called 'finding', that we are numbering, and the numbers have to refresh in each category.

I guess I am not understanding how the 'group' function works (and I have the Crystal book, a little confusing for this section).  Do I need to create 14 different 'groups' for all of this data to show, or just one 'group'?  I have tried both, but when I do a preview, only the information for the last 'category' is shown, not all 14. 

I have created this 'grouping' in a subreport, as that is where my layout is for all of this information.

Thanks,
Adrian

Thanks, that did some of what I need to be done.  I also need a page break in between each category, and for the numbering scheme to start over in each category as well.

Any ideas?
Thanks,
Adrian

Awesome, that worked.

I have one other issue right now.  On each page, I also have a 'finding' field, which is followed by the crystal special field 'record number'.  On each new page (for each new category), I need to have that record number to reset to one.

Thanks,
Adrian