* Custom queries

[Overloaded]

Have you ever used a function in a subtitle? I'm starting to conclude that it's not an option?

[tatewise]

Try spelling the function Individual and NOT Individuall (double ll should be single l)

Also, contrary to my earlier posting, PeterR is correct in suggesting the Row filters must be:

Code: Select all

=IsSameItem(FactOwner(,1,MALES_FIRST),Individual(['Person']))
=IsSameItem(FactOwner(,2,MALES_FIRST),Individual(['Person']))

Yes, I have used functions in both Title and Subtitle > Custom and they work fine.
But you cannot use Date codes such as %#x at the same time in the same field.
I am using FH Version 5.0.7

[Overloaded]

Sorry about the typo.

Now have this in the subtitle
=Individual(['Person'])

and the filters are unchanged:
Add if =FactOwner(%FACT%,1,MALES_FIRST) is ['Person']
Add if =FactOwner(%FACT%,2,MALES_FIRST) is ['Person']

which printed this in the report:
,1,MALES_FIRST

so, it appears to be attempting a function...

[tatewise]

Don't know how you are getting that effect. If I use those settings I get two prompts for Person.

Which FH Version are you running?

As has been said before, the Row filters must be:

Code: Select all

Add if =IsSameItem(FactOwner(,1,MALES_FIRST),Individual(['Person'])) is true.
Add if =IsSameItem(FactOwner(,2,MALES_FIRST),Individual(['Person'])) is true.

[PeterR]

The above is certainly working OK for me. The Expressions are pasted below so that you can copy and paste them into FH:

Code: Select all

=Individual(['Person'])
=TextIf(IsSameItem(FactOwner(,1,MALES_FIRST),Individual(['Person'])),'',FactOwner(,1,MALES_FIRST))
=IsSameItem(FactOwner(,1,MALES_FIRST),Individual(['Person']))
=IsSameItem(FactOwner(,2,MALES_FIRST),Individual(['Person']))

Edit: Even better column Expression:

Code: Select all

=TextIf(IsSameItem(FactOwner(,1,MALES_FIRST),Individual(['Person'])),FactOwner(,2,MALES_FIRST),FactOwner(,1,MALES_FIRST))

[Overloaded]

Hallelujah!  It works, including the column filter for different name[smile]

Details:
I was running 5.0.0, so I upgraded.  That made my existing filters produce two prompts, both searching the list of individuals.

Copying PeterR's code was non-trivial.  For whatever reason, I can cut-and-paste the expressions he gave into other fields in FH, but not into the fields for the expressions.  Also, if you don't first remove the existing parameter field on the row filter, it just won't accept the new filter

Thank you both

[PeterR]

Glad you've got the query to work properly at last.  For the Paste, were you trying to use Ctrl-V?  Had you tried the right-click context-menu Paste?