Working with Coldfusion Report Builder

Do not save reports or custom work in the web folder. ../custom/ is what I use which would be in the gisweb folder.

Code in CRB1.cfm:

<cfquery name="CFReportDataQuery" datasource="#MyODBC#">

            #PreserveSingleQuotes(SESSION.CustomQuery)#

</cfquery>

<cfreport template="CRB1.cfr" format="flashpaper" query="#CFReportDataQuery#"/>