Class

You need to move the date up into the join clause

select a.description,sum(b.qty),sum(b.qty)*a.price as total,date
from item a
inner join sales b on a.code=b.icode and b.date between a.datefrom...

Code

Does the XML file contain any content? Should be entries in the XML tag <RegisteredServers:RegisteredServers>, if not then you are going to have to re-create them from scratch and make...

Yes you will need to create the format file to detail what format to import.  The link I mentioned gives examples of when to use a format file, and there...

Assuming your not giving the users access to the URL bar, like an iFrame, I would go with accessing the reporting manager URL instead as that doesn't show the banner...

You may be able to get away with the XML file, just done a quick compare against my regsrvr and xml and they look identical.

Make a copy of...