Unless you need to do additional processing on the data before sending it Crystal Reports, you'd be better off having Crystal Reports pull the data.
>Hi Craig,
>
> I want to expand on this. We have crystal and will be converting to sql server with remote views. I have downloaded you article but have not read it yet and you may cover this but I want to be sure. Can I connect using ODBC with my views or does it have to be tables?
>
>Thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer