Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 8th, 2005, 04:52 AM
Registered User
 
Join Date: Jul 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Roopedog
Default SQL in Crystal Reports

Is there something wrong with the SQL I am using in a Crystal Report.

The code is as follows

Select Hole.`Par`
From Hole
Where Hole.`Hole_Number` = 1 and Hole.`Course_Name` = Scores.`Course_Name`

 
Old August 9th, 2005, 07:18 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

Can you check without quotes for Coloumn names.

also the alias "Scores" should be mentioned

Select Hole.Par
From Hole, Scores
Where Hole.Hole_Number = 1 and Hole.Course_Name = Scores.Course_Name


Gokulan Ethiraj





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports 8.5 with SQL 2000 jroxit SQL Server 2000 2 March 20th, 2015 01:39 AM
Crystal Reports 8.0 , My Sql 5.0 with Vb6.0 thiyagu6682 Pro VB Databases 0 August 21st, 2007 08:22 AM
Crystal Reports v8 with SQL 2005 VBM2 VB Databases Basics 0 November 14th, 2006 09:04 AM
DateDiff in SQL using Crystal Reports 10 jmwiggins SQL Server 2000 3 August 10th, 2006 11:21 AM
SQL, ASP and Crystal Reports neeter SQL Server ASP 1 June 13th, 2003 03:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.