Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal Reports 2013 -sql expression
I did remove the [] did not seem to make a difference. I resolved this by getting rid of sql expressions and using a command instead. Thanks- patsylipp
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Crystal Reports 2013 -sql expression
I have never used sql expression in crystal here is my code (SELECT SUM(LABOR_HOURS) FROM WO_TASK WHERE WO_TASK.WOO_AUTO_KEY=WO_OPERATION.WOO_AUTO_KEY and not(WO_TASK.SYSUR_AUTO_KEY in [125,126,127,129,130,132,131,249])) I am getting a missing expression error when I try and save it. PS this...- patsylipp
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
