Thanks for your replies....sorry for the lack of infomation..
David, please can you advise further how I can achieve one ms excel report and 15 tabs via SSRS output?
Only avaliable in 2008R2
The report project property Target Server Version must be set to SQL Server 2008 R2
Tablix and groups have a PageName property (for groups expand the group property)
PageName is used to name the worksheet
PageName can be an expression
Create a dataset
Add a tablix which uses that dataset
Add rows and columns to the tablix
Set the tablix pagename
Repeat for each new dataset/tablix you need
Note make sure you set PageBreak on subsequent tablix
Far away is close at hand in the images of elsewhere.