Hi, We have some users that use an SSRS report and Output the results to Excel, then they open another Excel template, and copy and paste results from the SSRS Excel output into the new Excel Template…… ssis to named ranges / named cells in excel, then email to user as attachment wanted to do it via ssrs but I can't .Could u plz suugest is there any way that we can develop the template in SSRS.

Hi Kiranbabu, Since you don’t want to create template in Excel, you could also generate the template in the SSRS, Here’re steps for how to create your own templates: 1. Open or create a new project and create a new report. 2. Design the report to your specification, you can utilize report designer to place any objects (text boxes, tables, lines, etc) on the report that you want as a template. 3. Save the report and give the report a useful template-friendly name, anything that you can remember in the future. 4. Navigate to the folder where the .rdl file (that has just been saved) is stored. 5. Cut/Copy the file to the following : C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\ This is the default location of the templates folder. If you have installed Reporting Services on a different drive/directory, update these references to reflect the different Drive/Directory. Now, to access the report template from any project, go back to BIDS, right-click the ‘Reports’ folder (in the Solution Explorer) in your project and choose Add>New Item and you will see your new templates under the heading ‘Visual Studio installed Templates’. If you have any further question, please feel free to ask. Regards, Challen Fu