I am using subscription to render my reports. My question can send reports to prefered users via email in a pdf or excel formats? Can someone point me in the right direction? Thank youFM

You could try using a data driven subcription check link for details http://msdn.microsoft.com/en-us/library/ms159150.aspx and this for step by step http://technet.microsoft.com/en-us/library/aa237461%28SQL.80%29.aspx

Hi Bidev, Thank you for all the reports i have created the Datasrouce is from a Oracle database.... How will this efect my DDS? Thank youFM

if you connect to the db through the data source and use the sql command that is validated it should still work