Printing a report

[edmonton]

Hi

I have a form that has a portal in it. When I try to print a record, IF the portal is empty, then it prints the last record that had a portal record in it.

In FMP 5, it would print a blank record but not the previous record. Any suggetions...

PS-I do go to the portal layout to print the records.

Thanx

[LiveOak]

The major suggestion is not to use portals on a report, but do the printing with summary/subsummary parts from the related file. I think you'll find this works well and eliminates a host of problems.

-bd

[edmonton]

Sorry for the confusion, but I am printing the report from the related file.

Since the file in FMP7 is the same and only the two tables are different, I am switching the layout so that the report gets the data from the related file and not the parent file.

My assumption is that since there are no records in a related table for the parent record, then when a record is printed, it should be printed blank in the related file...

Layout with parent table is used for data entry. When I create an entry in Parent table, and try to print that record that I just created, it goes to the related table layout and prints from there.

I hope this is less confusing....

[-Queue-]

My assumption is that since there are no records in a related table for the parent record, then when a record is printed, it should be printed blank in the related file...

Actually, if there are no related child records, nothing should print. First test for related records, If [not IsEmpty(relationship::id)], then Go to Related Records [show only related; relationship] if it's true. If it isn't true, you don't want to go to the related file since there are no related records. If you want to print the parent record in such cases and don't want a portal with a blank row to be displayed, duplicate the layout and change the portal to use a relationship that doesn't have 'Allow creation of related records' selected.