report designer page breaking

[DebbieInFlorida]

I have a very simple report to create that I want to page break on 1 field. I know that there is Data shaping and Heirarchical reports, but this is only 1 table, and I that stuff is soooo confusing.. This is my query..

"SELECT Project_Name, Full_Street_Name,Status, Base_Name FROM Street_Name order by project_name, status, base_name"

I just want the page to break on Project Names and status. I tried setting pagebreak in the group section,(where I display Project_name, status and Base_Names in Bound textboxes) but I get error - "report sections don't match data source". I don't see why it cares if I am not using data shaping.
Any ideas??
thanks

[brucevde]

Unfortunately that is the only way! You must bind the Data Report to a hierarchical recordset (data shaping) in order to use Group Sections.

Try this query

rs.Open "SHAPE {Select * From Street_Name} AS cmdProjects Compute cmdProjects BY 'Project_Name','Status'", db, adOpenStatic, adLockReadOnly

[DebbieInFlorida]

Hi again Bruce,
You helped me last year and I hate to bother you again. I have trouble with the relationship of these shape groupings and I don't do them very often. I got the Datashape connection working and created a query, but it is not doing what I want(which is a really simple, simple report). This is only 1 table!
I basically want a new page for each Project and Status within Project, then for these breaks, show all the streets. Therefore a new page for Project AA with status 'Active', then new page for AA with status 'Temporary'....

I attached a picture of the report, this is the query I am using..

sQuery = "SHAPE {SELECT Project_Name, Full_Street_Name,Status, Base_Name FROM Street_Name where Base_Name Like 'B%'}" & _
" APPEND ({SELECT Project_Name, Full_Street_Name,Status, Base_Name FROM Street_Name where Base_Name like 'B%'}" & _
" Relate Project_Name to Project_Name) as PageBreak"

Thanks again for any help.

[Hack]

Moved to reporting