Sage 100

Is there a way to open and edit a crystal report in SQL view? Is there and easier way to create an unequal join. Used to be easy in the old Crystal but it's not working when I choose != in the join options I posted this in the wrong spot so I am reposting. Sorry

Pretty sure you can't simply edit SQL in Crystal (although it's viewable from the Database menu) now like you could a few versions back or so, unless your report is based on a SQL Query / Command Object. But make sure the fields you're linking as ""not equal"" are the same field types (e.g., string to string, numeric to numeric).

The != join should work. When you go to Database / Show SQL Query you should the actual SQL statement using <> (which is the ProvideX ODBC syntax). But are you perhaps trying to make the Company Code or Company Name appear on the report? If so and assuming you are running off the Custom Reports menu, instead of joining another table, you can just create a formula called @CompanyCode with just a """" in it and @CompanyName with just a """" in it. If using Basic Syntax it would be formula =

Thanks. Actually for some reason != is still not working but I solved my problem saying Balance <> 0 in AR_Open Invoice and so it only shows me paid invoices, which is what I wanted. But now I ran into another issue.