Questions tagged [crystal-reports]

Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources.

Filter by
Sorted by
Tagged with
10 votes
0 answers
839 views

Prompt for parameter of separate date and time values?

I'm working with Crystal Reports 2016. The data source is MS SQL Server 2008 R2. I am currently able to prompt the user for a date range for my report using a parameter. I would also like to add a ...
YetAnotherRandomUser's user avatar
4 votes
2 answers
29k views

Crystal Report ActiveX Viewer unable to run in Internet Explorer 11

I run into this problem when using IE11. The screenshot is as below: I've tried to disable the "Enhanced Protected Mode" in IE but it still does not work. I did not have this problem when using IE9, ...
rcs's user avatar
  • 901
3 votes
1 answer
5k views

Crystal Report is not reflecting the changes made in the System's Active Printer

I am working on a windows based application with c# and built in Crystal Report in Visual Studio 2005. CrystalReportViewer is the tool to show the report. I found that, my crystal report is not ...
John Smith's user avatar
3 votes
0 answers
5k views

mso20win32client.dll – Abending. Exception code: 0x012d9312, Crystal Reports, Office 365

Environment: OS: Windows 10 1709 Office 365: Ver. 1708 Crystal Reports: 11.5 Over 200 laptops all created from the same image and kept up to date with patching, running the same applications. Only ...
Roscoe314's user avatar
1 vote
2 answers
10k views

No Default Printer error when trying to print a crystal report

We have a website that is responsible for running a bunch of Crystal Reports and displaying them in the browser. This part works fine, however the website was recently set up on a new server and we're ...
Brandon's user avatar
  • 419
1 vote
1 answer
2k views

How do you subtract (X) of Days from (CurrentDateTime) then check with another Date

I am currently working with Crystal Reports XI and I am trying to make a formula that highlights ship dates that are withing 72 hours of the current date time. How would I go about making a formula ...
BSwordsman's user avatar
1 vote
1 answer
1k views

Crystal Reports Dynamic Parameter

Help someone. I have a Crystal Report (CR) that prompts for an acct number. The main report data source uses a sql view to take the acct number input and look up the information it needs to print ...
maggief83's user avatar
1 vote
1 answer
5k views

Modify value in a Crystal Reports number field based on value in another field

I want to create a conditional formula that will change the PP.POSPAY_SALARY_MIN column in my report, based on the value of another column. So here is the logic I am trying to duplicate, so far with ...
gbeers's user avatar
  • 11
1 vote
1 answer
613 views

Crystal Report crosstab calculation rounding up to whole number

I have created a report with a crosstab that displays a count of the number of records for given categories for each of the previous 6 quarters. I’ve inserted a calculated member column for the ...
Naia's user avatar
  • 11
1 vote
0 answers
594 views

In Crystal Report, Memo field is not displaying complete data

In Crystal Report, Memo field is not displaying complete data it is trucating to 260 characters. I have googled alot and tried, but still no success. Any suggetions ? Thanks in advance.
user233264's user avatar
1 vote
1 answer
990 views

Can I directly read Kaspersky reports?

Can I read a Kaspersky report file directly? I have access to the report.rpt and detected.rpt files, but it cannot be opened in a Crystal Report Viewer application. I get the following error when ...
user180828's user avatar
1 vote
0 answers
1k views

Getting "Invalid printer specified" when printing the first document

The error is that when a batch (about 15) of similar 1 page documents are sent to the printer from the server some of them (last time it was 5) fail with the message ‘Invalid printer specified’ and ...
user1561124's user avatar
1 vote
0 answers
1k views

Refreshing Crystal Reports through Excel Macro

At work we have an ancient Ingress database that wont allow me to make links between tables using the SQL Query editor in Excel 2007. My current solution is to generate the data in Crystal Reports, ...
BiGXERO's user avatar
  • 155
0 votes
1 answer
2k views

Installing Crystal Reports 8.5 on Windows 7

I have successfully installed Crystal Reports 8.5 on my Windows 7 desktop, but when I try to launch the application i get this: Any experience with this? Besides the obvious "update to as newer ...
Rusty's user avatar
  • 1
0 votes
1 answer
5k views

Cannot convert Crystal Report to PDF "Failed to Export the Report"

Our users cannot export their Crystal Reports to PDF in Windows 7 and 8/8.1. An error message pops up saying "Failed to export the report". Users noticed this occurred after a recent Microsoft update.
JasonH's user avatar
  • 131
0 votes
1 answer
845 views

Is it advisable to use Crystal Reports remotely with Amazon RDB [closed]

I'm looking into setting up a database in Amazon RDS for use with Crystal Reports. Crystal will be running in our office in California and the DB will reside in the Amazon cloud servers in Virginia. ...
Brien Malone's user avatar
0 votes
1 answer
153 views

Is there a way to restore cleared Kaspersky reports in Kaspersky 2013 version?

I have access to the report.rpt and detected.rpt files, but it cannot be opened in a crystal report viewer application.
Cek's user avatar
  • 43
0 votes
1 answer
4k views

crystal reports 11.5 "failed to create the Crystal Database Connector"

I am using crystal reports 11.5 and when I try to create a report I am getting the following error "failed to create the Crystal Database Connector". I have set up the System and User DSN in ...
Stefanie's user avatar
0 votes
0 answers
51 views

Zebra Printer - Missing Always use Driver Settings

