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
0
votes
0answers
46 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'
0
votes
0answers
234 views

Crystal reports Logon Failed: ADO Error Code: 0x80040e4d - Microsoft Access Database Engine (Workgroup information is missing or opened exclusively)

I get the following error while trying to connect MS-Access 2016 MSO 32-bit to Crystal Reports VS13SP25_0-10010309 using C# 2017 (Community). Logon failed: Detail: ADO Error Code: 08x80040e4d ...
0
votes
0answers
34 views

Crystal Reports Dynamic Parameter Missing Values - not near 1000 limit

Crystal Reprots 2008. We use dynamic parameters to help group our customers.Generally they are Region > Country > Customer We currently use 5 regions: Africa, East Asia, Europe, M East & S Asia ...
0
votes
0answers
28 views

Change scheduled report instance in Crystal Server without running

Relatively new to Crystal Reports and Crystal Server and I've been playing around with scheduling report instances. I've noticed that when I have an existing scheduled instance and I change anything ...
0
votes
1answer
197 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 ...
1
vote
1answer
112 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 ...
0
votes
1answer
85 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 ...
0
votes
1answer
70 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 {...
3
votes
0answers
4k 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 ...
-1
votes
1answer
27 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 ...
0
votes
1answer
285 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 ...
0
votes
0answers
32 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 ...
0
votes
1answer
3k 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 ...
0
votes
1answer
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 ...
9
votes
0answers
586 views

Prompt for parameter of seperate 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 ...
0
votes
1answer
719 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 ...
0
votes
1answer
706 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 ...
1
vote
1answer
734 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 ...
-1
votes
1answer
95 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 ...
0
votes
1answer
366 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 ...
0
votes
1answer
4k 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.
0
votes
0answers
3k 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 ...
1
vote
1answer
787 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 ...
0
votes
0answers
129 views

At the moment, I'm having trouble deploying an ASP.NET Web Forms application (now targeting .NET 3.5) onto a Windows Server 2003 running IIS 6

At the moment, I'm having trouble deploying an ASP.NET Web Forms application (now targeting .NET 3.5) onto a Windows Server 2003 running IIS 6. For a long time, I did all of my development in VS 2008 ...
1
vote
1answer
4k 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 ...
4
votes
2answers
26k 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, ...
0
votes
1answer
569 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/ ...
1
vote
0answers
506 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.
0
votes
1answer
1k 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 ...
0
votes
2answers
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 ...
0
votes
1answer
616 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. ...
0
votes
1answer
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?
1
vote
1answer
857 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 ...
0
votes
1answer
139 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.
1
vote
0answers
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 ...
3
votes
1answer
4k 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 ...
0
votes
1answer
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 ...
0
votes
2answers
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 ...
1
vote
0answers
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, ...
0
votes
1answer
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. ...
1
vote
2answers
9k 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 ...