Questions tagged [crystal-reports]
Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources.
38
questions
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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, ...
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 ...
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.
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. ...
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.
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 ...
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 ...
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'
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 ...
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 ...
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 {...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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/ ...
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 ...
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 ...
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?
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 ...
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.
...
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 ...
-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 ...
-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 ...