Can’t link tables in Crystal Reports
I came a cross a wired scenario the other day. Although we could see all tables of a database in Crystal, we could not establish manual links. When right clicking on a field only ‘Browse’ option was available. The ‘Start link’ option was not visible. any ideas?

Answer Question   |  October 16, 2012  10:19 PM
Crystal Reports, Crystal Reports Database

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 Paradox Tables – data problems
I am creating a report in Crystal XI using multiple paradox tables. If I use an idapi connection I lose data when I access the second table. If I switch to a DAO connection it runs very slow locally and will not event connect at all if I try to access the data from a [...]

Answer Question   |  March 31, 2012  2:54 AM
Crystal Reports, Crystal Reports Database, Crystal Reports XI, Paradox

Crystal report when database is empty
Can you write a crystal report when the tables are empty?

Answer Question   |  February 28, 2011  3:28 PM
Crystal Reports, Crystal Reports Database, Crystal Reports formulas

Crystal Reports 2008 Error Failed to retrieve data from the database. TABLE space exhausted
won’t display over 300+ pages at one time, get this error message: Failed to retrieve data from the database. Details: HY000:[ODBCLINK Host]

Answer Question   |  December 13, 2010  9:45 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Database, Crystal Reports error messages, Crystal Reports Errors

Crystal report viewer
Open REport – No Saved Data This report file does not contain saved data and cannot be viewed. New install of CR 2008 viewing rport over vender database. How do I link data to reports I write?

Answer Question   |  October 7, 2010  2:17 PM
Crystal Reports, Crystal Reports 2008, Crystal Reports Database, Database issues, Link option, Windows XP

Crystal Reports 9 Formulas
I am using Crystal 9 reports. The formula is an IF formula but one of the columns returns as a blank as there is no data, crystal doesn’t read this as a value < 0 as it is blank, how can I get crystal to read a blank in the data field whilst writing a [...]

Answer Question   |  October 6, 2010  2:32 AM
Crystal Reports, Crystal Reports 9, Crystal Reports Database, Crystal Reports formulas

Summary of time in HH:MM:SS format in Crystal Report
How to display duration from DB in float value in cross tab report as HH:MM:SS format. Requirement as follows: Date     Abdul Anwer     Tiger Woods     Total 08-17                         00:00:25     03:15:58 07-21                         00:00:01     03:15:58 07-17   02:36:57         00:29:32     03:15:58 07-16                         00:02:34     03:15:58 07-06   00:00:45         [...]

Answer Question   |  November 11, 2009  10:07 PM
Crystal Reports, Crystal Reports Database, Crystal Reports XI

pasting a database query into crystal
I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

Answer Question   |  June 19, 2009  4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries

error detected by database DLL
please explain this error message in crystal reports

Answer Question   |  October 3, 2010  3:31 PM
Crystal Reports, Crystal Reports Database, DLL

Crystal Reports database
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]

Answer Question   |  October 28, 2011  8:48 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming

viewq
how do i access database views in Crystal Reports

Answer Question   |  April 14, 2009  6:22 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x, Crystal Reports Database

Crystal Report Database Queries
I have a crystal report (XI) with approx 25 tables querying from MSSQL Server. I was wondering if there is a limit to the number of tables allowed in a query. or a limit to the number of alais allow against specific tables? Reason I ask: I recently tried to add tables (alias of tables [...]

Answer Question   |  March 20, 2009  3:35 PM
Crystal Reports, Crystal Reports Database, Crystal Reports XI

Database Connection Error
When I opened a crystal report from design mode to Preview mode It thrown this error:’’Database Connection Error:’Cannot obtain Error message from server’ and, ODBC Error(Merant) ODBC Oracle 8 Driver ORA-06550:Line1,Column8,PLS-00201:identifier’xxx.PRC_RI_REPORT’Must be Declared ORA-06550:line1, column 8: pl/sql Statement ignored Error Detected by Database DLL And,Database Connection Error

Answer Question   |  March 4, 2009  2:09 PM
Crystal Reports, Crystal Reports Database, Crystal Reports error messages, Database Connection Error