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 [...]
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 [...]
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 [...]
HOW DO I CREATE A PERCENTAGE IN FORMULA EDITOR
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?
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 [...]
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 [...]
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 [...]
i want to display data in crystal reports with Tree nodes. how is it possible??
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 + [...]
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 [...]
can I use accdb with Crystal report 8.0? Please help.
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 [...]
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 [...]
i use Rpt.PrinterSetup Me.hWnd this, to set up printer setup. it prints blank page
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
Where are user settings stored in Crystal Reports 8? In registry? a file (what is the name)?
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
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
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. [...]





