Printing Group Title

[ltidquist]

Hello:

I'm using CR9 with a SQL 2005 DB. My report is grouped in 7 sections for for different amounts of donations (up to $100, $101 - $500, and so on). It prints the person's name in that group if they meet the amount criteria and supresses it if it doesn't meet the appropriate criteria.

I need to be able to print the group name only once (ie 'Up to $100) but can't figure out how to do this.

Any suggestions?

Thanks in advance.

 

[lbass]

If you have a group on the amount range formula, then the group name WILL appear only once as long as you leave it in the group header. If you have it placed in the detail section you and format the field to "suppress if duplicated".

-LB

 

[ltidquist]

I must be doing something wrong. Here's the sections I've got:

GH - Product Code
GH - Amount
GH - Last_FirstName
GH - Up to $99
GH - $100 - $499
GH - $500 - $999
GH - $100 - $1499
GH - $1500 - $4999
GH - $5000 - $9999
GH - Over $10000

I have the name field placed in each of these groups. I have a suppress statement on each section where if the amount doesn't match the group it doesn't print. What do I need to do to get each group name to print only at the first instance?

I'm not printing anything in details or the GF's.

Thanks again.

 

[lbass]

You didn't show the number associated with the GH's. If you have more than one group, identify the group sections used above with the number as in GH1, GH2, etc. Also identify the field you grouped on in each case (not just the fields you are placing in the group sections).

-LB

 

[ltidquist]

Sorry about that...

GH1 - Product Code
GH2 - Amount
GH3 - Last_FirstName
GH4 - Up to $99
GH5 - $100 - $499
GH6 - $500 - $999
GH7 - $100 - $1499
GH8 - $1500 - $4999
GH9 - $5000 - $9999
GH10 - Over $10000

In GH4-10 I placed the Name field and then in the Section Expert under Suppress, I created a formula to determine if that group is the amount group to display for each person(Name).

Thanks.

 

[lbass]

What is the field you grouped on for group #2? Is this the donation amount? Could one person have more than one record, i.e., could they donate multipe times? For the ranges do you need a summary of those donations or does the database already total the donations per person? Please show a sample of how you would like the result to look.

-LB