Jump to content
  • 0

Ignoring Blank Values in a Details Report



I'm building a CRM for my agency. We sell multiple product types, each of which will have different relevant information.  For example, life products. Term Life will need a field for how long the term is for where as Final Expense there is no term length. 

What I'd like to do is have a table that stores ALL policy types. However, when looking at the details of a policy, I want to hide irrelevant fields (determined by whether or not the field is blank). I tried doing this using a rule, however when choosing the field to base the rule on, that field disappears as an option to perform an action on. When "Field A" is blank , Hide "Field A" is not an option.  This is important because I want to be able to display ALL policies per client, and given our product mix, that could be as many as 5. 

Is there a work around? Or am I going to have to create separate tables per policy type? If the latter, how would I combine the client table to the various policy tables in order to create a view that displays all policies per client?  From what I can tell, I can only pair two tables at a time.    

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...