cfreport
in [Advanced Techniques]
|
Prev: Connecting to Excel
Next: ASCII to UTF-8 converter?
From: Richard McKenna on 29 Mar 2006 02:52 Crystal reports is some windows sofware used to generate reports similar to CF Report Builder if v9 or v10 of crystal reports is installed on the windows system then you can use crystal reports to build your reports using the cfreport tag if you dont have crystal reports you can only use CF Report Builder so the correct syntax should be used <cfreport template = "report definition filename" format = "PDF or FlashPaper" or "excel" name = "cf variable" filename = "output filename" query = "query variable" overwrite = "yes" or "no" encryption = "128-bit" or "40-bit" or "none" ownerpassword = "password" userpassword = "password" permissions = "permission list" > cfreportparam tags [optional] </cfreport> Just by looking at your code you should be using the template attribute not the report attribute like so <cfreport query="list_labels" template="http://www.dpsguide.com.au/Cart/avery_5160.cfr" format="pdf"> </cfreport> I've not had much experience with reports so I might be wrong about some of this. -- Kind Regards, Richard McKenna "richy2424" <webforumsuser(a)macromedia.com> wrote in message news:e07e8i$r7r$1(a)forums.macromedia.com... > Hi i am using cfreport to generate a pdf, this works fine on my local > machine > but when uploaded to the server i get this error below, > > any ideas why this is, or what i need to do to correct this > > many thanks > > Attribute validation error for tag CFREPORT. > The tag does not allow the attribute(s) FORMAT,QUERY. The valid > attribute(s) > are DATASOURCE,FORMULA,ORDERBY,PASSWORD,REPORT,TIMEOUT,TYPE,USERNAME. > > The error occurred in E:\Inetpub\vs111061\Cart\act_create_labels.cfm: line > 69 > > 67 : > 68 : <!--- ### CREATE AND DISPLAY LABEL REPORT ### ---> > 69 : <cfreport query="list_labels" > report="http://www.dpsguide.com.au/Cart/avery_5160.cfr" > format="pdf"></cfreport> > 70 : </cfif> > > > >
From: richy2424 on 29 Mar 2006 17:15
ok i am using this code <cfreport query="list_labels" template="reports/avery_5160.cfr" format="pdf"></cfreport> this works fine on my local machine, but when i upload it i get this error Attribute validation error for tag CFREPORT. The tag does not allow the attribute(s) FORMAT,QUERY. The valid attribute(s) are DATASOURCE,FORMULA,ORDERBY,PASSWORD,REPORT,TIMEOUT,TYPE,USERNAME. why would i get this error do i have to install report builder on my testing server? |