Printing Portal Rows (All)

[Joseph31]

Hi everyone... Here is the situation...

I have 2 tables -- "Policies" & "Premiums"

On the "Policies" table there is a Portal that shows "Premiums" relating to that Policy only. Simple so far..

I wanted to make a report that would print some policy information and all of the lines of the "Premiums" portal...(Only the ones which relate to the file I am on).

Can some one show me how to do this or show me an example of a file that does this...

Thanks

Joseph

[LaRetta]

Hi Joseph,

I am not opposed to printing from portals. But it is much easier to print from your Premiums table.

LaRetta

[Joseph31]

ok..please tell me..I have tired that but all I get is one line when I need to see all of the portal lines...Also how can I make it so it only prints the related premiums to the policy I was on?

Help

Joseph

[RalphL]

Make a Columar/List report layout for your Premiums table. Put some info from the Policy table in either the header or a leading grand summary. Write a script that goes to the related records and shows the found set and then goes to the report layout and your report is all done.

[Joseph31]

I have tried omit and then show...That does not seem to work...

also omit muti and show muti...

is there another way?

Thank you

Joseph

[RalphL]

Use the go to related record script step. It has an option to show only related records.

[LaRetta]

With FM7, the process is very easy. You don't even need to establish a relationship back from your Premiums to your Policies to do it because in 7, relationships always go both ways.

You use Go To Related to isolate the Premiums pertaining to that Policy. Notice that you can place Policy fields from your Policy TO in the report as well. And you can even sort and categorize by your Policy.

I've attached a very simple file with the rough structure. I hope it helps you a bit.

LaRetta

Policies.zip

[Joseph31]

thank you for the attachment...

So it seems..I put this kind of thing on my main page (this is the page that shows the portal of Premiums)...I will give it a try.. so see if it works for me..

I will let you know...

Joseph

[Joseph31]

It worked great...you did it for me thank you... I hope I can return the favor for you one day....

Thank you

Joseph

[Michael Myett]

Assuming you are trying to get a found set of only your related records.

Use the goto related records script step with the show only related records box ticked.