Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Going mad can I get some help please.

I have installed Crystal Reports on my computer and now im trying to get my head round it but I have hit a wall.

I cant seem to be able to get the below statement to work does it not like any sql statements?

FROM Computer_List_All

WHERE Computer_List_All.Asset_Tag NOT IN
     (SELECT Discovered_Software_Product_List.Computer_Asset_Tag 

FROM Discovered_Software_Product_List

     WHERE Product_Name LIKE 'NOD32 antivirus system')

ORDER BY Computer_List_All.Asset_Tag

Thanks in advance for any help.

Tony

Edited by: Tony Vincent on Sep 18, 2008 4:48 PM

Edited by: Tony Vincent on Sep 18, 2008 4:49 PM

Former Member
Former Member replied

Tony,

CR loves SQL. It's just a crappy place to write and test SQL.

If you can get the SQL to run in the native application (SQL Management Studio for MS SQL Server) you should be able to paste it directly into a SQL Command in CR and have it work just fine.

Just make sure you are using the correct driver for your database.

Note: You may want to change WHERE Product_Name LIKE 'NOD32 antivirus system'

to

WHERE Discovered_Software_Product_List.Product_Name LIKE 'NOD32 antivirus system' , just to stick with convention.

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question