Creating Custom Reports

Select Custom Type

Select ODBC/View

Setting below depend on where you custom reports are located. In the example below there is a folder named Custom in the GISWEB folder and that is where we are storing our custom coded reports.

Variables given to work with:

SESSION.CUSTOMQUERY

SESSION.SQLSYNTAX

SESSION.SQLWHERESYNTAX

I this myreport.cfm example the code as follows (simple coldfusion page):

<strong>SQL w/WHERE:</strong> <CFOUTPUT>#SESSION.CustomQuery#</CFOUTPUT><BR>

<strong>SQL:</strong> <CFOUTPUT>#SESSION.SQLSyntax#</CFOUTPUT><BR>

<strong>Where Statement:</strong> <CFOUTPUT>#SESSION.SQLWHERESYNTAX#</CFOUTPUT><BR>

This is the final result:

From there you can use those variables to create your own reports in any form you like.