FRAMEWORK MANAGER 8.1
REPORT STUDIO 8.1
I have an issue where records are being suppressed from a report studio report.
The report is referencing two joined tables.
Table 1 – Individual
Table 2 – Individual Primary Subject
Tables are joined on primary subject code.
Cardinality for the tables as follows:
- Each individual has zero or one individual primary subject (outer join) (0..1)
- Each individual primary subject has one or more individual
Running a report with just the individual_id and primary subject code from the individual table returns those individuals with ‘null’ subject codes, however when I include the description from the Individual Primary Subject table it suppresses those individuals with null subject codes from the report. I need those individuals with no primary subject codes to appear in the report.
The generated SQL from the report is creating an INNER JOIN, when I change this to a left join in SQL Studio I get the right results.
Can anyone suggest how to resolve this?
Appreciate any help.
Thanks
REPORT STUDIO 8.1
I have an issue where records are being suppressed from a report studio report.
The report is referencing two joined tables.
Table 1 – Individual
Table 2 – Individual Primary Subject
Tables are joined on primary subject code.
Cardinality for the tables as follows:
- Each individual has zero or one individual primary subject (outer join) (0..1)
- Each individual primary subject has one or more individual
Running a report with just the individual_id and primary subject code from the individual table returns those individuals with ‘null’ subject codes, however when I include the description from the Individual Primary Subject table it suppresses those individuals with null subject codes from the report. I need those individuals with no primary subject codes to appear in the report.
The generated SQL from the report is creating an INNER JOIN, when I change this to a left join in SQL Studio I get the right results.
Can anyone suggest how to resolve this?
Appreciate any help.
Thanks