Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [crystal-reports]

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

-1
votes
1answer
7 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
0answers
23 views

Crystal Reports - Show only if over 3 years old from today's date

In Crystal Reports how can I get a field to show only if date of last gift is over 3 years (1095 days) from the current date?
0
votes
0answers
131 views

Where does Crystal Reports need TNS names to be?

I'm running Crystal Reports 11.5 on a Windows 7 machine. When I try to connect to Oracle database in Crystal, I get the following error: Failed to open the connection. Details: ORA-12154: TNS:could ...
0
votes
1answer
120 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
477 views

Crystal Decisions always installs 64bit runtime but 32bit is needed

VS2017, .NET framework 4.5, WinForm app, C#, Release set to 32bit, development machine is Win10 64bit. I have installed the deployment plugin and created an install project. All of the dlls ...
0
votes
0answers
20 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
1k 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
1k 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 ...
8
votes
0answers
348 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
414 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
403 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
508 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
68 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
289 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
3k 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
2k 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
605 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
124 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
22k 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
534 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
440 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
1answer
3k views

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

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
507 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
1k 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
802 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
131 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
3k 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
1k 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. ...
4
votes
6answers
6k views

Alternatives to Crystal Reports [closed]

which alternative reporting software applications besides Crystal Reports do you recommend for generating reports from DB sources? Please also include some comments regarding strength/weaknesses of ...
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 ...