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.
Edited by: Tony Vincent on Sep 18, 2008 4:48 PM
Edited by: Tony Vincent on Sep 18, 2008 4:49 PM
Jason Long replied
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'
WHERE Discovered_Software_Product_List.Product_Name LIKE 'NOD32 antivirus system' , just to stick with convention.