>>>>What is your SQL Server version? If it's Enterprise version, you can set up data driven subscriptions.
>>>
>>>Its 2005. How would I tell if they have enterprise version or not ?
>>

>>SELECT 
>>	SERVERPROPERTY('Edition') AS Edition,
>>	SERVERPROPERTY('ProductVersion') AS ProductVersion,
>>	SERVERPROPERTY('ProductLevel') AS ProductLevel
>>

>>from
>>http://berezniker.com/content/pages/sql/microsoft-sql-server/retrieving-sql-server-edition-version-and-service-pack-info
>
>Standard edition
>
>Version 9.00.4053.00
>
>Product Level SP3

Please take a look at the link from my answer on this quiz http://beyondrelational.com/quiz/sqlserver/general/2010/questions/sqlserver-quiz-general-2010-jessica-moss-ssrs-data-driven-subscriptions-with-standard-edition.aspx

It shows how to set it up in Standard Edition.