Crystal Report 10 How to Reset all Subquerys

In response to : Are you using a COMMAND as the data source?

I am not sure how I would use COMMAND as the data source.  If that means am I using A SQL Server-Based Stored Procedure then No not at this time.  Otherwise I am not sure what you are asking.?  Or do you mean am I connecting to the SQL server through an ODBC connection?

Here are the issues we are facing:

We have reports that were written in Crystal Report 8.5 and run on an Informix 7x database using AIX.  

The database has been migrated to a Windows 2003 server, running SQL Server 2000 database and we are using the same reports (written in 8.5) with Crystal Report 10x.

The report that I am testing has a main Query (which I connected/"SET" to a new location, new database, same tables names and columns).  Then I have some 50 plus subroutines that need to be reset.  I open the SQL box of the subquery1, I get a query that does not appear to be joined to anything or even each other.

-- BEFORE reset -----------------------------------
SELECT
[subquerytable1].[ColumnName1],
[subquerytable2].[ColumnName2],
[subquerytable3].[ColumnName3],
[subquerytable4].[ColumnName4],
[subquerytable1].[ColumnName5],
[subquerytable1].[ColumnName6],
[subquerytable1].[ColumnName7],
[subquerytable5].[ColumnName8],
[subquerytable1].[ColumnName9],
[subquerytable1].[ColumnName10]
FROM [subquerytable1] subquerytable1,
  outer [subquerytable4] [subquerytable4],
  outer [subquerytable3] [subquerytable3],
  outer [subquerytable5] [subquerytable5],
  outer [subquerytable2] [subquerytable2]
WHERE  subquerytable1.[ColumnName1]=11111

-- AFTER Reset -----------------------------------
SELECT
[subquerytable1].[ColumnName1],
[subquerytable2].[ColumnName2],
[subquerytable3].[ColumnName3],
[subquerytable4].[ColumnName4],
[subquerytable1].[ColumnName5],
[subquerytable1].[ColumnName6],
[subquerytable1].[ColumnName7],
[subquerytable5].[ColumnName8],
[subquerytable1].[ColumnName9],
[subquerytable1].[ColumnName10]
FROM (((DatabaseName.[dbo].[subquerytable1] [subquerytable1]
INNER JOIN [DatabaseName].[dbo].[subquerytable4] [subquerytable4]
 ON [subquerytable1].[BCode1]=[subquerytable4].[BCode4)
INNER JOIN [DatabaseName].[dbo].[subquerytable3] [subquerytable3]
 ON [subquerytable1].[LCode1]=[subquerytable3].[LCode3])
INNER JOIN [DatabaseName].[dbo].[subquerytable5] [subquerytable5]
 ON [subquerytable1].[MCode1]=[subquerytable5].[MCode5])
INNER JOIN [DatabaseName].[dbo].[subquerytable2] [subquerytable2]
 ON [subquerytable1].[RCode1]=[subquerytable2].[RCode2]
WHERE [subquerytable1].[ColumnName1]=11111
----------------------------------------------------------------------

I am wondering if I have to reset all 50 plus subquery SQL Statements just to make this report run.  This is not the only report, and every one of the reports I will need to run has many subqueries.  

I am looking for a Global Reset All SubQuery command button.

Somewhere I read that Subreports should not be used anymore, instead Stored Procedures need to be called in to replace the subqueries.  I plan to look into some basic Subquery/Stored Proc replaced report soon.

Is this a viable route to take, basically rewriting all the reports and their subqueries?

Thanks for your input.

Subreports have a place and it really depends on what you are trying to accomplish with them.

A COMMAND is a new feature added with CR9 so since these are CR8.5 reports you aren't using one.

I don't follow the subquery issue.  The query you showed  after reset is joined though the joins have been changed to INNER instead of OUTER.

Do you have subreports that use other queries that need to be changed?

mlmcc