Print Page | Close Window

Failed to retrieve data from database.

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14124
Printed Date: 20 Apr 2025 at 11:58am


Topic: Failed to retrieve data from database.
Posted By: Logle0917
Subject: Failed to retrieve data from database.
Date Posted: 18 Aug 2011 at 5:07am
I have a report with two tables when I only had one table I receive data I joined the other table and added one field from that table to my report and I get this error Failed to retrieve data!  Please help


Replies:
Posted By: hilfy
Date Posted: 18 Aug 2011 at 9:34am
What type of database are you connecting to?  Which version of Crystal?
 
Assuming that you're not connecting to a file-based database like dBase or Paradox, go to the Database menu and select Show SQL.  Copy the SQL statement and run it in a tool that will connect to your database (e.g., SQL Server Management Studio, SQL+, Toad, etc.)  This will validate whether or not the query works.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Logle0917
Date Posted: 18 Aug 2011 at 9:53am
connecting to an Oracle database. 


Print Page | Close Window