Combined Analysis- Union
1st one has Service Request & Custom Object 7 fields
2nd has Service Request & Contact fields.
For both of the reports, I have a field with no Table Heading & a Column Heading of '' this way where the 2nd report has a Contact field, I have a '' field as a place holder in the 1st report. I did the same thing in the 2nd report for where report 1 has a Custom Object 7 ID field.
Everything works great except for where there are '' fields in the 1st report. I want the final (result) columns to display the Contact field information, but instead it pulls blank information as if it only recognizes the '' report 1 fields.