Crystal Reports Failed to retrieve data from database.

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: Failed to retrieve data from database.

Author	Message
Logle0917 Newbie Joined: 21 Jul 2011 Location: United States Online Status: Offline Posts: 14	Topic: Failed to retrieve data from database. 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
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	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 www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Logle0917 Newbie Joined: 21 Jul 2011 Location: United States Online Status: Offline Posts: 14	Posted: 18 Aug 2011 at 9:53am
	connecting to an Oracle database.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.