Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Report


surlyb

This topic is 8199 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I work for a small, regional real estate paper as the webmaster. I have a database (FileMaker Pro 4, but I have just purchased FielMaker Pro 5.5) set up with the following fields, date in, realtor, company, realtor name first, realtor name last, realtor email, realtor URL, realtor phone1, realtor phone2, comp (a shortened name for the company), company street address, company city/sate/zip, property address, tag line, area (N, S, E W), price, property URL, Status (active/inactive/pending) and notes. Each property has it

Link to comment
Share on other sites

Create a columnar list layout with a (leading) sub-summary part when sorted by realtor. Put the realtor's name field in the sub-summary part, and whatever fields you need to see on the report in the body part below it.

Now, after the find, do a sort by realtor name (yeah, I know, there's only one, but you gotta do it anyway), and you can print the report.

Even better -- you can print reports for as many realtors as you want at the same time. Just have the sub-summary part "Page break before each occurrence," and each realtor's list will start on a new page.

Link to comment
Share on other sites

Ok.

If you create a columnar list report, and place the realtor, property details and the email in the report and then categorize by realtor , at the end when it asks if you want to make a script say YES.

This is so it remembers to sort by realtor.

once you have finished, you will see a subsummary part with the realtor name in. in the body will be the property details.

When you preview this report and it is sorted by realtor all their properties are listed. Then it goes on to the next realtor.

As for emailing this, that is a bit more tricky as the report only looks like this when sorted.

It would have been better to have a realtor database and a property database. Then you could have just shown the related records and created a script to concatenate the properties into the body of the email.

HTH

Link to comment
Share on other sites

This topic is 8199 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.