unlucky newbie 1

[bitsmith2k]

hello folks.. dew to downsizing, i have to now deal with some crystal reporting.
i have a question that will help me out considerably..
just thought i'd post here before i go and buy a book...

i have this structure:
tblMain_TransTickets
====================
NumOfPeople : Number
Category : String
Subcategory : String
Price : Money

some sample info might look like this:
2 Broker Adult 4.80
1 Regular Child 2.50
1 Broker Adult 4.80

i want the report to look like this:
3 Broker Adult 4.80
1 Regular Child 2.50

in the past i've only ever used vb for reporting, and
can do what i need with it and sql.

not looking to be spoonfed here, just looking for a push in the right direction..

thanks in advance for the help..

mike

 

[chelseatech]

Group your data by Category and SubCategory, and Sum NumberofPeople and Price.

Supress the details and place Category and SubCategory, and the Sums in Group Footer 2.
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[bitsmith2k]

much appreciated chelseatech,

that worked the way i wanted it to...

i'm sure i'll be posting here again in the future.

thanks again

 

[Madawc]

I learned on PC-based teaching software, which takes you through examples and then quizes you. I can't give you the name, I didn't install it and have no idea what it costs, but I'd say it was a better line to follow. Madawc Williams
East Anglia
Great Britain

 

[Madawc]

PS. Actually it was edCenter Madawc Williams
East Anglia
Great Britain