Sorry, but I have another problem with my shaping command. I have molded this report for weeks and still cannot get the correct output. I have only 1 table, so maybe I am over querying. I think the issue is breaking on 2 fields.

my data...
PROJECT_NAME STATUS STREET_NAME
A Active Honky TOnk
A Reserved Hooey
A Active Smith
B Active TUrner
B Reserved Hooch

The report should show Street_Names and break on Project_Name and Status.
therefore I would have
4 pages from above. A with Active, A with Reserved, B with Active, B with Reserved.

----- Attempt # 1 -----

SHAPE {SELECT Distinct Project_Name FROM Table group by Project_Name}
APPEND((SHAPE{SELECT Distinct Project_Name , Status FROM Table Group By Project_Name, Status}
APPEND({SELECT DIstinct Status, Street_Name FROMTable} as Details
RELATE Status to Status)) as PageBreak
RELATE Project_Name to Project_Name)

------- Attempt # 2 -------

SHAPE {SELECT Distinct Project_Name, Status FROM Table Group By Project_Name, Status}
APPEND({SELECT Project_name, Status, Street_Name From Table} as Details
RELATE Project_Name to Project_Name)


I have set the report Group 1 pagebreak to 1(after page break) with the Project_Name value, NO Datamember. Group 2 has no pagebreak, but has the Status with Datamember for PageBreak. Then I have Details using Datamember for Details.

It looks like it should work, but I get either repeated records, or wrong number of pages. I also never get the Reserved data, but I get a page break for it... Sorry to ask about this topic again, I really put a lot of effort to try this myself.