Home / SAP Crystal Reports

SAP Crystal Reports

DAO Error Code: 0xccb

  2548907 – Error: ‘Logon Failed. Unexpected error from external database driver’ when refreshing a report based off MS Excel in Crystal Reports and in SAP BI LaunchPad Version 11 from 01.11.2017 in EnglishShow Changes Component:BI-RA-CR Priority:Normal Category:Problem Release Status:Released to Customer Symptom DAO Connection to Excel fails. ODBC connection …

Read More »

Crystal Reports 2016 Report Application Server (Failed)

I am going to apologize right off the bat as I may rant a little. 🙁 1.  The install for RedHat Enterprise Linux 7 is not straight forward in the install documentation. Problems found: #1 You must export LD_LIBRARY_PATH=/home/yourusername/SAP_CRYSTAL_SERVER_2016_SP02_LINUX__64B__/DATA_UNITS/CRServer_lnx/dunit/product.crystalserver2011-4.0-core-32/actions #2 The second thing is you need to copy this file …

Read More »

The Product keycode is not valid. INS00140 Error appears in Validation Result window during Crystal Reports installation

Symptom The Product keycode is not valid. INS00140 Error appears in Validation Result window during Crystal Reports 2011 installation Environment Crystal Reports Reproducing the Issue Run Crystal Reports setup.exe Enter valid keycode when prompted Cause There is a conflict between keycode validation process and Microsoft Visual C++ Redistributable Patch KB2467175 …

Read More »

Connecting Webservice as a datasource

Hi, Blog post explain the steps to be followed to connect webservice as a datasource from Crystal report. Watch this video to connect webservice as a datasource. https://www.youtube.com/watch?v=4zQTxQIZT-4 In some cases, accessing datasource will not be smooth as shown in the youtube video. You may get issues like I mentioned …

Read More »

Seven New Videos on SAP Crystal Solutions 2016 – The Ever-Popular Reporting Software Available on SAP Store

In my last blog, I wrote about the latest on SAP Crystal solutions, our easy-to-use report-building, data visualization, and data exploration software – namely, new licensing options expanding the potential of these powerful tools. Since SAP Crystal solutions are available self-service on SAPStore.com, our online marketplace, we’ve created seven new …

Read More »

Error messages on Crystal Reports

Error messages related to Crystal Reports include categories following: • Opening documents. • Connections to databases. • Extracting data from a database. Unable to open this document. He … not This is not a Crystal Reports document. cause This occurs when a user tries to open a file Crystal Reports …

Read More »

Reporting is ease with SAP Crystal Reports

Reporting is essential in order to achieve success, the prerequisite for any business is to take benefit of enormous data available. I  am writing this  blog as a part of  my assignment for the course ERP Applications – BCO6181 – Victoria University of Technology taught by Tony de Thomasis. I …

Read More »

Sparkline charts in Crystal Reports!

I’m cross-posting this from my main blog. I’ve never quite got the hang of uploading files here, but all files can be downloaded from the original blog entry. I had an interesting time at a customer site recently. They were converting reports from Excel (ugh) to Crystal Reports. The Excel …

Read More »

SAP Crystal Report Dynamic Search Based On Filter

This document provide details as if you would like to search base on filtered records criteria from Data Source. Initially you have to create two parameters. First ‘filter‘ parameter for criteria and second ‘searchInput‘ parameter for searching in receptive criteria. filter – String (Multiple Values) searchInput – String Select desire …

Read More »

Multi Column SAP Crystal Reports

If your requirement is to print the report data in multiple columns instead of having your data print straight down the page, you can set up multiple columns and have the data flow from column to column. 1. Open the report you want to format with multiple columns. 2. On …

Read More »

Crystal Reports Installation Instructions (simplified)

Start by saving your Crystal Reports download to your desktop: The file will be similar in naming convention to: “51047194_CR2013_SP2_WIN32”.  If your downloaded file does not match the contents displayed in the below instructions, please contact your vendor for an alternate download link. Then Extract the files by “right clicking”, …

Read More »

Crystal Reports FAQ

TABLE OF CONTENTS: Are There Tutorials Available? I am Having Trouble Installing the Program Is There a Support/Maintenance Program for Crystal Reports/Dashboard Design/Lumira (Desktop Products)? Where can I get Service Packs for Crystal Reports or Dashboard Design? What Support is There Available for Crystal Server? What is Available for a …

Read More »