My company is converting over to crystal reports 2008 from crystal reports XI. The problem we are having is that some of the tables used have a owner which crystal prefixes the owner name before the table name in the SQL query, for example instead of just customer it is CO1.customer.customerID. The issue with this is that the owner of the table is determined at runtime and not design time. The way we dealt with it in crystal reports XI was to get the SQL query string and modify it with the correct owner. But as you all know we can no longer get the SQL query string in 2008. I would like to know if there is a way to access the owner of a table and modify it in .Net?


Edited by mortizar - 07 Aug 2009 at 6:42am