Crystal Reports





Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am working on a VS2008 project which uses crystal reports.
All the crystal reports appear with VS2017 icon and when i click on it , it would not open. Instead it gives the message
"Please wait while windows configures Crystal Reports Basic for VS 2008."
What should be done to fix this issue?
crystal report  .rpt file

Thanks in Advance
OWASP: Avoiding Hacker Tricks
LVL 13
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

How do you [1] remove the dashes AND [2] force 9 characters in a social.  For example 54-03-9999 becomes 054039999.
We are wanting to apply a cascading parameter on a crystal report and are experiencing a limited result set when using this dynamic parameter. Other than updating the registry, are there any other ways CR can/will provide the entire set of records?

Cascading Parameter:  Customer Territory (users chooses one territory from a list of available territories)   Customer Account Number (user chooses one or multiple customers from a list of available account numbers from within that territory).

If anyone has had experience with having to update the registry of the users workstations, have you experienced any issues after doing so?

Is there any way within a native CR to automatically query and autocomplete lookup fields so we don’t have huge drop down lists created by the dynamic and/or cascading parameters?
Hello dear expert,

Since few days, I'm trying to connect my crystal report software to Solarwinds Log & Event manager reports DB but I still get the following error:
Failed to open the connection. Details: JDBC driver not found.
Even if the JDBC driver is present on the server.


I made a copy of one report and try to edit it with Crystal report. What happen?

1.  When I remove some columns or I edit existing content and run the edited report on LEM Report Manager, it works
2.  But When I add a new column and try to the same report and try to run it, it says "Logon failed. Error Code: -2147189176"

Is there any expert with both Crystal report and Solarwinds LEM knowledge?

Many thanks,

Christian K.
Hi Experts,

 Currently , I am using SSRS reports which has 3 params (states,districts and Cities) based on user selection(can have multiple values), passed into a stored procedure.
The stored procedure has a temp table which is populated after performing calculations on some columns based on joining many different tables. It returns the temp table output.
Now we are moving to Crysral reports  11 . What is best approach in reusing this SP in CR ?  From what I have read here, CR works differently from SSRS in that it calls SP and then allow CR engine to perform operation? where as in SSRS, I select  from 3 params and hit View report button which run the SP with params passed into

I'm trying to make this Crystal Report like the Excel report.  I'm having trouble with making it like the Excel report.

I've attached both files...  Thanks for your help.



Is there a way to pass to a Crystal Report the database connection? What we are hoping there is way to pass the the report via the VB.NET application the database to connect. This way whether we are publishing our application to a Test/Q&A server or to a production server, we do no need to edit the connection in each report prior to publishing.
Using Crystal Reports 2016 SP7

I have a formula that returns the correct value when using one set of criteria but when I duplicate the formula and change one criteria no value is returned.

Slots Formula:

if {LicenseParts.LicensePartType} = "GAMING"
and  {LicenseParts.LicensePartSubType} = "SLOT MACHINES"
then ToText({LicenseParts.Quantity},0)

Open in new window

This returns correct data.

Now I modified the formula to look for "TWENTY-ONE instead of "SLOT MACHINES"
and it does not return a value.

Twenty-One Formula:

if {LicenseParts.LicensePartType} = "GAMING"
and  {LicenseParts.LicensePartSubType} = "TWENTY-ONE"
then ToText({LicenseParts.Quantity},0)[code]

Open in new window


Below is what the SQL Data looks like:

I have two MySQL databases that have the same table structure and common data. I need to generate a report that will combine some the data found in both databases for matching entries into a final total value. For example:

Database A, field Name = 1234, value = 1111
Database B, field Name = 1234, Value = 2222

Report result = Name 1234, value = 3333
Values place in a sub report need to be placed in a Main report not for calculation purposes, just text fields

The link between Main Report and SubReport is SalesOrder and Company...

The problem is that when the report runs the values from the sub report are showing from the previous linked record...

The sub report is inserted into GH1a (Group is done by SalesOrder) and I need the Main Report formula values to appear in GH1b GH1c,GF1b

The sub report Detail is where I have the following

Shared StringVar FIL001:={Filoo};

The Main report has the following placed in the GH1b section

Shared StringVar Fil001;

So Salesorder 00001 shows perfect.. the problem is that SalesOrder 00002 shows the same values and it shouldn't as the sub report should have a different value for Fil001

Hopefully this makes sense
Expert Spotlight: Joe Anderson (DatabaseMX)
LVL 13
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

