programming code in Crystal Reports

[jmstroup]

I am using Crystal Reports 8.5 and Oracle 8i.

I want to create temporary tables and then manipulate the data from those tables and insert into another table. That last table will be used as the data for the report in Crystal.

Can I do this within crystal reports? I see that they have "Crystal syntax" and "Basic syntax" for formulas, but can I run queries to insert data into temp tables, manipulate that data into a final temp table and take those results into the report? Do I need to use a stored procedure within Oracle instead?

Thank you,
Marie

 

[Reebo99]

I'm using the exacy same versions as you and my understanding is that Crystal cannot create data to report on.
As you've stated, you can call stored procedures, but I've never tried this.
I have used Crystal SQL Designer to manipulate data into tables and this seems to work. If anyone else out there knows of any other ways, I'd appreciate knowing as well.
Sorry I can't be more helpful. Reebo
Scotland (snowed in)

 

[jmstroup]

Hi Reebo,

When you say that you used Crystal SQL Designer, were you able to use a query to put data into a table. Then manipulate data in that table, and then produce the final select query for the report? Or did you do a complex single query that was able to manipulate data directly in the select statement?

Thanks,
Marie

 

[Reebo99]

Marie,

Do you mean you have table1, table2, and table3 already setup in Oracle. You want to populate table3 with data currently held within table1 and table2.

The report will be setup pointing to table3, so any data population would need to take place before Crystal reports on the contents of table3.

Is this correct? Reebo
Scotland (snowed in)

 

[Naith]

Marie,

Neither Crystal Reports nor Crystal SQL Designer manipulate data. If you want to perform updates and inserts or other data modifications, then you do this in Oracle prior to letting Crystal loose on your data.

As you guys have correctly touched upon, you can use stored procedures, views, or temporary tables to achieve this - but the idea is that you handle all of the data preparations outside of Crystal.

Naith

 

[jmstroup]

That's exactly it, Reebo.
I guess you guys have answered my question. I'll go with Stored Procedures.
Thank you both for helping me on this!
Marie