Crystal Reports Development working and combining multiple database applications

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.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
WHat version of Crystal?
The tag says CR8.5

CR8.5 does not have COMMANDs and really does not support multiple data sources except through the use of subreports.

Does the data in the 2 queries need to be correlated together or can a subreport for one or the other work?

What database engine are you using?
If it is Access can you crate a linked table in one of the databases to the other database?

mlmcc
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
WHat version of Crystal?
The tag says CR8.5 ................... YES it is  CR 8.5

CR8.5 does not have COMMANDs and really does not support multiple data sources except through the use of subreports........I was aware and I think I can use that myself however powers that be seem to want to use Stored Proceedures.....

Does the data in the 2 queries need to be correlated together or can a subreport for one I think it can....not sure why client wants SPs.....I know about 80% of what the client needed for this project and I told them that. I am attempting to get ahead of the curve and see if I can identify what I need to learn quickly so I can keep this job.
or the other work?  

What database engine are you using? Microsoft SQL Server
If it is Access can you crate a linked table in one of the databases to the other database?
0
mlmccCommented:
I believe you can create a link between 2 MS SQL databases and thus essentially link one table from the old database into the new database.

Are they trying to be able to compare data by years?

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
James0628Commented:
Stored procedures are potentially more efficient, because the server can analyze the SP and create an "execution plan" for it, to try to run it as efficiently as possible.  And if you need the same data for multiple reports, they can all just run the same SP, instead of needing to add the query separately to each report.  And if you need to change the query later, you change one SP, instead of changing the query in each report.

 When you create a report, you can choose a SP as the datasource, and CR will get the list of SP parameters, if any, and the SP fields from the server, and then you just use the fields in the report, just like you do with a table.  At least, that's how it works in CR 10.  I haven't used CR 8.5.

 As mlmcc suggested, you can can create a linked server in MS SQL that points to a table in another server (or something else, like an Excel file), and then use that table in your SP like any other table.

 James
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
THank you gentlemen
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.