A report to show more than one portal record

[JohnOMalley]

I deployed a small database yesterday. A purpose of this db is to record notes of a phone calls made by select clients. These notes are kept in a text field in a portal record.

In its first test a user entered two records in portal record. This was fine until the report was processed at the end of the day. The report, which is run by a script that looks at the system

date, generated a report that only showed the first recorded note, but not the second.

Why did this happen? I can not seem to figure it out.

John

[mr_vodka]

Can you provide a little more information?

What is your script doing? What table ot layout are you generating the report from?

[JohnOMalley]

<"Can you provide a little more information? What is your script

Script;

Enter Browse Mode, Show all records, Go to layout - Report, Perform find[restore] specify field - datecalled //,Enter preview mode, Print restore, Enter Browse mode, Go to layout Main Form

The layout is just a screen print out. The information comes from two tables.

[mr_vodka]

Am I correct to assume that you have set up a clients table related to the notes/phonecall table related by clientID? If this is true and the Date field (Notes table) is entered via the portal, your find script should work when finding in the notes table for the specific Date.

[JohnOMalley]

yes, I have a client ID related to the notes table. The date is automatically entered when record is updated.

I agree that it shold work, but it did not. I am perplexed. Would it help you to see it?

[mr_vodka]

sure. upload the file.

[JohnOMalley]

see below

Edited September 27, 2005 by Guest

[JohnOMalley]

here it is

Sample.fp7.zip

Edited September 27, 2005 by Guest
forgot the file

[JohnOMalley]

Instructions: click phone log - top right side.

then see the two records click email phone log to create a pdf

[mr_vodka]

Your reports layout is from Missions2 not the Phone Log table. Since you are printing records from the phonelog Table, change the layout accordingly.

This can be be chagned from in Layout mode

Go to layouts menu --> Layout Setup -->

show records from...

[JohnOMalley]

Man, thanks so much! I appreciate it!!!