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 can think of, but [...]

Answer Question   |  April 20, 2012  7:19 PM
Crystal Reports 8, Crystal Reports Database

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 AF_2011 after [...]

Answer Question   |  January 24, 2011  3:11 PM
Crystal Reports 8, Crystal Reports 8.5, iMIS, SQL Server

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 data for within each [...]

Answer Question   |  November 1, 2010  6:26 PM
Crystal Reports 8, Crystal Reports Buttons, Crystal Reports error messages, Crystal Reports Errors

CRYSTAL 8 PERCENTAGES
HOW DO I CREATE A PERCENTAGE IN FORMULA EDITOR

Answer Question   |  June 11, 2010  5:40 PM
Crystal Report, Crystal Reports 8

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? 

Answer Question   |  April 29, 2010  5:15 PM
Crystal Reports 8, Crystal Reports printing, Print Administration

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, ListItem.ItemID, Item.ItemName, ListItem.SaleQuantity, ListItem.SalePrice, ItemSale.SaleItemListID FROM Income INNER JOIN ItemSale ON Income.IncomeID = ItemSale.IncomeID INNER JOIN SaleItemList ON [...]

Answer Question   |  November 26, 2009  2:35 AM
Crystal Reports 8, SQL Server 2005 Express Edition, VB.NET 2005

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 classes’ properties can alos be [...]

Answer Question   |  January 22, 2010  3:50 AM
Crystal Reports, Crystal Reports 8, Microsoft Reports, VB.NET 2005

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 [...]

Answer Question   |  October 7, 2009  2:20 PM
Crystal Reports 8, Development

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

Answer Question   |  October 1, 2009  6:45 AM
Crystal Reports, Crystal Reports 8, Crystal Reports 8.x

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 (255) LTrim(BS.Comment) as Comment,  (varchar (6500)) BS.Content        (varchar(MAX) FROM Box_Set BS WHERE ((BS.Description LIKE ‘%’ + @KeyWord + [...]

Answer Question   |  October 19, 2010  2:23 PM
Crystal Reports 8, Visual Basic

Crystal 8 & SQL problem
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]

Answer Question   |  August 5, 2009  2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL

can I use accdb with Crystal report 8.0?
can I use accdb with Crystal report 8.0? Please help.

Answer Question   |  August 11, 2009  5:42 AM
ACCDB, Crystal Reports, Crystal Reports 8

Crystal Reports 8.5 Export Options
I am using Crystal Reports 8.5 to email a batch of reports. Destination property is set to 3. I am seeing the Export Options dialog box for Page Range for each report being emailed. This could be in the hundreds so I do not want to respond OK to the Export Options each time. Looking [...]

Answer Question   |  May 28, 2009  8:19 PM
Crystal Reports, Crystal Reports 8, Crystal Reports 8.5, Crystal Reports Export

Crystal Report 8
I am working on a report that prompts user for facility code and returns current population according to status. the User now wants a date range coded in but when the date range in place in the report the ability to is lost to function and before. (just put in a code and get current [...]

Answer Question   |  April 8, 2009  9:35 PM
Crystal Reports 8

Select printer from CRViewer in VB 6.0 and Crystal Reports 8.0
i use Rpt.PrinterSetup Me.hWnd this, to set up printer setup. it prints blank page

Answer Question   |  August 5, 2009  10:57 AM
CRViewer, Crystal Reports, Crystal Reports 8, Crystal Reports printing, VB 6, VB 6.0, Visual Basic, Visual Basic 6

Migration of Crystal Reports 8 to Crystal Reports 2008
How to migrate Crystal Reports 8.0 to Crystal Reports 2008? The crystal reports which had stored procedures of 8.0 are not executing in 2008, can anyone help? Thanks

Answer Question   |  January 15, 2009  2:19 AM
Crystal Reports, Crystal Reports 2008, Crystal Reports 8, Crystal Reports migration, Crystal Reports upgrading

Crystal Report 8 user settings
Where are user settings stored in Crystal Reports 8? In registry? a file (what is the name)?

Answer Question   |  December 19, 2008  3:09 PM
Crystal Reports, Crystal Reports 8, Crystal Reports 8 User Settings, Crystal Reports User Settings

Crystal Reports 8
To Change The position & property of the Text in the crystal report from VB.NET code itself…. is It Possible??? while the Crystal report connected….. By Raam87

Answer Question   |  December 3, 2008  6:04 AM
Crystal Reports, Crystal Reports 8, VB, VB.NET, Visual Basic, Visual Basic .NET

Selected Fields print in Crystal Report 8 or 9
Dear Sir, How I can print a report baised on col. selected by user (eq if there are 10 col. in report and user wants to see only 4 col.), in VB 6.0 and crystal report 8 or 9 Please help me

Answer Question   |  December 1, 2008  9:45 AM
Crystal Reports, Crystal Reports 8, Crystal Reports 9, Crystal Reports printing, VB 6.0

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 works. [...]

Answer Question   |  November 24, 2008  9:11 PM
Crystal Reports 11, Crystal Reports 8, Crystal Reports 8.5, Crystal Reports Errors