I need to create a comparison of sales report over 2 given date periods, for a range of products, I imagined I'd need to create 2 datasets, 1 for each start/end date period but then I need to combine the 2 datasets into 1 new dataset to be able to create the report. If anyone could shed some light on how to do this that would be great.

Here is a link to the SRS demo that shows how to complete this...
http://www.microsoft.com/sql/reporti...horingDemo.asp


--
Ben Sullins
Sql Developer - Our Vacation Store

thanks but that demo shows nothing that relates to my problem