Hi Guys, I found an issue with CFReport Builder I did a quick google and found others having the same issue but no luck on how to fix it.
Does anyone know? Its a reallllly basic query that I want to view as a report..Below is the component and calling page if you would like to see the code. I have patched the servers. CALLING PAGE <cfinvoke component="report" method="ReportQuery" returnvariable="myQuery"> <cfreport template="rpt_candidatesbybranch.cfr" format="flashpaper" query="MyQuery"/> COMPONENT <cfcomponent> <cffunction name="ReportQuery" returntype="query" output="no" access="public"> <cfset var MyQuery=""> <!--- rpt_candidatesbybranch.cfr expects the query passed into it to contain the following column names: Field: FirstName DataType: String Field: LastName DataType: String Field: Deleted DataType: Boolean ---> <cfquery name="MyQuery" datasource="AXM_AU_VAW_MASTER_D02_4"> SELECT FirstName, LastName, Deleted FROM dbo.tbl_candidate </cfquery> <cfreturn MyQuery> </cffunction> </cfcomponent> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---