Saying "temprory table", do you mean that you collect data from different
tables, databases and put them into a temprory table and then use this temp
table as data source for your report? As far as Crystal Report goes, it does
not care the data for its reports is from temp table or not. It is not a
Crystal Report issue.
At least you have two ways to get your data into a "temprory table" and use
it for report data source:
1. Use temprory table in SQL Server. In SQL Server, you can easily write
some T-SQL code in SP to collect data from different tables/databases into a
temp table and return data in this temp table to a report. Since you use SQL
Server, it is one of the basic skill to learn.
2. Use Crystal Report's "PUSH" mode to get data for report. With "PUSH", you
can use ADO.NET to get all kind of data into a DataSet, whether they are
from the same database/table or not. In this sense, it is a temprory table
in memory of app-running computer. Then you use this DataSet as report's
data source (push it into a report).
<ai*****@hotmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Hello,
I've scoured groups and the web, and haven't found a question like mine
answered.
I'm using Visual Studio 2003 with the Crystal Reports it comes bundled
with and SQL Server 2000. Throughout the project I'm working on, I
often find I need a temporary table displayed in a report, something
that I cannot seem to do. Since temporary tables are so useful, I
cannot imagine Crystal Reports wouldn't have a way to get such
information in, so maybe I'm looking in the wrong places. Is there a
way to do it, or at least a workaround solution?
Thanks in advance,
Conrad Eaglehill