i am using cf mx 7. I have done some reading about this and not sure about the templae attribute. I see some examples from live document with format PDF and wonder what is myreport.cfr?
<cfreport template="myreport.cfr" style="mystyle.css" format="PDF"> <cfreportParam subreport="subreport1" style="subreport1-style.css">
<cfreportParam subreport="subreport2" style="subreport2-style.css"> </cfreport>
I created the Report.xlsx at the same location where i have cfm pages with the syntax below. Either one below still give me an error
<CFREPORT format="Excel" template="Report.xlsx" query="#myquery#"/>
<CFREPORT format="Excel" template="#GetDirectoryFromPath(GetTemplatePath())#/Report.xlsx"
any one got any advice?
Not sure if this is correct, when i go through the documentation of CFREPORT. Looks like you need to give the extn as ".cfr" and not .xlsx when using report Builder. Please check it.