using:
Introduced with SQL Server 2005, SQL Native Client was designed to replace the aging Microsoft Data Access Components (MDAC). It allowed developers to access advanced features that older drivers could not support, such as: sql native client
If you encounter issues where SQL code runs in Management Studio but not in reports, contributors on Experts Exchange suggest checking the report's query designer for syntax visual glitches. Important Configuration and Support Tips using: Introduced with SQL Server 2005, SQL Native