Thank you so much for answering my question. Yes it would be more easier if I do that, but, The process that we have is to do everything in crystal....No filtering outside the crystal...We're using ODBC connection to get the data and then deploy the CR report to different locations, so whenever someone open and run the report he don't need to run the outside process to get the records. We're using ODBC connection so he can run the reports wherever we put the reports and connect the tables thru ODBC.
One more question, Can I pass a parameter from Main report to Sub-Report? Or it's just the sub-report can pass parameters to Main report?
Thanks and I aprreaciate it!