BRuce,
I really appreciate your help, and don't want to take up too much of your time. I looked at your code, and I have never seen a report made like that, all the ones I have created had each field bound to the .datafield. I understand what you mean that I can't force a new page unless it is heirachical. I googled the SHAPE command, that was a new one too. But I am totally lost how your records get set on the report page. I have attached my report section, and if you are too busy I understand, I just need to understand how to link the data to the report. I really only need the report to page break on a field change, like Orders, in my case it is the Radius. Don't let all the wonky fields fool you, just the schema.
I didn't see anywhere on your report in the group header where it says to break, how does it know what field to break on??
THanks again. If this doesn't work, I will have to create the report in Excel, I guess.
Reply With Quote