Jump to content

Getting to print the portal along the horizontal


This topic is 4041 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello to all

I have a report that has a portal in it. In the portal are names of people.

When I print the report the names come out in the usual manner. EXAMPLE:

John Apple

Joe Banana

Jerry Carrot

Is there a way to get the content of my portal to print thusly:

John Apple, Joe Banana, Jerry Carrot

Please advise.

Thank you


Link to comment
Share on other sites

Oh wow!

Thank you Comment. That did it.

But now I realize I need to somehow add an extra "layer" of criteria.

This is what I have (and it works):

Substitute ( List ( ArtworkPeople::pplID) ; ¶ ; ", " )

The portal for my table has the following fields:




But now I realize that I don't want all of the pplID listed. I just want the pplIDs where ptID = 2.

How do I edit the calculation above so it only ArtworkPeople::pplID where ptID = 2?

Please advise

Link to comment
Share on other sites

  • 1 month later...

I'm re-visiting this issue.

It works perfect in my first use of it.

I'm trying to use it again in another section of my DB but it won't work.

I'm trying to diagnose what the difference might be but I can't see it.

I don't have much to offer in terms of description: Can anyone suggest ways that I can diagnose this problem?


very frustrated John

Link to comment
Share on other sites

One cheese sandwich later and my thinking is much clearer.

I've diagnosed the problem.

Turns out I only thought I was implementing the code in precisely the same way in precisely the same type of table relationship.

I'll take this as a lesson in never posting on an empty stomach.

Thank you to all for your interest.

John (post sandwich and cookie.)

Link to comment
Share on other sites

  • 8 months later...

Yes - if you define a calculation field in the parent table =

Substitute ( List ( Child::Name ) ; ¶ ; ", " )

and print it instead of the portal.

Exactly what I was looking for! Thank you!

However, is it possible to apply conditional formatting to the individual values? EXAMPLE:

My "horizontal portal" contains only "Yes" and "No" text:

Yes Yes No Yes No

I would like to apply conditional formatting so that the background of the "No"s is different. Is this possible?

Thanks in advance,


Link to comment
Share on other sites

But you can handle within the same calculation if you can go with colored or bold text instead, by wrapping it with:

Substitute ( List ( Child::text ) ; [ ¶ ; ", " ] ; [ "No" ; TextStyleAdd ( "No" ; Bold ) ] )

Link to comment
Share on other sites


I tried this but I am not able to get it do display the discrete elements of the repeating field. The Help files mentions that Calc fields display the entire contents, so I am obviously missing something :)


Thanks! That worked and I will be able to use this method in another layout :)

Link to comment
Share on other sites


WOW!!! That is EXACTLY what I needed! :) Thank you ever so much!

It took me a while to figure out where you were getting the "Yes" and "No" values from, as well as the border between the values. Two pots of Tim Horton's coffee later, I found the answers in the Inspector; I had no idea you could do that :)

Also invaluable was the construction of the calcs for the 2 fields that made it happen; I sort of "get it" now how LET and CASE work :)

Wish I had more time to study and experiment, but it's difficult to do so when "they" are breathing down your neck for "visual progress" :)

Thanks again!


Link to comment
Share on other sites

This topic is 4041 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.