cancel
Showing results for 
Search instead for 
Did you mean: 

Calling Crystal Reports on MII

Former Member
0 Kudos

Hi all,

Is it possible to call a Crystal Rerports .rpt file in MII. I tried calling it using HTML and JSP pages. But no luck. When i tried calling it using JSP page, i got some errors as

package com.crystaldecisions.reports.reportengineinterface does not exist

import com.crystaldecisions.reports.reportengineinterface.;* and package com.crystaldecisions.report.web.viewer does not exist

import com.crystaldecisions.report.web.viewer.;*

First of all, is it possible to call an .rpt file in xMII. If yes how?

Where can i download the jar files related to crystal decisions. (on the above mentioned error). I tried in Business Objects and Java.com. But no luck

Kindly help me out.

Thanks In Advance

Muzammil

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Muzammil,

Integration with Crystal Reports is coming in MII 12.2, which supports custom tag library integration. For more information (other than the 12.2 RKT), you can check out the [help|http://help.sap.com/saphelp_mii122/helpdata/en/4a/c2b2f922da34c7e10000000a421138/content.htm].

Regards,

Kevin

Former Member
0 Kudos

Thanks for your reply Kevin,

But 12.2 is not in market and as far as i know it is not yet confirmed regarding the integration to Crystal reports.

I would like to know whether is there any way we can integrate lower versions of MII with Crystal Reports.

Regards,

Muzammil

Former Member
0 Kudos

MII 12.2 is currently in ramp up. Its worth a look, especially if integration for Crystal Reports is important to you.

Not sure about 11.5, 12.0 and 12.1 versions. I have yet to be exposed to any customer/partner integrating with Crystal Reports. Some are experimenting with Business Objects's Xcelsius, which can be used in older MII versions.

For the sake of the others on the forum, what version of MII are you trying to integrate with Crystal Reports?

-Kevin

Former Member
0 Kudos

Kevin,

I am currently testing the scenario on xMII 11.5. But planning to implement it at client side on MII 12.1.

Regards

Muzammil

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I am trying to create the zip file as mentioned in help

<http://help.sap.com/saphelp_mii122/helpdata/en/4a/c2b2f922da34c7e10000000a421138/content.htm>.

Where to find the class file "com.sap.xmii.report.web.viewer.ViewerTag"?

Does the zip file is already available on sdn with all crystal jar files? If so, anyone direct me where to find this file?

Thanks in advance,

Viswa

Former Member
0 Kudos

Hey Muzammil, What's up Man!

You might have already explored option of using the Business Objectsu2019 Xcelsius. I recently used it for a customer project and it works great!

Are there any specific reasons to use Crystal Reports?

Former Member
0 Kudos

Hey Ram,

Nice to hear from you after a long time.

Tell me how you integrated it with MII. Currently i am trying to integrate it with xMII 11.5.

I remember there is one article wriiten by David Mcknight "Intergrating Crystal Reports 2008 with xMII". The article ends at creating the .rpt file. Now i need to call this rpt file in my MII screens. Thats where i am getting stuck up. I tried calling it using JSP and HTML files. But no luck

Let me know if you find any way out.

Regards

Muzammil

0 Kudos

Muzammil,

Yes, support for CR objects directly in MII is built into 12.2 via the ability to upload J2EE reporting tag definitions. We are delivering via the SDN a download that defines CR tags for your JSP pages called: CrystalReportViewerCustomTag.zip

This means that your CR objects will be supported on MII hosted JSP and IRP pages. I canu2019t find the download at the moment on SDN, probably because 12.2 isnu2019t officially released yet; but Iu2019m sure if youu2019re working with a ramp-up customer they can request it via a CSN ticket.

Regards,

Sam

Former Member
0 Kudos

Hi Muzammil,

Someone asked me for all that I had on this a few days ago, didn't know that it would find it's way to you.

My conclusion was that it was a pain in the version of CR that I was using. I was connecting to MII via an XML connector, which in the version of CR that I was using at the time was not at all flexible to dynamically adding parameters on the fly. As far as I could recall, you can tack on parameters to the end of the .rpt (similar to an MII irpt) and call it directly as a URL into a new page or iFrame. Eventually I gave up because it wasn't friendly to work with and XSL to HTML/CSS gave me more than enough options and could be integrated into any scenario (just couldn't format for printing as nicely).

I am very interested to see the 12.2 advances in this arena.

Regards.

0 Kudos

Dave,

You could probably use the JDBC driver that we posted for integration with Visual Composer which makes each MII query template look like a table to the client system. This may be easier than a generic XML connector and also should reduce the communication/post processing overhead.

Regards,

Sam

Former Member
0 Kudos

Thanks a lot for your reply Sam,

Looking forward for MII 12.2 release. Excited to see how Crystal Reports work with that.

Regards

Muzammil

Former Member
0 Kudos

Dave,

Nice to hear from you after a long time.

I was trying to integrate xMII with CR using the document which you shared. But as i told before, got stuck up at the end.

If you find any other way out, like the one which Sam was explaining (Using JBDC Driver) , Kindly let me know.

Thanks in advance

Muzammil