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

Crystal Reports Error In Compiling Sql Expression

Please support the forum! Features A database [Oracle|SQL Server|Sybase] scalar function may be used in a SQL Expression field. the VALUES for each reference should be different, and your syntax is wrong (as I stated earlier). 0 Message Author Comment by:cheyanne0402772008-11-18 Comment Utility Permalink(# a22987590) So it should be: 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) http://ogdomains.com/crystal-reports/crystal-reports-515.php

Pinging is currently not allowed. Access project and SQL server 2000. Not sure if i'm typing it correctly or if CR uses different syntax. There's also very little documentation on them, as a result. https://archive.sap.com/discussions/thread/1822727

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 The contents of a SQL Expression field is any valid SQL statement that returns a scalar value. iOS UI/UX Mobile Adobe Creative Suite CS Android Advertise Here 695 members asked questions and received personalized solutions in the past 7 days.

Post your question and get tips & solutions from a community of 418,854 IT Pros & Developers. To report only some fields, you choose the database, and the table you want to report (click on the Datatabase Fields item in the Field Explorer panel to open a wizard Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We This has better chance of supporting it.

Some components may not be visible. Join Now For immediate help use Live now! No. May 15 '07 #3 reply Expert 2.5K+ P: 3,235 Motoma In the Field Explorer, Right-click on Database Fields, and select Add/Remove Database.

Works fine now, 10x !!! All Rights Reserved. This expression works in all CR versions: ( SELECT Min ( ONDATE )
FROM GM6.dbo.CAL
WHERE ACCOUNTNO = Contact1.AccountNo ) It is curious that the alias of the CAL The main limitation is that it can only return a single value.

Post your code, including database type, if you'd like. http://kenhamady.com/cru/archives/2430 Join UsClose 418,854 Members | 815 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics > microsoft sql server Leave a Reply Cancel reply Your email address will not be published. However, this is the error I keep getting when I check the formula: Error in compiling SQL Expression : Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "REPTEXT.req_id" could

But i got this error. click site So the following expression also works in all versions: (
/* some words accountno and some more words */
SELECT Min ( CAL.ONDATE )
FROM GM6.dbo.CAL CAL
To accomplish this, PAT_ENC_HSP is omitted from the FROM clause in the query. Registration on or use of this site constitutes acceptance of our Privacy Policy.

Sorry it wasn't better news. So i connected to the database and inside SQL expressions Field i wrote the following query, SELECT name,address,age FROM t1 Is this correct. http://msdn.microsoft.com/en-us/library/ms226240%28v=vs.90%29.aspx http://mindstick.com/Articles/eb554c35-0236-49ca-a7ce-c2eb573e27e8/?SqlExpression%20Field%20in%20Crystal%20Report Jeff W July 24, 2013 at 14:53 8 years later and this article is still helping people. http://ogdomains.com/crystal-reports/crystal-reports-error-229.php Sounds like a typical SQL syntax error.

For example:
SELECT PAT_NAME,HOSP_ADMSN_TIME,HOSP_DISCH_TIME,
--SQL Expression
(
SELECT MAX(HOSP_DISCH_TIME)
FROM PAT_ENC_HSP PAT_ENC_HSP2
WHERE PAT_ENC_HSP2.PAT_ID=PAT_ENC_HSP.PAT_ID
AND PAT_ENC_HSP2.PAT_ENC_CSN_ID < PAT_ENC_HSP.PAT_ENC_CSN_ID
)
--/SQL Expression
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

Well, at least it makes more sense now.... You will be able to use parameters and the scalar query in the SELECT clause. What you see as available may not be what I see..So, while SAP can support the feature as a whole, they can't necessarily provide syntax support, nor guarantee effectiveness. I have done till here.

How do I get the id in the subquery to equal the reptext.req_id that is in the main query at the very bottom of the statement? But i got this error. from tablename where age>20;) was correct. More about the author But if I then try to edit the SQL expression or even check it, I get the error above.

http://mindstick.com/Articles/eb554c35-0236-49ca-a7ce-c2eb573e27e8/?SqlExpression%20Field%20in%20Crystal%20Report Thanks !! I wrote the query SELECT name,address,age FROM t1 where age>20 ,but got the error Error in compiling SQL Expression Database Connector Error:'42000:[Microsoft][ODBC SQL Server Driver][SQL Server][Incorrect sybtax near the keyword 'select'.[Database Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to Post Forum Index -> Building Reports -> Crystal Reports The bug only affects SQL Expressions that contain a correlated sub-query.

Yes. The resulting SQL is added to the report's SELECT clause. Please support the forum! Case statements may be used in SQL Expression fields.

If I delete that word or misspell it, I get the original error. Promoted by Recorded Future Enhance your security with threat intelligence from the web. I keep getting an error on the WHERE clause of the subquery, saying that the column prefix ‘MainQueryTable' does not match with a table name or alias name in the query. Either the calculation of the total payment on the account takes place after the record selection criteria screens out the most of the payments on the account, resulting in the wrong