Print Page | Close Window

Adding new "table" Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7022 Printed Date: 17 May 2024 at 6:56pm Topic: Adding new "table" Posted By: sbodell Subject: Adding new "table" Date Posted: 13 Jul 2009 at 12:48pm i'm using crystal XI against an oracle db using oracle ODBC drivers. i have a report that uses a linked view and table from the database.  i need to add a small "table/view" that is not currently present in the db to do a quick look up to get a code description. i have the sql code to select the table, now, can i somehow generate this "table/view" in crystal?  or do i have to add it to the db as a view? i have tried to Add Command which sort of works.  i have had a series of different errors: database vendor code: 942 database vendor code: 922 thanks sandy

Print Page | Close Window