Print Page | Close Window

Using Command to Replace Current Data Source

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=4221
Printed Date: 28 Apr 2024 at 3:05am


Topic: Using Command to Replace Current Data Source
Posted By: weaverjs23
Subject: Using Command to Replace Current Data Source
Date Posted: 11 Sep 2008 at 5:05am

Can anyone help me?  I've created a Crystal report with several charts using tables from an Oracle Database.  Now I want to replace the database tables in the Database Expert with a SQL statement by adding a new Command.  The fields I used in the SQl statement are the same fields used in the report.

I tried to use the "Set Datasource Location" dialog box. 
I selected the table in the "Current Data Source" and then chose the "Add Command" option in the "Replace with:" window.  I hit the Update button and then pasted my SQL statement in the "Add Command To Report" dialog box.  However, after choosing "update", the SQL statement in the command line disapperas and the Database Table is still listed as the Current Data Source.

Is this a bug, or am I doing something wrong?  Cry


Print Page | Close Window