Thank you all for spending time on this in order to help me.
Let me explain the problem in detail.
I have designed the reports using Aliases and report uses only one table. Project schedule is such that we want to convert these the conversion data source from existing table to a stored procedure (having simple query from same table with some where clause) in minimal time.
I tried to change the location of source using "Set Location" command under Database menu. Set Location dialog box shows Alias name under Database menu. Using Set Location button I changed the location to a stored procedure. The message I get when I click on Done is "Error opening file. There are no fields in the file: Proc(proc_name;1)".
When the database was set to Table the "Show SQL Query" was showing "Select Alias.Field1, Alias.Field2,... From Table_Name Alias"
After converting to stored proc it shows "Select Alias.field1, Alias.Field2,... From Proc(Proc_Name;1) Alias"
My question here is, can we change the query stored with Crystal Report to {call Proc(proc_name;1)}. This is the query crystal report stores when a report is originally designed with stored procedure. But if fields on the report are coupled with source type (Table or stored proc) then I think this is not possible. Curious to know about any workaround that is available to trick the crystal reports.
Your time and help is appreciated.
Thanks,
Ritesh