Skip to Content
0
Former Member
Jul 22, 2016 at 02:45 PM

Multiple Oracle Stored Procedures in a Single Report.

57 Views

Hello Developers,

I got a new requirement to create a single report based on 4 Stored procedures. The above requirement can be done by 2 ways

Process 1 :

I can add with database expert but I really struck at the linking portion.

Can any one explain me how to link the 4 SP's or provide any document regarding it.

Process -2 :

We need to merge the 4 SP's into a single SP and use it to create the report.

Can anyone tell me how to combine the 4 SP's into a single SP and also is there any precautions need to be taken from SP.

Kindly, suggest me which is the best process and also suggest is there any other good process available to meet the requirement.

NOTE : Currently, I'm using Crystal Reports 2011 and There will be no sub -reports required.

Thanks,

Preethi.

Attachments

Linking.JPG (84.4 kB)