Create a Report of the Content in the Cemetery Section

[rominejc]

I'm just beginning to create new reports.  Is there a way to create a report that provides the information stored in the Cemetery list.  I would like the report to provide all the information in each cemetery entry including the notes section.

Any help is appreciated.

Jim

[GOGGS]

Just checking - are you looking for the Cemetery info AND all the people buried there? I don't use the Cemeteries function, but instead list it as a Place that is automatically added (if new) when the burial place is added or modified for a person. That "place" doesn't have details about the actual cemetery though...

You could create a straight SQL report in the report builder with

SELECT * FROM tng_cemeteries

and then remove any columns with a more detailed statement if necessary.

[rominejc]

Thank you,

I got what I needed by creating the following report:

SELECT cemeteryID, cemname, city, county, Latitude, Longitude, Notes FROM tng_cemeteries