Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Not what you were looking for? View more on this topic or Ask a question