• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Multiple Fields for One Parameter

I have three fields coming from the database.

1. Secondary Solicitor
2. Primary Solicitor
3. Volunteer Solicitor

I created one parameter and the user will choose either one in the drop down.

How can I combine all three fields in the select expert?


0
maximus44
Asked:
maximus44
  • 2
1 Solution
 
peter57rCommented:
I don't really understand the Q.

What are entering in the parameter? a field name? a solicitor name?

Are you trying to enter one solicitor name and select records where that name is in any of the 3 fields?
0
 
maximus44Author Commented:
Sorry, I probaby didn't explain this properly.  See Attached Example
You-will-find-Solicitor-Type-in-.doc
0
 
peter57rCommented:
So that't a Yes to my Q:
"Are you trying to enter one solicitor name and select records where that name is in any of the 3 fields?"

In that case you set up a selection rule which is something like :

if {table.primarysolicitor} = {?Param}
or {table.secondarysolicitor} = {?Param}
or {table.volunteersolicitor} = {?Param} then
true
else
false

0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now