I am going to have to combine an older DB applications data with a newer DB application. The combining of the two databases with make up one Crystal Report. I may need to use Stored Proceedures and or SQL Queries.....so
Question 1 .....( are they not the same thing...?)
Question 2 When creating the SP or Query....How does Crystal know how to pick up/use the values stored in the SP/Q....is it simply due to a match found in the naming of the values in the report vs the SP/Q. Or is it when the report is run and the SP/Q is activated and called to pull records that Crystal sees the parameters and thus the records are returned....?
Question 3 ..... For the purposes of Crystal Reports can I combine the two DB applications old and new into one SP/Q and have Crystal Point to it and get the data there or is the ODBC going to cause problems....
Any help is geatly appreciated.