Unless you are strictly required to use version 4.0.1 for legacy system compatibility, Jaspersoft highly recommends downloading Jaspersoft Studio (the Eclipse-based successor). It is actively maintained and works better with modern Java versions.
: Improved CSV data source functionality and the introduction of experimental support for JSON data sources . SQL Enhancements : New functions ( BETWEENcap B cap E cap T cap W cap E cap E cap N ) were added for dynamic SQL queries using the $X{} syntax.
Here is the breakdown of where to find it and a useful guide to get you started.
404 Not Found.