Skip to Content
0

stored procedure and web service connection in same report

Apr 26, 2017 at 08:48 AM

123

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Brian Dong Apr 26, 2017 at 05:42 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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

0
Former Member

Hi Brian,

Thank You.

It works.

-Sailee

0