Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old March 10th, 2004, 12:15 PM
Wyv Wyv is offline
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 'Exists' sql query

Hello!

Okay, the question doesn't have much to do with dotnet but more with crystal reports itself. Sorry about this.

Maybe anyone could explain to me how to add a sql query (well, an 'exists' query like 'and not exists record with the same itemcode and different inserttime') into a report based on an MS Access database (no ODBC connection I'm afraid).

I tried to use the sql designer but that requires an ODBC connection as far as I can tell.

Thanks for helping,
Wyv

  #2 (permalink)  
Old March 11th, 2004, 10:13 AM
Wyv Wyv is offline
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I forgot, I use Crystal Reports 8.5.

Thanks.



Similar Threads
Thread Thread Starter Forum Replies Last Post
sql query i need seearam MySQL 7 November 30th, 2008 03:14 AM
Output Query to txt file from SQL Query everest SQL Server 2005 4 November 22nd, 2007 01:49 AM
if exists query foddie MySQL 5 June 30th, 2007 06:46 PM
sql query plug_samir SQL Server 2000 1 May 17th, 2005 08:26 AM
Test to see if a SQL Server exists Mitch Access 2 July 18th, 2003 04:29 AM





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