Non repeating headers

[cj247]

It seems so easy...

I have a list of theaters, each of these theaters is in a district ("downtown," "suburbs", "northeast," etc.). I want to export a list of these theaters and showtimes with the district header, but only if the header is necessary (I dont want the header to repeat).

i.e. this is right:

DOWNTOWN

theater 1 movies info etc.

theater 2 movies info etc.

theater 3 movies info etc.

SUBURBS

theater 1 movies info etc.

theater 2 movies info etc.

theater 3 movies info etc.

this is NOT:

DOWNTOWN

theater 1 movies info etc.

DOWNTOWN

theater 2 movies info etc.

DOWNTOWN

theater 3 movies info etc.

SUBURBS

theater 1 movies info etc.

SUBURBS

theater 2 movies info etc.

SUBURBS

theater 3 movies info etc.

I thought that maybe I could accomplish this by making a calc field that contains the previous record's "district" field. But I'm having no luck accomplishing this. Is there a way to access this info in a calc field?

Alternately, can anyone see a more elegant way to accomplish this?

Thanks so much for the help...

[Ender]

You can do this with sub-summary parts if you only need it for preview or print, like for a report.

[cj247]

I'll monkey around with them, but I need to export this data for printing, not actually print it. Is there a way to get this into an export?

[Ender]

cj247 said:

I need to export this data for printing, not actually print it.

Do you mean export as tab-separated text or print to PDF?

[cj247]

Export as tab separated text.

[Ender]

I think the closest you can get with a regular export is to choose Theater and Movie to Summarize by, in the Export dialog.

Another way would be to append field data to a global text field in a format that works, then copy or export that.