I am using Crystal Reports 9.  My plan is to upgrade to 11 soon.  My question is as follows:

 

I need to create and drop two temporary tables using Crystal Reports.  Does CR offer this type of functionality or should I perform this task on the database end and then use CR on the resulting tables?

 

Thanks,

Reggie

 

However, you can create Command objects which are essentially SQL statements. I think of them as views rather tables.  However, it does allow you to set relational links between the command objects. I find this extremely useful. You will find this functionality under the Database Expert.

 

The second part of your question is that you should be able to create an actual temporary table on the database server that runs against SQL. 

 

Depending on what you need to do with the table will give the you the answer to the question. If you need to deal with cursors and control methods, then SQL temporary tables are probably the answer. If you just need to pull two sets of data and then relate them to each other give the CR command objects a look.

 

Hope this is of help.

 

Regards,

 

John W.

http://www.CustomReportWriters.net - www.CustomReportWriters.net

I would like to create two temporary tables and extract data from these with crystal reports.  It would help if I can create these two tables using Crystal Reports....this way I do not have to run scripts via the Oracle interface first, and then you CR on the resulting table.  Here is a high level example of what I need to do:

 

Step 1

Create Temporary Table 1

Update (remove NULLS etc) fields in Temp Table1

Join Parent Table 1 and Parent Table 2 (to create Table 1)

 

Step 2

Create Temporary Table 2

Update fields in Temp Table 2

 

Reggie