Incidents report with Answers Summary
SummaryCreating a report joinning two tables with no common fields
I can´t find a way to add the title of an answer (answers.summary) into the incident's report because this two tables don't have any field that can be related to each other.
I've managed to get so far to alternate the data between incidents and answers. This is an example of what I've been trying, using the following tables:
- Transactions (set as root)
- INNER JOIN on Incidents AND Answers gives as a result "No elements to show on this view."
- EXTERNAL JOIN on Incidents and INNER JOIN on Answers = No info from the incidents fields but shows Answers.summary data.