Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing report database table name at runtime

Status
Not open for further replies.

newora

Programmer
Aug 19, 2003
133
GB
I wonder if someone couold please help me with regards to an issue that I am having with Crystal Reports 6 (still yet to upgrade I am afraid).

I have created a report with just one Oracle database table on it. This table is effectively a 'template' table and at runtime when the user runs the report, I create a new dababase table from the template table and then fill the new table with the appropriate data.

I thus then want to tell the Crystal report that the table in the database has changed name (the new table is still in the same daabase schema). The new table name is exactly the same format as the template table, of course - is is just called something different.

I thought that I might be able to do this via the datafiles property of the Crystal report active X control, but it only seems to work for Acess databases, so I can see from the documenattion.

Maybe what I am trying to do is not possible, but any help / comments would be much appreciated.

Thanks
Newora
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top