cancel
Showing results for 
Search instead for 
Did you mean: 

stored procedure and web service connection in same report

former_member309127
Participant
0 Kudos

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

Is it possible to provide a Stored procedure Connection and Web Service Connection in a same report?

What are it's advantages and drawbacks?

Accepted Solutions (1)

Accepted Solutions (1)

former_member292966
Active Contributor
0 Kudos

Hi Sailee,

What's possible and what you should do are two different things. Is it possible, yes. Will it work, probably not. Crystal still uses relational database concepts. It needs to link table objects. There is no way to link these two objects so Crystal will attempt to do something and there's a very good chance it may crash, stall the database, return records that make no sense or it may actually work.

If possible, it would be better if you can use one of those in a subreport and the other in the main report. Then Crystal calls them independently but it depends on how your data is structured and the type of report you are designing.

Good luck,

Brian

former_member309127
Participant
0 Kudos

Hi Brian,

Thank you so much for explaining. It helped me understand the difference.

I am retrieving logo image from stored procedure and from web service the actual data for report.

-Sailee

former_member292966
Active Contributor
0 Kudos

Hi Sailee,

I've done something similar in just the main report and it's worked as long as you don't get Crystal to link them together.

The backup here is you could have the logo in a subreport and have the webservice in the main report. But try with just the main report, it should work.

Brian

former_member309127
Participant
0 Kudos

Hi Brian,

Thank You.

It works.

-Sailee

Answers (0)