Catalogue Printintg

[Anuviel]

I was not able to find hot to do this so any pointers are appreciated.

I have about 800 records. Among the fields I have Item_Name, Picture and Cost.

I would like to make a catalog layout where the records would show up horizontally one next to each other rather then vertically.

I can get them to show like:

Item_Name, Cost

Picture

Item_Name, Cost

Picture

Item_Name, Cost

Picture

Basically a regular list layout.

I would like to show them as:

Picture Item_Name Picture Item_Name

Cost Cost

constrained to page width for printing purposes.

Thank you.,

[Vaughan]

Have you tired setting the print layout to multiple columns?

Other than that you'll need to make a cross-tab report. SOme assembly is required. Search Google and the Forums for details.

[Asda]

There is a way.

instead of using list view, set up a self join relationship between your images table.

see file attached.

Images.zip

[Vaughan]

Yeah, good idea to use multiple portals!

The OP is listed as using FMP 7, were the fancy portals introduced with that version or did they come later?

[Asda]

Sorry ! No idea about that , will need to reinstall 7 to check.Currently just have 8.5 installed and of course the trial of 9.00!!

[Anuviel]

Perfect., thank you so much - it works nicely.

[Anuviel]

Just made it, it works nice - I have noticed a drawback. It shows only the records that I made the portals for IE:

Portal row 1 - 3

Portal row 4 - 3

It does not show the rest. Do I need to make portals for all the records or just make them 1 - 500 501 - 500?

[Asda]

Yes, you will need to make as many portal rows as you need and as many portals as you need to cover all your records.See attached image files.

why do you ask ? Is there some problem in doing the above ?

[Asda]

After some thought, here's another solution without portals.However I do not know how it will work with large record sets.

Go to layout 3 and view in preview mode.

Images_2.zip

[comment]

I thought printing in columns was the first suggestion made.

For browsing, see:

http://fmforums.com/forum/showtopic.php?tid/1935/

http://fmforums.com/forum/showtopic.php?tid/184840/

[Asda]

thanks comment!!

These solutions are really great.

The original poster should have a wide choice now from the very simple to the complex. Which reminds me to search the forum first in future before delving into filemaker and reinventing the wheel.