We need to schedule an SSRS 2008 report to run every night at midnight, then have it converted to Excel and emailed to 4 predefined users.DB Architect

Should be able to do all of that in the basic subscription setup You can choose the schedule you want the subscription to run on, the output format (excel) and where to put the report (email in your case rather than saved as a file) In report manager, click on the report to see its properties, go to the subscription tab and work your way down - it should be pretty straightforwardRgds Geoff

ThanksDB Architect

Hi Ben Aminnia, Thank you for posting this thread. I done all the things in subscription section. actually i given the name subscription name,location to save the excel sheet i.e., (Render format) then credentials and scheduling time. But i could not get the proper output. Actually what i have done,Below the things pls understand <select id="ui_dropdownDeliveryProvider" class="msrs-dropdowns" name="ui_dropdownDeliveryProvider"> <option value="__NO_VALUE__">Choose a method of delivery</option> <option selected="selected" value="Report Server FileShare">Report Server File Share</option></select> Delivered by: A delivery method must be selected. Owner: SOURCECODE1\IUSR_SOURCECODE File Name: <input id="FileNameID" style="font-family: Verdana, Sans-Serif; font-size: x-small;" name="FileNameID" size="60" type="text" value="First" /> The file name is not allowed to be empty. The file name is not valid. Avoid using special characters such as /\?*:<>|+,[]"& in the file name. <input id="FileExtnID" checked="checked" name="FileExtnID" type="checkbox" value="on" />Add a file extension when the file is created Path: <input id="PathID" style="font-family: Verdana, Sans-Serif; font-size: x-small;" name="PathID" size="60" type="text" value="\\192.168.2.228\GO3Reports" /> The path is not valid. The path must conform to Uniform Naming Convention (UNC) format. The path is not valid. The path must conform to Uniform Naming Convention (UNC) format. Render Format: <select id="RenderFormatID" name="RenderFormatID"> <option value="XML">XML file with report data</option> <option value="CSV">CSV (comma delimited)</option> <option value="IMAGE">TIFF file</option> <option value="PDF">Acrobat (PDF) file</option> <option value="HTML4.0">Web page for IE 5.0 or later (.htm)</option> <option value="HTML3.2">Web page for most web browsers (.htm)</option> <option value="MHTML">Web archive</option> <option selected="selected" value="EXCEL">Excel</option></select> Credentials used to access the file share: User Name: <input id="UserNameID" style="font-family: Verdana, Sans-Serif; font-size: x-small;" name="UserNameID" size="30" type="text" value="sa" /> The user name is not allowed to be empty. Password: <input id="PassWordID" style="font-family: Verdana, Sans-Serif; font-size: x-small;" name="PassWordID" size="30" type="password" /> The password is not allowed to be empty. <input id="ShadowPassWordID" name="ShadowPassWordID" type="hidden" /><input id="ShadowPassWordChangedID" name="ShadowPassWordChangedID" type="hidden" value="false" /> Please reenter Password Overwrite options: <input id="WriteModeID_0" name="WriteModeID" type="radio" value="Overwrite" /><label for="WriteModeID_0">Overwrite an existing file with a newer version</label> <input id="WriteModeID_1" checked="checked" name="WriteModeID" type="radio" value="None" /><label for="WriteModeID_1">Do not overwrite the file if a previous version exists</label> <input id="WriteModeID_2" name="WriteModeID" type="radio" value="AutoIncrement" /><label for="WriteModeID_2">Increment file names as newer versions are added</label> Subscription Processing Options Specify options for subscription processing. Run the subscription: <input id="ui_rdoOnSchedule" checked="checked" name="NotifyGroup" type="radio" value="ui_rdoOnSchedule" /><label for="ui_rdoOnSchedule">When the scheduled report run is complete.</label> <input id="ui_btn_SpecifyScheduleSubscriptionProp" class="msrs-button" name="ui_btn_SpecifyScheduleSubscriptionProp" type="submit" value="Select Schedule" /> At 3:26 PM every Wed of every week, starting 8/3/2011 <input id="ui_rdoOnSharedSchedule" disabled="disabled" name="NotifyGroup" type="radio" value="ui_rdoOnSharedSchedule" /><label for="ui_rdoOnSharedSchedule">On a shared schedule:</label> <select id="ui_ddSharedScheduleDropDown" class="msrs-dropdowns" disabled="disabled" name="ui_ddSharedScheduleDropDown"> <option selected="selected" value="NoSharedSchedules">Select a shared schedule</option></select> i set particular time after that it should be export my report as excel to that folder in the path.but it could not be export the file kindly help me. Sivanathan.V