Skip to Content
Former Member
Jun 16, 2016 at 01:09 PM

How to display results from 2 places if not found


HI I have a report for medical providers. They have an ID number, known as NPI. I have located a table that has this NPI # but for some it does not have. I have a sub report that goes and gets this number. I cannot update this table.

So for those not having, i made a hard coded formula for now.

How do I tell the sub report to only place the result if it finds one, otherwise let's use the hard coded value from the formula?

Or can I do this in the sub report ? How would you code the record select ?