SSRS and asp.net

Ok I have 26 reports to create, the end result would look something like this

Description, Period1, Period2, Period3

---

Average Sales, 25, 45, 67

Totals Team 1, 53, 74, 27

Totals Team 2, 36,49,...

sure here's the link, I dont use the whole thing I just found the use of the Coalesce statement interesting as i normally use where (columnName is null) or (...

Try this which I got from code project, its a great way to do a query from a form with multiple parameters

Create Procedure sp_EmployeeSelect_Coalesce

@EmployeeName NVarchar(100),

...

try using an open query

SELECT [Col1], [Col2], [Col3] INTO DestinationTable FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\YourFolderLocation\yourFileName.xls;Extended Properties=Excel 8.0')...[WorkSheetName$]

SELECT [Col1], [Col2], [Col3] INTO DestinationTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\YourFolderLocation\yourFileName.xls', [WorkSheetName$])

SELECT [Col1], [Col2], [Col3] INTO...