Right out join for .xls file
I have a report, which has a "command" dataset, linked to 2 other tables, which works fine, and then i just export
the file to an .xls file. The .xls file contains a list of "hosts" that match the command dataset and a selection criteria
I want to insert a subreport, which does exactly the same query, AND uses the exported .xls from the previous day, as i want to report exceptions, i.e Hosts on the .xls file yesterday, that are not found today.
I did try all combinations of link, but for the .xls links, i only see "inner" and "left outer join" .
Right outer join and Full outer join are not available.
I am just trying to produce an exception list in the subreport.
Any suggestions or comments welcomed. Thanks