Accessing Table owners
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7297
Printed Date: 24 Apr 2024 at 10:41pm
Topic: Accessing Table owners
Posted By: mortizar
Subject: Accessing Table owners
Date Posted: 07 Aug 2009 at 6:41am
file:///C:%5CUsers%5Cnick%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - 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?
|
|