creating CR using a temporary table...

[jeanette_db]

hi everyone...

i just wanna ask if you can create a report using CR8.5 if the source table is temporary?

if so, can anybody help me on how to do it?
i tried exploring though, but i failed...

i've learned that before creating textfields, one has to add a database... and had to choose the table to be used in the report... then... drag the fields to be used... what if i'm using a temporary table... how will i do this?

anybody help please...
help is greatly appreciated..
thanks in advance...

[jeanette_db]

im just sooo CLUELESS... help me with this please...

[si_the_geek]

I don't know if this is the "right" way to do it, but what I did was to use a "permanent temporary table".. basically a table with the right structure, but no data.

Rather than putting the data into a temp table, I would put it into this table (after running a Delete to ensure it was empty), then run the report, and then delete everything from the table.

[GaryMazzone]

I do something similar but also add a filed for user (the person generating the report) THe user field is madeup of the username and the date and time the report generation started. When the data is fully gathered I call the CR report and set the record selection criteria to the user name I generated for the report.

[Besoup]

I use a permanant table and just run a truncate sql statement on the table then refill it with the data needed. Works pretty well.

[GaryMazzone]

My temp table is permenant, I call it temp because it fills only for the report and then gets emptied for the persons own data (that way more then one person can be running the report at the same time.)

[brucevde]

i've learned that before creating textfields, one has to add a database...

Crystal does not require a database. You can use an ADO Recordset as the data source for the report. When you create a new report and are prompted for the database choose More Data Sources -> Active Data -> Active Data (Field Definitions Only). You then Define the fields that will be in the Recordset. These field defs can be saved and consequently used in other reports. Since it is a simple text file you can also create them in any editor like notepad.

There is much more that you can do with Active Data reports, check the Developers Help file for more information.