Home > Crystal Reports > Crystal Reports Error In Compiling Sql Expression

Crystal Reports Error In Compiling Sql Expression

So once i leave is it possible to do all extarctions using CR. mlmcc 0 LVL 34 Overall: Level 34 Crystal Reports 33 Query Syntax 6 Message Active 1 day ago Accepted Solution by:James06282008-11-21 James0628 earned 500 total points Comment Utility Permalink(# a23018961) My only option is to close it without saving changes and reopen it - then it works fine again. Where am having problem is creating sql expression not sql command. http://swirlvision.com/crystal-reports/crystal-reports-515.html

When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message.. So you probably will need a summary function. The bug only affects SQL Expressions that contain a correlated sub-query. Works fine now, 10x !!!

Join & Ask a Question Need Help in Real-Time? All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. During this time, we had upgraded to oracle 10.

May 15 '07 #1 Post Reply Share this Question 11 Replies Expert 2.5K+ P: 3,235 Motoma What do you mean, exactly, when you say "extract?" You can use CR to query Some components may not be visible. At this point in time, they work with Crystal Reports 2008, which has a very low adoption rate, and I haven't heard of them being deprecated in Crystal Reports 2011, which System Administrator February 7, 2006 at 10:41 You may want to try a simple SQL Expression (e.g.

Contrary to what mlmcc said, in the SQL expression you Go to Solution 12 6 6 +1 4 Participants cheyanne040277(12 comments) mlmcc(6 comments) LVL 100 Crystal Reports94 Query Syntax8 Badotz(6 comments) I have done till here. Please support the forum! http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=1257 What's more, ONLY MainQueryTable1 contains the account numbers; the id field from MainQueryTable1 is the only field that can be used to join MainQueryTable1 to MainQueryTable2.

Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily. Already a member? Right now, I have it as the actual value, so if I go to Database, Show SQL Query in Crystal for the whole report, I get the following statement. Just thought I'd ask.

Well I recently learned that this is not precisely true. guys, Need help.. You'll need another approach. Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal

I have one more question. http://swirlvision.com/crystal-reports/crystal-reports-error-717.html Get an experienced instructor to teach at your office using your data. Try: ( SELECT SUM(SALE_COST) FROM TEST_TBL WHERE (EA_SUBTYPE = ‘Hours') OR (EA_TYPE = ‘Labor' AND EA_SUBTYPE = ‘ ‘) ) Qry August 8, 2006 at 21:25 cool! Posted on 2008-11-18 Crystal Reports Query Syntax 26 1 solution 3,718 Views Last Modified: 2012-08-13 The following is my SQL Expression: (select distinct count("x"."evid_id") from "reptext" "x" INNER JOIN "evidence" "e"

I can't see any way to get that to work. You can use it to see the query that CR passes to SQL and see if something funny is happening behind the scenes. Creating SQL Expressions is dependent upon your database and the database driver. http://swirlvision.com/crystal-reports/crystal-reports-gdi-error.html The exact tables are there.

I connected ODBC so that i could write sql commands, but i get this error... The multi-part identifier Contact1.AccountNo could not be bound. Thank you. 0 LVL 34 Overall: Level 34 Crystal Reports 33 Query Syntax 6 Message Active 1 day ago Expert Comment by:James06282008-11-24 Comment Utility Permalink(# a23031991) You're welcome.

Thanks May 18 '07 #10 reply Expert 2.5K+ P: 3,235 Motoma Creating an SQL based report in CR does not require any manipulation inside the SQL Expression Field.

I have a table that contains details of Customers. Please help! ( SELECT SUM(SALE_COST) FROM TEST_TBL WHERE (EA_SUBTYPE = "Hours") OR (EA_TYPE = "Labor" AND EA_SUBTYPE = " ") ) Craig Buchanan July 24, 2006 at 06:46 You may need Suggested Solutions Title # Comments Views Activity Converting table to different orientation in MSAccess 5 34 54d Crystal reports Cross Tab - Display dates even if no data returned. 20 43 Not endorsed by or affiliated with SAP Register| Login Follow BOB on Twitter! (Opens a new window) Index|About Sponsors| Contact Us| Calendar| FAQ| Rules and Guidelines| Privacy Policy| Search

You will have to add a reference to the main form, something like this: where x.req_id = [YOUR_MAIN_FORM_NAME]![REPTEXT.req_id] And until the syntax is correct, you might consider: where x.req_id = A_KNOWN_VALUE_FOR_THE thx! With the Payment table removed from the main query, create a SQL Expression named ‘SumOfPayment' and enter this text: ( SELECT Sum(payment) FROM Payment -validate that this linkage is correct INNER navigate here Is that right? 0 Message Author Comment by:cheyanne0402772008-11-18 Comment Utility Permalink(# a22987099) I took out the last inner join, so I could get it all in and show you the

I'm hoping some solution can be reached within Crystal Reports XI itself. The resulting SQL is added to the report's SELECT clause. If I was going to rewrite the entire database, I would add a "TotalPayment" field to MainQueryTable1, and maintain it using triggers for whenever payments are added or removed from MainQueryTable2. James 0 Featured Post What Security Threats Are You Missing?

Suite 1 2751 Hennepin Avenue South Minneapolis, MN 55408 USA Email infoATcognizaDOTcom Telephone +1.612.293.7363 Advertisements November 2005 S M T W T F S « Oct Apr » 12345 6789101112 SOrry IP Logged BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2460 Posted: 30 Aug 2007 at 5:58pm Well, that is what I meant. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. This has better chance of supporting it.