http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-26T06:07:12 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#68404 CFMX7 + CR9. The Formula parameter works on database fields, as well as true Crystal formulas. If you have this formula: CustomerID, the syntax becomes:<br />...formula="{@CustomerID} = '#request.CustomerID#';"...<br />Note the mandatory curly braces as well as the @ symbol!<br />Formula also works on database fields as defined in Crystal:<br />...formula="{CustomerTable.CustId} = '#request.CustomerID#';"<br /><br />Lastly, it is not possible to use CF variables between <cfreport..> and </cfreport>; the variable is not evaluated but the complete syntax is passed to Crystal (which then assumes the pound signs denote a date). MU 0 0 2007-06-14T06:43:12 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#40947 There is a tech note:<br />"Flash Player 8 issue with cfdocument and cfreport"<br />at<br />http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=a8a77279 ASandstrom 0 0 2005-10-17T11:10:15 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#36132 It sounds like some sort of character set and/or encoding issue. <br><br>One solution might be to use the Arial-Unicode MS font, which contains characters required for most languages. If your report supports multiple languages, consider using this font.<br><br>You might also consider reading the Managing Fonts topic in the Report Builder online Help.<br><br>Another option is to post your question to the online forums: http://webforums.macromedia.com/coldfusion jrunrandy 1 0 2005-06-29T13:46:33 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#34409 What about spanish characters for flashpaper format?, they doesn't show up right...<br /><br />Example:<br /><br />é shows like È Rodrigo Alarcon 0 0 2005-06-04T00:35:58 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#33490 The path to the report definition file (specified in the template attribute) is relative to the calling cfm, not the webroot. Frickie 0 0 2005-05-17T09:16:41 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#30660 The only thing that would cause this to fail is if the storedproc happened to return multiple result sets. The documentation should have mentioned this fact and I have entered it into our bug tracker as bug numer 60000.<br><br>Also, please remember that LiveDocs is intended for documentation-related comments and that you will get better and quicker answers by posting questions like this to the online forums: http://webforums.macromedia.com/coldfusion or click the Forums link on any CFMX 7 LiveDocs page. jrunrandy 1 1 2005-03-30T14:21:15 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000323.htm#30314 The QUERY attribute does not work when executing stored procedures. We use Sybase 12.0 and have to use stored procs...but the CFREPORT QUERY attribute won't recognize the fieldnames returned...yet you can CFDUMP, CFOUTPUT, or CFLOOP through the query to see they DO EXIST!<br /><br />Is this NEW report feature THIS buggy already? shaunstl 0 0 2005-03-23T12:20:39