Showing Exception entries

rbuser

Hi,

I have a structure Employee --> Training as a one-to-many scenario. I want
to printout all employes only where there is NO training entries for that
employee. How can I achieve this creating the data definition, or if this
is not possible, from within the report?

Regards

Alex

nicocizik

Hi Alex,

The easiest way to do this would be to process this data prior to running
the report in SQL, however if you need to do this while the report is
running, you can use the AutoSearch feature of ReportBuilder to either
change the underlying SQL code or parameters. See the AutoSearch demos
located in the \RBuilder\Demos\5. AutoSearch\... directory.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

This is left outter join in SQL syntax.... (the same as query that shows
customers who has placed no orders) ...
;-)


Table1 Table2
Column11 Column12 Column21 Column22
aaa bbb ggg hhh
ccc ccc xxx zzz
xxx yyy
hhh zzz SELECT * FROM Table1 LEFT OUTER JOIN Table2
ON Table1.Column11=Table2.Column22 yields the table:Column11 Column12
Column21 Column22
aaa bbb null null
ccc ccc null null
xxx yyy null null
hhh zzz ggg hhhso in your case:
select e.*
from employees e left outer join training t on (e.emp_id=t.emp_id)
where (t.emp_id is null)