Steps to reproduce:
- Make a 2 databases with the same field names
- Make a report with one of them
- Add the other database in the report source data
Now you will see that the fields are all broken. Ideally instead of breaking, it should automatically join the field from the newly added database with the same field name. It’s the same name, its just requiring me to to remove and readd the same name. I understand its a different field under the hood, but it makes making and adjusting reports difficult.