report problem

[Aussie John]

I've two tables related by a room number. one called "room" and the other "equipment in room".

I want a report to list all the rooms with all equipment listed under a "room number" sub-summary. Not all rooms have equipment.

If I make the layout show records from "room layout" I only get one piece of equipment listed and if I make the layout "equipment" I dont see the rooms with no equipment.

Any thoughts? thanks

[Vaughan]

This is an issue that comes up often with related databases. There is no real way around it other than to create empty records (which I don't particularly like doing).

You could put a portal on the room layout to display the equipment.This is excellent for viewing but portals are sub-optimal for printing.

Alternatively in the Rooms table create a calculate field that uses the List() function to aggregate all related equipment records together in a paragraph delimited list. Then display this calculated field on the report.

This too has its limitations but it's useful.

[Aussie John]

Thanks Vaughan - I have concatenated a series of fields to make the list function.

Do you know if you can put Tabs in a calculation like you can paragraphs?

[Vaughan]

It may be possible but it would have to be done in a calculated field on the equipment side.

[Aussie John]

Yes you can add tabs into a calculation but doesnt seem to be able to set a position (which is needed in this instance).

Wonder if any one is able to offer a way?

[comment]

The position of tabs is set in Layout mode: select the field (i.e. the final field that displays the result) and choose Format > Text… > Paragraph… > Tabs…

[Aussie John]

That worked!!! (although was in format> Line spacing>other…> (tab button) thanks guys