Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Using Command to Replace Current Data Source Post Reply Post New Topic
Author Message
weaverjs23
Newbie
Newbie


Joined: 09 Sep 2008
Location: United States
Online Status: Offline
Posts: 1
Quote weaverjs23 Replybullet Topic: Using Command to Replace Current Data Source
    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

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.