Re: Crystal Activex Report Viewer Library Xi
Evagret Homestead
The context is: I have multiple crystal reports that are exported from SAP and dumped into a network location. Each needs to be converted to excel before being imported into an access database. I have Crystal Reports viewer and I'd like to programme it (using access VBA) to open each report and save it as excel in a new network location. I have downloaded two library references for use in Access that I thought were relevant (crviewer.dll & craxdrt.dl). However, this is not something that I've been able to achieve.
While you can indeed create your own code to do this, there are a few 3rd-party viewers (see list here: Crystal Reports Viewers, Schedulers and Related Products) that provide a command line API, so your VBA code can easily ask the viewer to export the report to Excel. There are also 3rd-party Crystal Reports desktop schedulers (Crystal Reports Viewers, Schedulers and Related Products) with command line APIs and at least one of them can also export directly to a table in your MS Access database and either append or replace records in an existing table.
So. The upshot of all of this is that if you want to use a VB script / ActiveX SDK, you will need to obtain CR XI R2. This version of CR was retired a number of years back, so I am not sure if you can still purchase it from SAP. Give SAP sales a dingle and see: 866-681-3435 or 1-800-677-7271
Thank you Ido and Ludek for your detailed answers. Have looked at some of the 3rd party viewers that you mention and I reckon that they might be able to achieve what I want (schedule the export of reports in .xls) without having to introduce VBA.
I have an install program I wrote back in 2005 or so that will install the run time RDC files needed. I worked with Business Objects and Progress software in developing install, and we use it today were I am now employed. It allows our progress software to start a report and pass parameters to the report, like field values or a filter. If anyone is interested, you can send me an email at and I will send a copy no charge. It is really too bad that a big company like SAP cannot come up with a newer version of this, as who the H... wants to have to put these values is each time/ We use it to create custom order guides for our customers with pictures and everything, with all the information being pulled and passed from or SX ERP system. -Dennis-
Anyone wanting to contact you can Direct Message you by hovering their mouse over your name. From there you can choose to communicate any way you want. Or in your profile you can expose your email too.
This is what we do in Powerbuilder. First we did this in the Open event of our window, but if there's a popup in the crystal report asking for parameters, this would enter in and endless loop of asking for the parameters. Therefore we now do this in an event POSTED from the Open() event:
Also, if interested in getting more information on how to wrap a visual .net assembly into an activex, Marco has posted some useful links to some presentation of Bruce Armstrong: -a/use-of-crystalreports-net-dll-in-pb-2019
* SAP Crystal Reports: allows a report designer to include data from various sources to create a document on his/her desktop computer where the data is formatted into a design of their choosing, such as an invoice, a sales or operational report, a marketing letter or some sort of analytic visualization.
* SAP Crystal Server (previously called SAP Crystal Reports Server) provides a platform environment through which you can access and share documents (such as SAP Crystal Reports files) with end users.
With SAP Crystal Server 2020 (user) - user stands for named user license - you can schedule reports to be pushed out to recipients as PDF email attachments, access reports securely, and refresh the data by entering various parameters as a named user.
---
With SAP Crystal Server 2020 (CS) - CS stands for Concurrent Sessions - you can automatically distribute reports customized for individual recipients and access reports securely in a concurrent manner.
* SAP Crystal Reports for Visual Studio (using.NET) and SAP Crystal Reports for Eclipse (using JAVA) are free add-ons for developers using .NET and Java to embed reporting capabilities into their own applications.
* SAP Crystal Reports, version for the SAP Business One application allows users of SAP Business One to create pixel perfect reports and dashboards by connecting exclusively the SAP Business One data model with the SAP Crystal Reports environment. You can launch SAP Crystal reports and dashboards directly from SAP Business One. If you want to connect to additional data sources including SAP Business One data sources, you will need to acquire SAP Crystal Reports 2020.
* Note that 3rd party applications from various vendors can leverage a runtime license of SAP Crystal Reports. These are typically sold with the 3rd party application. They cannot be purchased from SAP, but a user can buy the full version of SAP Crystal Reports to also leverage data from outside the 3rd party application.
Start with SAP Crystal Reports to create a report. SAP Crystal Server distributes reports by pushing reports out, for example as a scheduled email attachment. SAP Crystal Server also provides a portal for end users to access content securely via browser or mobile app to view, enter parameters, refresh and print or export a report.
Number of employees:
* 2 employees creating reports and refreshing reports on demand
* 25 employees refreshing reports on demand (5 at the same time)
* X recipients receiving 1 or more scheduled reports personalized for each of them, such as invoices and internal sales reports (the number of reports and unique recipients are unlimited)
People who use SAP Crystal Reports are usually those who use data a lot in their day-to-day role, such as Database Administrators, IT, Finance, Accounting, and Power Users. The people who log on to the portal provided by SAP Crystal Server to access pre-built content are usually end users, business users, and management; in other words, consumers of reports who want answers to business question already asked on their behalf (by those who created the report with SAP Crystal Reports).
* SAP Crystal Reports 2020, (64-Bit) Named User License: This desktop on-premise product is sold on a Named User License basis; one unique license is required for each person using the software. That individual as the Named User License holder may install the software to any number of computers (including concurrently), any number of times for their exclusive use with a valid, non-expiring license code; a Named User License cannot be shared with another individual.
* SAP Crystal Reports 2016, (32-Bit) Named User License: This desktop on- premise product is sold on a Named User License basis; one unique license is required for each person using the software. That individual as the Named User License holder may install the software to any number of computers (including concurrently), any number of times for their exclusive use with a valid, non-expiring license code; a Named User License cannot be shared with another individual.
SAP Crystal Server 2020 has two types of license: Named User (user) and Concurrent Sessions (CS). Licensing determines access to the interfaces where documents are shared, and available for viewing: BI Launch Pad, SAP Mobile BI app.
* The SAP Crystal Server (user) license includes 1 named user license of SAP Crystal Server 2020 and 1 license of SAP Crystal Reports 2020. It also comes with support for mobile access on iOS devices. The user license allows usage by a single, specific individual user only. Test and Development licenses are included in your purchase and you can run these if you have active Production Licenses.
Included with the software download options for SAP Crystal Server (user) is another edition of report designer, SAP Crystal Reports for Enterprise. An individual who is a license holder of SAP Crystal Reports can use their SAP Crystal Reports keycode to install the corresponding version software for SAP Crystal Reports for Enterprise.
* The SAP Crystal Server (CS) license includes 5 concurrent users, which means that only 5 users can access the environment at the same time. SAP Crystal Server (user) is a prerequisite for SAP Crystal Server (CS). After that, the customer can purchase blocks of 5 concurrent sessions. Test and Development licenses are included in your purchase and you can run these if you have active Production Licenses.
Important note: Only SAP Crystal Server 2020 (CS) includes Automated Publishing, a feature where the data in a report is unique for each recipient (such as invoices and statements). Automated Publishing can be used for an unlimited number of unique recipients.
SAP Crystal Reports can be accessed through Citrix terminal servers or Microsoft Remote Desktop, but the number of named user licenses purchased must equal the number of individuals that have access to the software. Client applications that are accessed via terminal servers are considered server applications for the purposes of determining redistribution right. Each individual user using SAP Crystal Reports Client thru Citrix will require a named copy of SAP Crystal Reports. If a customer buys SAP Crystal Server they will need the equal amount of named user licenses.
For many customers, a combination of user and CS licenses is appropriate depending on the mix of user types. CS licenses is best for casual reporting users, while user licences are best for managers, executives, and analysts needing dedicated access. SAP Crystal Server deployments are limited to a single server and both user and CS licenses can be combined in any way. When adding new licenses to an existing system, the new licenses are additive. The total number of licenses available for a single deployment is the sum of the licenses in all installed key codes.
7fc3f7cf58