<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ rootadoname | tolower() ] failed in the evaluation of <p> [company_name] JDBC Driver for [service] ???????[service] ???????????????????????????????????????????????????????SQL ????????[datasource] ??????????????JDBC ?????????[datasource] ?????JReport Designer ?[datasource] ??????????????????? </p> <h2>[service] [datatype] ???</h2> <ol> <li>Edit C:\JReport\Designer\bin\setenv.bat to add the location of the JAR file to the ADDCLASSPATH variable: <pre class="brush:vb"> ... set ADDCLASSPATH=%JAVAHOME%\lib\\tools.jar;C:\Program Files\\[company_name]\\[company_name] JDBC Driver for [service] 2016\lib\\[company_name|tolower].jdbc.[rootadoname|tolower].jar; ... </pre> </li> <li>Create a new data source by clicking File <i class="fa fa-angle-double-right"></i> New <i class="fa fa-angle-double-right"></i> Data Source.</li> <li>In the resulting dialog, create a name for the data source ([company_name] JDBC Driver for [service]), select JDBC, and click OK.</li> <li>In the Get JDBC Connection Information dialog you will configure your connection to the JDBC driver: <ul> <li><b>Driver</b>:Be sure that the Driver box is checked and fill in the name of the class for the driver: <code>[company_name|tolower].jdbc.[rootadoname|tolower].[rootadoname]Driver</code></li> <li><b>URL</b>:Enter the JDBC URL.This starts with <i>jdbc:[rootadoname|tolower]:</i> and is followed by a semicolon-separated list of connection properties. [extraconnectionnotesjdbc|def('[extraconnectionnotes|def("")]')] <h4>???????????????</h4> <p>For assistance in constructing the JDBC URL, use the connection string designer built into the [service] JDBC Driver.Either double-click the JAR file or execute the jar file from the command-line.</p> <code> java -jar cdata.jdbc.[rootadoname|tolower].jar </code> <p> Fill in the connection properties and copy the connection string to the clipboard. </p> <img src="[x|UrlRootAbs]/kb/articles/jdbc-url-builder-0.png" title="Using the built-in connection string designer to generate a JDBC URL (Salesforce is shown.)"/> <p> When you configure the JDBC URL, you may also want to set the Max Rows connection property.This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. </p> <p>Below is a typical JDBC URL:</p> <code>jdbc:[rootadoname|tolower]:[extraconnectionprops|def('')]. The error was: The attribute does not exist. This formatter cannot be called with nonexistent attributes.<br><b>URL</b>: /jp/kb/tech/sqlite-jdbc-jreport-designer.rst