Hello,

I have recently been tasked with reworking some reports that we use in the finance department.  I am somewhat familiar with Crystal Reports and SQL.  I have run into the problem of working with work tables.  I am unfamiliar with these.  Trying to use crystal reports to customize a built-in report has proved to be impossible, and now I know why: work tables.

So, how do I go about sourcing out from which tables these are pulling the data from?  I know that stored procedures are used to create the work table.  We are using V 6.3, and we do not have the schema explorer available to use.  From my research, it would appear that I need to run a SQL trace to find out what is happening when a report is run, but I do not know how to go about this.

Any advice or tips would be much appreciated.

Thank you,
Aaron

Quick Update, still hoping someone can save me some work:

I ran a trace through the SQL profiler while I ran a report.  There must be an easier way to determine what tables the report uses to pull the data.  The SQL trace ended up with hundreds of lines, and this is after I filtered out only my actions and those of the stored procedures.  Any help?

Aaron