Stack Overflow
Stack Overflow

Questions tagged [crystal-reports-8.5]

Crystal Reports 8.5 is a reporting tool released in 2001 by Crystal Decisions.

Crystal Reports 8.5 is a reporting tool released in 2001 by Crystal Decisions and purchased by SAP in March 2008.

In addition to integrating fully with Crystal Enterprise and supporting the Extensible Markup Language (XML), Crystal Reports 8.5 introduced Report Alerts, allowed the exporting of data to PDF, XML, RTF, and HTML, and added support for native drivers as a data source for MS SQL Server, DB2, Oracle, Informix, and Sybase.

When using this tag, also use the tag for increased visibility.

Useful links

Other versions

Other related tags

166 questions
7
votes
2 answers

Modifying a cross join query

I have this query that I found that I want to modify in order to get an extra column and also sum the last 3 months of the amounts found. I want to make a Crystal Report for this. Query below. SELECT dbo.[@EIM_PROCESS_DATA].U_Tax_year, …
Kinyanjui Kamau
  • 1,890
  • 10
  • 55
  • 95
6
votes
3 answers

Display Serial Number as Roman letters in Crystal Reports

need to display serial no as roman letters(i,ii,iii,iv etc) in my crystal reports. I have the serial number captured as record number (1,2,3,4...).so what i have to do for it in crystal report.
Sivajith
  • 1,181
  • 5
  • 19
  • 38
5
votes
2 answers

Crystal Reports - Count Formula

I am developing a report in Crystal and I need to do a count on a particular field that has several different statuses. For example, I have a "StatusType" field in my report that contains values that are "In Process", "Rejected", "On Hold", or…
Trish
  • 93
  • 1
  • 4
  • 12
3
votes
3 answers

My Crystal Report is not getting refreshed while passing parameter?

I have created my Crystal Reports using SQL query in Crystal Reports itself, by passing two parameters, i.e, say for eg:- Month & Year. While I preview the report, I can able to navigate through all pages by passing different parameters and its…
Dineshkumar R
  • 55
  • 4
  • 8
3
votes
1 answer

Crystal Reports 8.5 SetDataSource generates empty error message

I have a VB6 application that uses Crystal Reports 8.5 to view reports. I now have created a new report that uses an SQL Server stored procedure as a data source. When viewing this report in my application I use a ADODB.Recordset as a data source…
Martin
  • 1,184
  • 8
  • 24
3
votes
2 answers

Crystal report sub report overlapping

I have developed crystal report with 4 sub reports. Data volume of the sub reports are depending on the demand of the report. When I put in those sub reports inside detail block it overlapping each other depending on their data volume. When I put…
Nilantha Ekanayake
  • 161
  • 1
  • 2
  • 4
2
votes
5 answers

ODBC Connection / Crystal Reports

We have some VERY old Crystal 8.5 reports (slated for re-write in Crystal 2016 this year), which have stopped working yesterday. They use Crystal Query (.qry) files as their data sources running against an Oracle Database 12c (12.2.0.1.0)…
SmallFry
  • 143
  • 2
  • 9
2
votes
1 answer

Export to PDF option is missing in crystal report 8.5

I am using vb6 and crystal report 8.5 The problem which I am facing is that on client machine (window 7 32bit), when I open report there is no option “Export to PDF” in export button. While it is running fine and showing “Export to PDF” option on my…
user2185199
  • 41
  • 5
2
votes
1 answer

Crystal report formula for adding/subtracting value from one field to another field

I have a report which has two fields: BOX and TRAYS, which are then summarize in each group using sum formula. And then there is a grand total of these fields are also shown. Now the problem is that I want to convert trays to boxes if their count…
Mehmood Hassan
  • 147
  • 8
2
votes
1 answer

Formula field not showing in crystal report 8.5

I'm using an old version of crystal reports 8.5 and I'm having problems in showing a field in the details. This report uses 6 tables in SQL Server database: 2 in database1: tblRecibo, tblCanaisDistribuicao 3 in database2: tblPessoas, tblMoradas,…
RagnaRock
  • 2,432
  • 7
  • 34
  • 56
2
votes
2 answers

Can you pass a parameter longer than 255 characters from VB6 to Crystal Reports 8.5?

VB6 closes without an error message on the line below when "strCompany" is longer than 255 characters. Is there some way to make this work? rptReport.ParameterFields.GetItemByName("@company").AddCurrentValue (strCompany)
JHanz99
  • 31
  • 4
2
votes
0 answers

Lite weight extensions or plugins for displaying crystal reports

I am new to crystal reports, during execution of my project I'm not able to see the reports on screen. Its displaying an empty page. I have already install Run time crystal report version=13.0.10.1385 of size 200 MB (from this URL…
Muhammed Imran Mohyuddin Quadr
  • 21
  • 2
2
votes
2 answers

How to create Table in Crystal Report

Create Table in Crystal Report I am newbie to Crystal Report, and i am using Crystal Report 2008. I want to know, do we have table object in Crystal Report.. so that i can draw a table with specific rows and columns, and drag and drop the items to…
rajkan12
  • 45
  • 2
  • 3
  • 13
2
votes
2 answers

If I group in Crystal Reports to get the distinct records, my total varies

My situation is almost like this link. I grouped and suppressed the detail and displayed result on group header, but @total is summing all records rather summing the distinct one's . Please suggest how to achieve this.
Teju MB
  • 1,333
  • 5
  • 20
  • 37
2
votes
1 answer

Crystal Report 1 field should be at the same line

Im using Crystal Reports,and I have an output like this: NumberId ART_No InkColor ------------------------------------------ 0010 23003 BLUE 0010 23003 RED …
Captain16
  • 327
  • 2
  • 8
  • 19
1
2 3
…
11 12