When I am grouping fields in my crystal report, I have added a formula to the group expert options formula saying IF {CnAct_1AttrCat_4.CnAct_1AttrCat_4_Description} = "A" then "IMMEDIATE PRIORITIES" else "TOP PROSPECTS". This works great until the end, when it adds another TOP PROSPECTS name to the end of the report. Does anyone know how I can fix this. The group footer is already suppressed.
{CnAct_1AttrCat_4.CnAct_1AttrCat_4_Description} = "A" then "IMMEDIATE PRIORITIES" else "TOP PROSPECTS"{CnAct_1AttrCat_4.CnAct_1AttrCat_4_Description} = "A" then "IMMEDIATE PRIORITIES" else "TOP PROSPECTS"

I need to do an analysis report based on a date range that will vary (added by the user) but wouldn't be based on "actual data" included in the report - rather I would use formulas to determine sums by month.

For example - user adds a date range via parameter 1/1/2019 - 5/1/2019

The report formula output would look like this:

Date                                   # of Appointments   # of Closed             $ Closed
January, 2019                                   4                        2                         $500
February, 2019                                  6                         1                        $200
March, 2019                                       5                       4                          $600
April, 2019                                          2                        0                          $   0

Thank in advance!
I had this question after viewing Loop Through Database/Report Fields.

I need to create a report of number of customers who are at a store at the same time for every hour.  I attached a file with the data and desire output.  I spent a lot of time on this trying to do it in SQL but it got too complex.  I think the best approach is to use arrays in Crystal but I am no expert in Crystal.  I appreciate any help.Number-of-Customers-per-hour.xls
All of a sudden I am getting a "Could not open the data folder" error with a CR.

We use CR with Sage. Sage won't open the report.

I opened CR and tried to preview the report and received the message above.

I can open Excel and make an external data connect so I know my user name and password are ok.

I have a report with a field in GH4 that shows total service cost for a part.  I'd like to summarize the total in GF4, but Crystal is so kindly multiplying that value by how many records are in the details.
In the screen show, my sum should be 720, not 1380 - which is 660+660+60.  I don't want the extra instance of the 600 since it's not real.  (Note that I had another detail line at one point and was getting (660*3)+60!)


First of all, why is Crystal doing this??  Second, how do I make this stop?  
I've tried this field in every other GH, GF and detail section on the report to no avail.  I have to leave the summaries in the footer they are in, or the summarize of the wrong group level.

Thanks in advance for your help~
I have a crystal reports server 2016 that uses tomcat 8 apache web server running on Windows 2008 server.

The SSL certificate expires soon so we purchase a new one for the same domain.

I ran same steps to install the SSL certificate as 3 years ago on Tomcat 7 but Whenever I call the web server via browser I get a spinning wheel for a while and then this error

I also updated the tomcat "Server.xml" config file to reflect the new java keystore name and new keystore password and restarted the web server.

This page can’t be displayed
Turn on TLS 1.0, TLS 1.1, and TLS 1.2 in Advanced settings and try connecting to  again. If this error persists, it is possible that this site uses an unsupported protocol or cipher suite such as RC4 (link for the details), which is not considered secure. Please contact your site administrator. 

Open in new window

Here are the steps i used to create the keystore and import certificate to it.

1) Generate a Keystore

cd C:\Program Files\Java\jre7\bin

keytool -keysize 2048 -genkey -alias tomcat -keyalg RSA  -sigalg SHA256withRSA -keypass secret19 -keystore tomcat10.keystore

Open in new window

2) Create a CSR

keytool -certreq -alias tomcat -keyalg RSA -sigalg SHA256withRSA -keystore tomcat10.keystore -file 

Open in new window

1. Install root, intermediate and user certificate

keytool -importcert -alias root -file c:\cert_2016\Apache\GoDaddyRoot.cer -keystore tomcat10.keystore

keytool -importcert -alias intermediate -file c:\cert_2019_new\gd_bundle-g2-g1.crt -keystore tomcat10.keystore

keytool -trustcacerts -importcert -alias tomcat -file c:\cert_2019_new\7e73f2ce88c70361.crt -keystore tomcat10.keystore

Open in new window

Do you know what could be the problem?

I tried to check the tomcat  log for any hints but there does not seem to be any errors.
I created a sub report in PH of Main Report, I am trying to get the Variable that I created in the Subreport to show per GH2 of Main Report, but it only shows the last value...I need the NetSales to show for every row but change based on GH1...I then need to do calculations on this Variable..Hopefully this makes sense.

If you look at the attachment I sent...I am hoping to get the 5th column to say 6784566...per row until the next GH1 shows then it will show 1707098.. The value that it currently shows is the very last GH1 374511.

Hopefully this makes sense
Removing Business Objects from SAP and still Using Crystal Reports..

I have read several threads and they really don't make sense to me

Will I still be able to go into BEx Query Designer and create queries and then report off of these queries in Crystal?
Will these queries look any different in Crystal than they do know.. Fields etx…?
Will I be able to publish these Crystal Reports that are designed off of these BEx Queries and publish via Email with SAP Managed security?

Loaded questions but I need more "Layman" answers.. Please help if possible

We are using VS 2015 , ASP.NET Ver 4.6  and Crystal Report 13.0.13. The crystal report load event hangs indefinitely after some printouts on function  "  objrep.Load(FileName) "
This report has 3-4 sub reports within it.
(I have attached the files)

We had checked for following points

1)   Crystal report is properly closed  and disposed. (Infact we have created Singleton class for loading so we know there are not more than 5 objects at any given time. If more than 5 objects we had we simply close all before starting new report)  

2) Windows\Temp folder has full permissions

3) We have selected "No Printer" in the Page Setup.

During  load testing some time we are able to print more than 50-60 reports at a single go, but when it starts to get hanged on " .load" then it does that forever and only way to rework is to either restart the IIS or change the application pool for that particular website. (Also one strange problem during testing also noted that before crystal report started to hang, it gives wrong RTF formatting, once after restart the same report comes good)

Also some other reports are working in different application pools on which we can print 1000's of reports without any problem.

Can somebody help us what to check next.
I am attaching 2 files, one containing the code where it hangs and second (which may not be required where we create a Singleton class to make sure we don't have too many instances of crystal report running)
Learn SQL Server Core 2016
LVL 13
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Hi there,

I have a simple cross tab that tallies data in three rows.  One row identifies meeting totals, the other visit totals and the final pending visits/meetings.  Is there a way to include meetings and visit totals in the grand total but not pending? We want to see them with the other data but not include it in the totals.

Thanks - CS
Update database connection to legacy Crystal Report on Windows application server.
I am trying to update the database connection to a legacy Crystal Reports server.
Server:  64 bit Memory 4Gb RAM
OS: Windows Server 2012 R2
Crystal Reports:
Crystal Reports 2008 Runtime SP1 (8.51)
Crystal Reports Basic Runtime for Visual Studio 2008

The reports are part of an application created/supported by MS VS 2008.  I'm not privy to the creation of the scripts, but believe they were created around 2005.
My task is to realign the reports to the new database.

Problem:  I am running SAP Crystal Reports 2013.  I can easily open the report with my client Crystal Reports and make the edit.  Upon closing/saving,
I get a pop-up window stating:
SAP Crystal Reports
   This report is from a previous version of SAP Crystal Reports:
    Title:  rptComponentClassification.rpt

Do you want to overwrite it with the latest report format?

Note:  Overwriting the file will prevent it from being opened by any version of SAP Crystal Reports prior to version 9.
This is what I've tried to do.
1.  I did go ahead and acknowledge the pop up and overwrote the file.   Still not able to evoke the report through the application.
2.  Tried to changed the report in the VS2008 and got the same popup.
3.  If I dbl-click the report to open and edit, I get the Windows pop-up:  How do you want to open this type of file(.rpt)
     Ah ha!  So…

I am trying to determine if I should have the PTO accrual in Sage or write a formula in crystal report for it to accrual in the direct deposit. Some employees have special agreements where they accrue more PTO days than others. Also, the PTO accrues rate changes based on the number of years employed. My also concerns are payroll corrections and how that would affect the PTO accrual.

Any tips and recommendation will be greatly appreciated.

Recently upgraded CR runtime on the server to 13.0.22.  Clients with windows 8 IE 11 are have issue with exporting data from reports. Reports come up in the viewer no problem.

Clients with windows 10 IE 11 are having no issues. The window 10 machines are 64 bit and the Windows 8 are 32 bit. On the server, the CR runtime is 64 bit. Could this be the issue?
Having a difficult time adding Vertical Lines and Horizontal lines,,,,the Horizontal lines need to be only where the last set of data is...and it appears to be 2 lines below the last line,

The vertical lines (there are many as I was trying to guess where to put them) need to end on the last horizontal line...
Need a formula field in Crystal to look at the entire column, to find duplicate.

if it finds duplicate, it would create a  tick symbol else it would be blank

Crystal Reports





Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Top Experts In
Crystal Reports