We have multiple zebra label printers on a server for printing Crystal Reports. We have some printers that are using a larger 4 x 6 label vs the normal 4 x 3. On the older printers (GK420D) I was able ...
Niall's user avatar
  • 101
0 votes
0 answers
248 views

How to connect Crystal Reports 9 to MySQL database in Windows 10

I'm trying to connect MySQL database to Crystal Reports 9 in Windows 10, but I get this error. Query Engine Error: 'Cannot find DSN in connection string'
Masaba James Moses's user avatar
0 votes
1 answer
946 views

Negative amounts on crystal report not showing up when one of the formula values is zero

I have a report with a formula field that calculates the difference between two fields: Original Contract Change Orders Current Contract 50,000 20,000 ...
BrendaStewart's user avatar
0 votes
1 answer
406 views

SAP Crystal Reports Gauge Chart - Format numbers without zeros

Is there a way to exclude the decimal values on a Crystal Reports gauge report. In the example below, I would like to display "73,190" not "73,190.00". Right clicking on the selected item and ...
John Cee's user avatar
0 votes
1 answer
332 views

Error in formula that no longer exists

I'm using CR Professional - version 11.0.0.1282. When running a report through an external program I get the below error: Error in formula Font_Color: 'if not isNull({InvItems_2.TYPE}) and {...
BDM's user avatar
  • 427
0 votes
0 answers
36 views

Why is the database tab not functional in Crystal Reports 9?

I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
Ian Horn's user avatar
0 votes
1 answer
5k views

MsiInstaller error 1935 HRESULT: 0x8007054F when installing SAP Crystal Reports x64

Installing the x64 version of Crystal Reports we get the following error on random machines: Product: SAP Crystal Reports runtime engine for .NET Framework (64-bit) -- Error 1935. An error ...
Ignacio Soler Garcia's user avatar
0 votes
1 answer
1k views

What is the difference between OLE DB and ODBC in relation to a Crystal Reports datasource connection?

I'm relatively new to Crystal Reports and I'm testing out various report viewers. When I made my report in Crystal reports, apparently I used an OLE DB connection to the data source, in this case SQL ...
YetAnotherRandomUser's user avatar
0 votes
1 answer
1k views

Section suppression formulas for multi-select parameters in Crystal Reports 11.5

I'm trying to figure out how to create a section suppression formula that evaluates all the selections in a multi-select parameter. For instance, if the parameter is "Program" and you can select from ...
ct253704's user avatar
0 votes
1 answer
426 views

How do you disable Auto Updates for Crystal Reports 2013?

Our network configuration on the machine where we run Crystal Reports 2013 changed and it can no longer access the internet. So, when we launch Crystal Reports 2013, the application hangs on startup ...
JoeNahmias's user avatar
0 votes
0 answers
4k views

Crystal Reports keeps asking for username/password

A different user is trying to run an existing crystal report. They are able to access the report but when they click refresh it is asking for a username and password to connect. The data source ...
maggief83's user avatar
0 votes
1 answer
573 views

Consolidating one column of data into an existing row of data in Excel

I have a Crystal Report that is exported as data only into excel to create a flat file. The issue is that the way the data is returned in crystal, it returns a record that looks like this: Date PT/ ...
N Christian's user avatar
0 votes
1 answer
2k views

How to edit Column in Command in Crystal Report?

I have one issue, there is one column in Command who's length is restricted to 255 characters, so if there is more data than 255 characters to display then it is getting truncated, I need to know how ...
user avatar
0 votes
2 answers
3k views

Crystal Report (8.5) on win7/windows 2008 64 bit system [duplicate]

Crystal Report (8.5) is not working on win7/windows 2008 64 bit system My application is a VB application and I am using Crystal report 8.5. It is working fine on 32 bit system and 64 bit system of ...
user2447682's user avatar
0 votes
1 answer
2k views

Can one export a crystal report in ".txt" format, by using Crystal Reports interface/software?

I have crystal reports 2008, which allows to export reports in word (rtf), excel and pdf formats. Is it possible to export a crystal report in text format?
Ankit's user avatar
  • 115
0 votes
2 answers
2k views

Crystal Reports 8 - Error 533 PESStartPrintJob

We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly no ...
Federico Giust's user avatar
0 votes
1 answer
3k views

Printing to PDFCreator from Crystal Reports embedded in a Visual Basic Program

I've got a legacy app, written in VB6, using Crystal Reports 8 (not 8.5 - just 8). What I need to do is to figure out how, programmatically, to generate or export a PDF version of a report. ...
Zeke Hansell's user avatar
0 votes
1 answer
397 views

Microsoft Framework Update (KB4054981) Causing Issues With Crystal Reports 13 Not Displaying

Per the title, I am having issues getting a Crystal Report to display on my website. Here are the necessary details: Microsoft security and quality update for framework 4.6/4.7 was applied to a ...
PhoenixFly's user avatar
-1 votes
1 answer
124 views

Is it possible to convert a .RPT to a .RFL?

I frequently go through a multi-step process of selecting IDs from a table, which then get exported either to a DBF or copied into a cloud-based solution. Then, I run a handful of reports in Crystal ...
Ian Horn's user avatar
-1 votes
1 answer
89 views

Crystal Reports 2013 Generated SQL Syntax Error on Data Refresh(no quotes for column name with spaces)

I am using SAP Crystal Reports 2013 (not the viewer), and working on a form with an ODBC (RDO) Data Source Connection, which was set up in the ODBC Data Source Administrator application using MySQL ...
Kyle S's user avatar
  • 1