Suppress lines in Crystal Reports 8

Records sorted by field a + b. If field b = "I", don't print but do print rest of records till a changes again. No problem but if field not = "I", I should bypass all till sort changes; can't make this work.

cselzer5 pointsBadges:

Linking in Crystal Reports 8.5 and 11 question.

I currently have a report written in Crystal Reports 8.5 and I need to left join some tables. When I change the tables to left outer join I get these error messages stating: General SQL Server: Check Message from SQL Server and Error Detected by Database DLL. When I revert them back, the report...

Metalteck5 pointsBadges:

Creating Crystal Reports

 am really new to Crystal Reports (currently using version 8.5) and I would like to create a new report based on another.  Basically I am trying change the SQL query of the original report and since I can only view the query, I am assuming that I will have to create a whole new version of the...

BostonBears5 pointsBadges:

Crystal Reports 8 export troubles

I have an older application which uses Crystal Reports 8 and we use the ActiveX viewer. We turned on the export button in the viewer. The export feature works on some machines but on others it works up to the point of displaying the window that allows the user to choose where to save the file. This...

ruifrazao50 pointsBadges:

Crystal Reports 8.0 Error

I have created a formula called @DateCode: WhilePrintingRecords;NumberVar dblYear:= 0;NumberVar dblWeek:= 0;StringVar strYear:= "00";StringVar strWeek:= "00";StringVar strDate:= {OrderDet.User_Text1};DateVar dtDate;DateTimeVar dtDateTime;StringVar strDateCode:= "0000"; If IsDate(strDate) Then(...

ShopTechBBaxter25 pointsBadges:

Select Criteria

I want to pull data from Item Descriptions utilizing only certain words within the description; i.e., Vesuvio Beige Hand Board. I want to pull all records with the words "Hand Board" in the description and I'm having trouble getting that to happen.  I've tried "is like", "in" and everything else I...

NN5 pointsBadges:

Crystal Reports 8.5 iMIS 10.6 database

I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to...

Mystic15 pointsBadges:

Summarize Maximum Summary Values in Crystal Reports 8?

I need to be able to summarize the Maximum Value for multiple groups in a report. Because I'm using the Summary function, I'm getting an error that it's not possible to do this. Any ideas? I am desperate! Unfortunately the data I am exporting populates multiple (but inconsistent) lines of duplicate...

Allie08175 pointsBadges:

Not Supported Error in Crystal 8

I have a report designed in Crystal 8 that is ment to display the data from the stored procedure that has 1 parameter passed. SELECT BS.Box_Set_ID,   (int) BS.Date_Stored,  (datetime) BS.Shelf_Location, (varchar (255)) BS.NumOfBoxes,   (int) LTrim(BS.[Description])as Description ,  (varchar...

Vswindell5 pointsBadges:

CRYSTAL 8 PERCENTAGES

HOW DO I CREATE A PERCENTAGE IN FORMULA EDITOR

Tninj5 pointsBadges:

page size

A crystal report with a large amount of data prints some of report then prints error message 'the page size was not large enough to format the contents of an object in the report.  What should I look for to fix this problem? 

Jab720 pointsBadges:

Crystal 8.5 VB6 application deployment

Deployed CR 8.5 in VB6 app. When accessing reports receive error "Unable to create ActiveX object". I included large list of DLLs for Crystal 8.5 runtime but something is missing.

Bliever20 pointsBadges:

Crystal Reports 8.5:

The data source for a given report does not stay permanently associated with that report. If I open a report using a different data source, that data source becomes the data source for all subsequent reports. The only way to correct it is to go to File Options and change the default data source...

Saques5 pointsBadges:

How do I view a Crystal Report using properties of my object classes.

In my project I have a lot of object classes. For exaple Student object class: This represents a single student with properties such as Studnet Name, Age, StudentID ect. Now I want to create reports for my application. While designing the report (using crystal reports), I've found that my object...

Obhasha0795 pointsBadges:

Crystal Reports problem

here's the coding for my crystal report display The above code is written in the report viewer form's load event method. 'this is the query for my dataset (used in objItemSale.GetSaleData(string) function) SELECT ItemSale.BillNo, ItemSale.IncomeID, Income.IncomeDate, Income.IncomeValue,...

Obhasha0795 pointsBadges:

export crystal report to flat file in fixed length with headers and footers

Hi; I need to produce a flat file in fixed length format as output of Crystal Reports version 8.5. The issue I am having is that the file has a batch header and trailer record which must be placed in the header and footer sections of the report. I also have multiple subreports within the details...

Enigma15 pointsBadges:

Delphi 5 and Crystal Reports 8.5 and User Function Library

Hello all,    I am trying to create a UFL in Delphi 5 for use in Crystal Reports 8.5.  Does anyone know how to successfully do this?  I have some examples, but they all leave out some information and I end up not being able to create the UFL and use it the way it is supposed to work. Thanks, Ric

Ricm25 pointsBadges:

how to display tree view data in crystal reports

i want to display data in crystal reports with Tree nodes. how is it possible??

Toheedsoft5 pointsBadges:

DB2 indexes and Crystal Reports

Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?

AJ525 pointsBadges:

Blobs and Memos in formulas

I need to use a field that is varchar2(2000) in the Oracle.  How do I use this field in a formula in Crystal Reports 8.5?

Jab720 pointsBadges: