-
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.
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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(...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
-
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...
Last updated: -
HOW DO I CREATE A PERCENTAGE IN FORMULA EDITOR
Last updated: -
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?
Last updated: -
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.
Last updated: -
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...
Last updated: -
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...
Last updated: -
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,...
Last updated: -
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...
Last updated: -
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
Last updated: -
how to display tree view data in crystal reports
i want to display data in crystal reports with Tree nodes. how is it possible??
Last updated: -
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?
Last updated: -
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?
Last updated: