I am in CR8 with MSSQL 2000
I have a report that looks essentially like this:
Group 1 Header(grouped on ObjNumber) = Topic Text
Group 2 Header(grouped on ClassType) = Goal:ObjNumber, Text
Details = Objective:ObjNumber, Text
When it is displaying real data it looks like this:
Agriscience Biotechnology
Goal 1: Jason will demonstrate math skills
Objective 1.1: Jason will perform basic computations.
Objective 1.2: Jason will recognize units of measurement.
Agriscience Biotechnology
Goal 2: Jason will demonstrate knowlegde of the metric system.
Objective 2.1: Jason will convert units.
Objective 2.2: Jason will use the metric system.
The problem is that I don't want to display the topic a second time if there is more than one goal per topic.
I tried to 'Suppress if duplicated' but this doesn't work because I am grouping on ObjNumber. ANy ideas???
I have a report that looks essentially like this:
Group 1 Header(grouped on ObjNumber) = Topic Text
Group 2 Header(grouped on ClassType) = Goal:ObjNumber, Text
Details = Objective:ObjNumber, Text
When it is displaying real data it looks like this:
Agriscience Biotechnology
Goal 1: Jason will demonstrate math skills
Objective 1.1: Jason will perform basic computations.
Objective 1.2: Jason will recognize units of measurement.
Agriscience Biotechnology
Goal 2: Jason will demonstrate knowlegde of the metric system.
Objective 2.1: Jason will convert units.
Objective 2.2: Jason will use the metric system.
The problem is that I don't want to display the topic a second time if there is more than one goal per topic.
I tried to 'Suppress if duplicated' but this doesn't work because I am grouping on ObjNumber. ANy ideas???