cfreport

[richy2424]

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>

[Richard McKenna]

Looks like your mixing the syntax for crystal reports and coldfusion report
builder. See the tag documentation here.

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=part_cfm.htm

--
Kind Regards,

Richard McKenna

"richy2424" <webfor...@macromedia.com> wrote in message
news:e07e8i$r7r$1...@forums.macromedia.com...

[Richard McKenna]

Hi, looks like you mixing up the Crystal Reports syntax and the ColdFusion
Report Builder syntax for the cfreport tag, Hope this helps, see below.

<!--- Syntax 1 - Use this syntax with the ColdFusion Report Builder. --->
<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>

OR

<!--- Syntax 2 - Use this syntax with Crystal Reports. --->
<cfreport
report = "report_path"
dataSource = "ds_name"
type = "type"
timeout = "number of seconds"
orderBy = "result_order"
username = "username"
password = "password"
formula = "formula">
</cfreport>

--
Kind Regards,

Richard McKenna

"richy2424" <webfor...@macromedia.com> wrote in message
news:e07e8i$r7r$1...@forums.macromedia.com...

[macca242424]

Hi whats is the difference between the two reports, i have created the report in coldfusion report builder, does the testing server need to support this report?

[richy2424]

[Richard McKenna]

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" <webfor...@macromedia.com> wrote in message
news:e07e8i$r7r$1...@forums.macromedia.com...

[richy2424]

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?

[pravin]

Hi anybody help to sort out the ERROR :"attribute report is required for tag cfreport".

i am using the cfreport tag like below

<cfreport format="PDF" template="LatterXXReport.cfr" overwrite = "yes" query="getdata"/>

LetterXXReport.cfr is placed in the current directory.

please help me on this.

Thanks in Advance.

Error is pointing @ line 4

2: select top 10 * from clientdetailview
3: </cfquery>
4: <cfreport format="PDF" template="LatterReport.cfr" overwrite = "yes" query="getdata"/>