Print Page | Close Window

using temporary tables

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13240
Printed Date: 02 May 2024 at 7:06am


Topic: using temporary tables
Posted By: ediecrystaluser
Subject: using temporary tables
Date Posted: 17 May 2011 at 9:32am
I have a crystal report that also has a subreport inside it and the report is running really slow.

I wondered if I can create 2 temporary tables within the main report, left outer join the 2 and go that route instead of the route I've taken.

The problem is I only have read-only access to the database and I wondered if I can create these temporary tables outside of a stored procedure.

Basically I need to know if I can do what I need in a command. Any examples would be greatly appreciated.

Thanks!


Replies:
Posted By: DBlank
Date Posted: 18 May 2011 at 4:00am
you may write a complex sql statement using the command option.
an example is a little tricky as I don't know your structure, what you are trying to accomplish nor why a crystal outer join using the standard DB option is not sufficent.


Print Page | Close Window