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

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