My report summarizes test events for a simulation. It works great if no event category is repeated during the test but fails to report the 2nd occurrance of any event cat (think of category as sub-test within one over-arching main test). The SQL Query Analyzer shows the 2nd one but the report fails to do so. My top group is event category and my next group is event name within the category. The two events have the same category and name but different start times.

How do I get CR to report on the 2nd occurrance of the same event category?

Edited by bryanlw123 - 12 Apr 2011 at 9:04am

The data on the details section contains all instances of the expected Instructor Event Marks (comment strings)

My SQL query does not have select distinct records in it because I want to report on all activations of a checklist (TreeLocation\Checklist Name and the many sub-events within it).

Group Header #1 and #2 are not repeating for the TreeLocation/Event Name pairs that have later start times
but same names

Design:

Group Header #1 - TreeLocation - s (category)
       Group sort in specified order (checklist 1 to
       checklist 22 and then Instructor Event mark)
Group Header #2 - EventName
Group Header #3 - TreeLocation - a
Details - Strings containing Event marks
GF #2 and #3 nothing, GF #1 "-------------"
Report Footer - SubReport
Page Footer -- print date and page N of M

It looks like I need to rebuild this report with

GH#1 - TreeLocation
GH#2 - StartTime
Details - EventName

new subreport for Instructor Event marks plus
old report

Thanks for your help!! I am able to display the StartTime of the repeated checklist when I delete GH#3 and insert Command.StartTime in the details section. At this point all of the formatting went to heck. I'm going to give a break for awhile and work on something else.