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

John

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

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

and print it instead of the portal.

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:

Pkey

pplID

ptID

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

To keep it simple, define another calculation in the ArtworkPeople table =

Case ( ptID = 2 ; pplID )

then use this in the List() function instead of ArtworkPeople::pplID.

That's the stuff!!! Boom!

Thanks for all the help!

John

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?

signed

very frustrated John

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.)

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,

Lyle

Not as such, but perhaps you could use a repeating calculation field instead - if you can live with the number of columns being fixed in advance.

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 ) ] )

@comment

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

@LaRetta

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

How about this way?

HorizontalR.zip

@comment

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!

Lyle

And here is a mod that lets you "edit" the calculated repeating fields; by using a global behind the repeats. Unfinished but demonstrates the technique.

HorizontalR_Edit.fp7.zip

Could be much simpler with Boolean fields only:

HorizontalR+Toggle.zip

I would agree that Comment's Example is much simpler, but Bruce's technique can be used for another

db project .

-i