Report detail

[Former Member]

How can I populate the detail section of a report with a borrowers name that is in either table one or table two?

[former_member292966 · Accepted solution]

Hi,

You have to create a formula that will print the name based on your condition. For example:

If {table1.YourName} = '' Then 
    {table2.YourName} 
Else {table1.YourName};

This example checks to see if YourName in Table1 is empty or not. If it's empty then it will grab YourName from Table2 otherwise it will use Table1.

Obviously your condition and table structure will be different but you should be able to build upon this.

Good luck,

Brian