Lee
asked on
Calling Crystal Viewer via ASP
I downloaded Crystal Viewer from SAP. In particular I needed 2011. I installed this on my target server. I have some Crystal RPT files which are reports I created. I need to be able to run those from ASP. I'm using Sage CRM which used to support Crystal Viewer, but for reasons unknown, doesn't any more. The ASP code that you code in is server side javascript using the COM API for CRM.
If I have an RPT file, how can I run that report and pass in parameters. Ideally I would be able to run the report by simply hitting a URL like you can in SSRS but for that I think you need full Crystal Enterprise and that is not an option.
If I wanted to call a report and have it show in the Crystal Viewer in a pop up, how would I do that? Can I then export to PDF or Excel from the viewer? I tried converting the reports to SSRS which would be perfect except I cannot control the grouping the way you can in Crystal, probably because I don't know how rather than the program can't do it.
If I have an RPT file, how can I run that report and pass in parameters. Ideally I would be able to run the report by simply hitting a URL like you can in SSRS but for that I think you need full Crystal Enterprise and that is not an option.
If I wanted to call a report and have it show in the Crystal Viewer in a pop up, how would I do that? Can I then export to PDF or Excel from the viewer? I tried converting the reports to SSRS which would be perfect except I cannot control the grouping the way you can in Crystal, probably because I don't know how rather than the program can't do it.
ASKER
Well in which case, I can't continue with the Crystal Reports plan. All I'm looking for is the ActiveX viewer for Crystal Reports. I was rather hoping it was installed as part of the Crystal Reports viewer application but I guess not. In which case, I'll go back to my plan of using SSRS and work out how to create grouping like in Crystal.
Here is a list of Crystal viewing applications with a review.
Some can be called from the command line or a batch file which might work for you.
Review
http://kenhamady.com/cru/comparisons/crystal-reports-viewers
Matrix summary
http://kenhamady.com/viewerfeaturematrix.pdf
mlmcc
Some can be called from the command line or a batch file which might work for you.
Review
http://kenhamady.com/cru/comparisons/crystal-reports-viewers
Matrix summary
http://kenhamady.com/viewerfeaturematrix.pdf
mlmcc
ASKER
Let me clarify this a little. I'm not looking for something that view the RPT file per se. I'm looking for a way of displaying the report in a pop up window which is called from some ASP code. I need to be able to pass in the parameters. With SSRS I can do it easily by using a URL to run the report.
The only way to call/view a Crystal Report is from an application written using the link I provided above for the version for Visual Studio
There is no separate ActiveX viewer.
mlmcc
There is no separate ActiveX viewer.
mlmcc
ASKER
There used to be one. I used to use it years ago.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ahh, nuts.
ASKER
To be fair it answered my question insofar as I can't do what I wanted to do.
That is a stand-alone application is not intended to be called as you desire.
To do what you want you need to install Crystal Reports for Visual Studio and build a Visual Studio application
See this page from SAP to download Crystal for VS
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads
mlmcc