subject:"CFREPORT"

Welcome to part three of my asynchronous thread, JVM out-of-memory 
discussion.

To recap:  we have a process that creates ~1300, seven to ten page pdf 
form letters.  This is done asynchronously using the cfthread... tag 
so that each thread can create one letter with associated database 
transactions and disappear.  There was originally a problem with the 
threads - that once opened, they never closed.  This appears to have 
been resolved yesterday by updating the ColdFusion server from 8.0.0 to 
8.0.1.

Now the issue is that if the process is allowed to run all at once, all 
the JVM memory is used up and the system starts throwing out-of-memory 
errors.  The idea I am working with, as suggested in the previous 
discussion, is to throttle the process so that there are pauses.  This 
should allow time for memory to be cleared between batches.

The trouble is that this is not happening.  Even with the pauses the 
memory does not seem to be released until the entire process runs.  My 
theory is that the root thread spawning the child cfthreads is holding 
onto the memory objects, even the ones created in the child threads, 
until it is finished.  So it can not be cleared until the main thread 
finishes.

Is this logical?  How autonomous are variables created in spawned 
threads?  Is the default to create them in a 'thread' scope that is 
dropped when the child thread is done or in the calling parent thread?  
Is this somehow controllable?  Can I declare the variables to be local 
to the thread, if so how?  Does the 'Var' command work in threads the 
same as it does in functions to make a variable local?

On a related note, the main memory hog is the cfreport... tag.  If I 
comment out this tag, the memory usage only makes a small bump when the 
test code is run.  The question is that we are using the 'filename' 
property of the cfreport... tag so there is no identified variable to 
work with here is there?  What should be happening with whatever memory 
ColdFusion used to create the PDF file described in the cfreport... 
call after it is done with it?

  !--- BUILD REPORT ---
  cfreport template=ren.cfr format=pdf overwrite=yes
filename=#vOutputFilePath# 
cfreportparam name=pFirmNo 
value=#ResultFirms[firmno][threadIndex]#
cfreportparam name=pIssueDate value=#DateFormat(pIssueDate, 
'mm/dd/yy')#
cfreportparam name=pRenewalId value=#vRenewalSeq#
  /cfreport


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307659
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfthreads, scopes, cfreport and JVM memory.

Yes there is a thread local scope and one can use the 'Var' keyword, but 
apparently it is somewhat unnecessary.

So this just leaves me trying to control the memory used by the 
cfreport... tag.  Instead of writing directly to a file I am putting 
the cfreport... output into a variable and then attempting to write 
that file out.  This seems to be working for the memory now, the memory 
is released and cleaned up between each batch during the sleep period to 
the throttle the report generation.

But the files are not actually being written!  Should this work?

   BUILD REPORT ---
  cfreport template=ren.cfr format=pdf overwrite=yes
name=vReportLetter 
cfreportparam name=pFirmNo 
value=#ResultFirms[firmno][threadIndex]#
cfreportparam name=pIssueDate value=#DateFormat(pIssueDate, 
'mm/dd/yy')#
cfreportparam name=pRenewalId value=#vRenewalSeq#
  /cfreport
   
   cfset arrayAppend(variables.pdfFiles,vOutputFilePath)
   cfpdf action=write source=#vReportLetter# 
destination=#vOutputFilePath# overwrite=yes

Or do I just use a cffile action=write... tag.  Isn't that just for 
text files or can I write out binary output like a PDF file?

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307668
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFReport and CFPDF

Can the CFPDF tag write a PDF variable created with the CFReport tag?

I.E. Should this not work?

  cfreport template=ren.cfr format=pdf overwrite=yes 
name=vReportLetter 
cfreportparam name=pFirmNo 
value=#ResultFirms[firmno][threadIndex]#
cfreportparam name=pIssueDate value=#DateFormat(pIssueDate, 
'mm/dd/yy')#
cfreportparam name=pRenewalId value=#vRenewalSeq#
  /cfreport
  
  cfpdf action=write source=#vReportLetter# 
destination=#vOutputFilePath# overwrite=yes

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307675
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfthreads, scopes, cfreport and JVM memory.

2008-06-18 Thread Mark Kruger

Ian,

First... I would var any variables used inside the thread.  Second, you
should be able to write this file using cffile - but I'm not sure why your
cfpdf action is not working. But you want to try this code outside your
cfthread to see how it behaves - cfthread obscures error information and
makes it difficult to troubleshoot :)

-mark



Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 18, 2008 10:45 AM
To: CF-Talk
Subject: Re: cfthreads, scopes, cfreport and JVM memory.

Yes there is a thread local scope and one can use the 'Var' keyword, but
apparently it is somewhat unnecessary.

So this just leaves me trying to control the memory used by the
cfreport... tag.  Instead of writing directly to a file I am putting the
cfreport... output into a variable and then attempting to write that file
out.  This seems to be working for the memory now, the memory is released
and cleaned up between each batch during the sleep period to the throttle
the report generation.

But the files are not actually being written!  Should this work?

   BUILD REPORT ---
  cfreport template=ren.cfr format=pdf overwrite=yes
name=vReportLetter 
cfreportparam name=pFirmNo 
value=#ResultFirms[firmno][threadIndex]#
cfreportparam name=pIssueDate value=#DateFormat(pIssueDate,
'mm/dd/yy')#
cfreportparam name=pRenewalId value=#vRenewalSeq#
  /cfreport
   
   cfset arrayAppend(variables.pdfFiles,vOutputFilePath)
   cfpdf action=write source=#vReportLetter# 
destination=#vOutputFilePath# overwrite=yes

Or do I just use a cffile action=write... tag.  Isn't that just for text
files or can I write out binary output like a PDF file?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307677
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfthreads, scopes, cfreport and JVM memory.

Mark Kruger wrote:
 Ian,

 First... I would var any variables used inside the thread.  Second, you
 should be able to write this file using cffile - but I'm not sure why your
 cfpdf action is not working. But you want to try this code outside your
 cfthread to see how it behaves - cfthread obscures error information and
 makes it difficult to troubleshoot :)

 -mark
   

Yeah, that finally tracked down the problem to incorrect pound signs in 
the cfpdf... tag.  The source parameter just needs that string of the 
the PDF variable not to process it as a variable.  That is one of the 
inconsistencies of CF that trips me up most often.  When to just use the 
string of the variable and when not to in tag parameters.

Now I am struggling with how threads and memory usage work together.  I 
think I may be bouncing around a bug, at least some type of unexpected 
(for me at least) behavior.  So far it seems to center around writing 
PDF content to files.  When I straightened out the cfpdf... tag, so 
that it works correctly, I am again experiencing the phenomenon where 
JVM memory usage will just climb and climb with each iteration of PDF 
generation until the master thread is finished or the memory is full and 
CF starts throwing exceptions.  The same thing happened when the 
cfreport... tag directly wrote the PDF content it generates to a file.

The whole point of this is the create ~1300 multiple page pdf form 
letters that we know will not all fit into memory at once.  How can we 
control this so that the process can be allowed to finish?




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307680
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfthreads, scopes, cfreport and JVM memory.

2008-06-18 Thread Antony Sideropoulos

Hi Ian

You say that you are throttling the process to create a pause between
batches.

Is your throttle part of the function that creates the threads? (Given that
you say that memory isn't released until this function completes, this
probably wouldn't help.)

Look at things another way - if cfthread didn't exist, you would probably be
using cfschedule to throttle the process - ie create PDFs 1 - 20, then 21 -
40, and so on.

Can you cfschedule your function (that creates all 1300 threads) in batches,
so that this function has a chance to complete (and theoretically release
the memory that it's threads consume)? Still use threads within this
function, but if you only process 20 threads at a time, this might help.

Antony


On Thu, Jun 19, 2008 at 5:04 AM, Ian Skinner [EMAIL PROTECTED] wrote:



 The whole point of this is the create ~1300 multiple page pdf form
 letters that we know will not all fit into memory at once.  How can we
 control this so that the process can be allowed to finish?




 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307699
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: calling cfreport from within java-instantiated cfc

2007-12-14 Thread Craig Buckley

 I have a cfinput, type=button that has a onclick=callreport().  
 Function callreport instantiates a cfc called metricreport.cfc.  
 Metricreport.cfc produces either a csv file or a cfreporter output.  
 The creation of the csv file works fine using cffile tags in 
 metricreport.cfc.  The cfreport does not seem to want to run from 
 within the cfc called through a javascript function.  The exact same 
 cfreport tag works fine if I call it directly from a .cfm 
 template
 
 2 questions:
 
 Firstly, what is stopping me from using cfreport in my 
 java-instantiated cfc?
 
 Secondly (and unrelated to the description above), how do I get this 
 cfc to display a simple query-driven html table?
 
 Thanks,
 
 Craig
 
Yes, the output is set to true. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294764
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

calling cfreport from within java-instantiated cfc

2007-12-13 Thread Craig Buckley

I have a cfinput, type=button that has a onclick=callreport().  
Function callreport instantiates a cfc called metricreport.cfc.  
Metricreport.cfc produces either a csv file or a cfreporter output.  The 
creation of the csv file works fine using cffile tags in metricreport.cfc.  The 
cfreport does not seem to want to run from within the cfc called through a 
javascript function.  The exact same cfreport tag works fine if I call it 
directly from a .cfm template

2 questions:

Firstly, what is stopping me from using cfreport in my java-instantiated cfc?

Secondly (and unrelated to the description above), how do I get this cfc to 
display a simple query-driven html table?

Thanks,

Craig



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294722
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: calling cfreport from within java-instantiated cfc

2007-12-13 Thread Kris Jones

Make sure that the output attribute in your cfcomponent tag is set to true?

 I have a cfinput, type=button that has a onclick=callreport().
 Function callreport instantiates a cfc called metricreport.cfc.  
 Metricreport.cfc produces either a csv file or a cfreporter output.  The 
 creation of the csv file works fine using cffile tags in metricreport.cfc.  
 The cfreport does not seem to want to run from within the cfc called 
 through a javascript function.  The exact same cfreport tag works fine if I 
 call it directly from a .cfm template

 2 questions:
 Firstly, what is stopping me from using cfreport in my java-instantiated 
 cfc?
 Secondly (and unrelated to the description above), how do I get this cfc to 
 display a simple query-driven html table?

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How good is cfreport?

2007-11-27 Thread Sean Corfield

On Nov 26, 2007 2:28 PM, Billy Cox [EMAIL PROTECTED] wrote:
 Does anyone have experience with outputting Crystal Reports using
 ColdFusion? We have a number of existing Crystal Reports that I would like
 to leverage if possible. I am also making a purchase decision between Blue
 Dragon Server JX and CF Server 8.0, so I want to know whether CF Server
 (cfreport tag) is worth the extra bucks.

You should be able to do pretty much anything that Crystal Reports
supports with the built-in cfreport and the (free) Report Builder.
Talk to Dean Harmon at Adobe if you have specific questions (since he
wrote most of the reporting subsystem).
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293853
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How good is cfreport?

2007-11-27 Thread Kris Jones

 You should be able to do pretty much anything that Crystal Reports
 supports with the built-in cfreport and the (free) Report Builder.
 Talk to Dean Harmon at Adobe if you have specific questions (since he
 wrote most of the reporting subsystem).

Sorry, but I'm not convinced of this. I've written some pretty complex
Crystal Reports way back when, and after working with the Report
Builder for a year +, can say that it isn't quite there yet. Good
tool, no doubt, but still buggy, and doesn't support some things that
I could use. (How about being able to pass in multiple queries to the
report.) The IDE is very mouse-unfriendly, and I've seen instances of
objects getting stuck in invisible places (how does an object get
set to a negative y axis inside of a section?). Granted, I'm not on
CF8 yet either (we're on 7.02) -- hopefully there's been huge progress
made since?

Cheers,
Kris

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293866
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How good is cfreport?

2007-11-27 Thread Cutter (CFRelated)

Not positive on this, but I believe the multiple query thing was handled 
with CF 8...

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Kris Jones wrote:
 You should be able to do pretty much anything that Crystal Reports
 supports with the built-in cfreport and the (free) Report Builder.
 Talk to Dean Harmon at Adobe if you have specific questions (since he
 wrote most of the reporting subsystem).
 
 Sorry, but I'm not convinced of this. I've written some pretty complex
 Crystal Reports way back when, and after working with the Report
 Builder for a year +, can say that it isn't quite there yet. Good
 tool, no doubt, but still buggy, and doesn't support some things that
 I could use. (How about being able to pass in multiple queries to the
 report.) The IDE is very mouse-unfriendly, and I've seen instances of
 objects getting stuck in invisible places (how does an object get
 set to a negative y axis inside of a section?). Granted, I'm not on
 CF8 yet either (we're on 7.02) -- hopefully there's been huge progress
 made since?
 
 Cheers,
 Kris
 
 

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293869
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How good is cfreport?

2007-11-27 Thread Jim Pennington

I've been using Crystal Reports viewed via the web for sometime. As I am
using an IIS server I've been using asp pages and it works great. I am using
a program called recrystallize (www.recrystallize.com) which is a wizard
that processes your rpt file and you need to provide the database connection
information, parameters and how you want the report to be displayed. Once
the process is completed it generates the ASP pages which you place on your
web server. I've been using it for years and it's a great tool.

Jim Pennington

On Nov 27, 2007 10:17 AM, Cutter (CFRelated) 
[EMAIL PROTECTED] wrote:

 Not positive on this, but I believe the multiple query thing was handled
 with CF 8...

 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer
 _
 http://blog.cutterscrossing.com

 Kris Jones wrote:
  You should be able to do pretty much anything that Crystal Reports
  supports with the built-in cfreport and the (free) Report Builder.
  Talk to Dean Harmon at Adobe if you have specific questions (since he
  wrote most of the reporting subsystem).
 
  Sorry, but I'm not convinced of this. I've written some pretty complex
  Crystal Reports way back when, and after working with the Report
  Builder for a year +, can say that it isn't quite there yet. Good
  tool, no doubt, but still buggy, and doesn't support some things that
  I could use. (How about being able to pass in multiple queries to the
  report.) The IDE is very mouse-unfriendly, and I've seen instances of
  objects getting stuck in invisible places (how does an object get
  set to a negative y axis inside of a section?). Granted, I'm not on
  CF8 yet either (we're on 7.02) -- hopefully there's been huge progress
  made since?
 
  Cheers,
  Kris
 
 

 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293877
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: How good is cfreport?

2007-11-27 Thread Billy Cox

Thanks for the input. It is very helpful.

-Original Message-
From: Jim Pennington [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 27, 2007 10:46 AM
To: CF-Talk
Subject: Re: How good is cfreport?

I've been using Crystal Reports viewed via the web for sometime. As I am
using an IIS server I've been using asp pages and it works great. I am using
a program called recrystallize (www.recrystallize.com) which is a wizard
that processes your rpt file and you need to provide the database connection
information, parameters and how you want the report to be displayed. Once
the process is completed it generates the ASP pages which you place on your
web server. I've been using it for years and it's a great tool.

Jim Pennington

On Nov 27, 2007 10:17 AM, Cutter (CFRelated) 
[EMAIL PROTECTED] wrote:

 Not positive on this, but I believe the multiple query thing was 
 handled with CF 8...

 Steve Cutter Blades
 Adobe Certified Professional
 Advanced Macromedia ColdFusion MX 7 Developer 
 _ http://blog.cutterscrossing.com

 Kris Jones wrote:
  You should be able to do pretty much anything that Crystal Reports 
  supports with the built-in cfreport and the (free) Report 
  Builder. Talk to Dean Harmon at Adobe if you have specific 
  questions (since he wrote most of the reporting subsystem).

  Sorry, but I'm not convinced of this. I've written some pretty 
  complex Crystal Reports way back when, and after working with the 
  Report Builder for a year +, can say that it isn't quite there yet. 
  Good tool, no doubt, but still buggy, and doesn't support some 
  things that I could use. (How about being able to pass in multiple 
  queries to the
  report.) The IDE is very mouse-unfriendly, and I've seen instances of
  objects getting stuck in invisible places (how does an object get
  set to a negative y axis inside of a section?). Granted, I'm not on
  CF8 yet either (we're on 7.02) -- hopefully there's been huge progress
  made since?

  Cheers,
  Kris

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293899
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

How good is cfreport?

2007-11-26 Thread Billy Cox

Does anyone have experience with outputting Crystal Reports using
ColdFusion? We have a number of existing Crystal Reports that I would like
to leverage if possible. I am also making a purchase decision between Blue
Dragon Server JX and CF Server 8.0, so I want to know whether CF Server
(cfreport tag) is worth the extra bucks.
 
 
Thanks,
 
Billy Cox
Old World Spices
[EMAIL PROTECTED]
 
 
 




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293837
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How good is cfreport?

2007-11-26 Thread David Mineer

I have been using crystal reports for years, but not with cfreport.  I
use an asp page to render the Crystal Report in a .pdf format.  I pass
the variables I need from coldfusion to the .asp page, which then
calls the Crystal report, and exports it to .pdf, then displays the
..pdf to the user.

More recently I have written code to use .net to do ths.  It should be
easy with .net, but it aint for me, although it does work.

But it is a major pain and not very portable between machines. I am
really hoping that I will be able to convert this to the CF report
builder, although I have not been able to convert our detailed, multi
column report to the cf report builder copying the functionality and
design.

Recreating your reports with cfreport builder may be quicker.  People
probably hate this option.


On Nov 26, 2007 3:28 PM, Billy Cox [EMAIL PROTECTED] wrote:
 Does anyone have experience with outputting Crystal Reports using
 ColdFusion? We have a number of existing Crystal Reports that I would like
 to leverage if possible. I am also making a purchase decision between Blue
 Dragon Server JX and CF Server 8.0, so I want to know whether CF Server
 (cfreport tag) is worth the extra bucks.


 Thanks,

 Billy Cox
 Old World Spices
 [EMAIL PROTECTED]







 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293850
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfreport question

2007-10-24 Thread Luke Fromhold

Thanks for the suggestion Rob. Getting cfreport to save the report to a
file, then calling it in the cfwindow is still producing the gibberish.
Running the cfreport directly in the browser works great and so does calling
the saved pdf though.  So I thought remove the cfreport component all
together and just try opening some other pdf in the cfwindow.. same problem.


I'm thinking this is heading towards the conclusion that the cfwindow can't
open pdf or flash types?  But can anyone give this a try and confirm/deny
that this is the case? It really would be the perfect solution for what I'm
after.

-Original Message-
From: Rob Parkhill [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 24 October 2007 3:07 AM
To: CF-Talk
Subject: Re: cfreport question

Luke,

do you have the filename attribute set for your cfreport tag? If this isn't
set it basically outputs the code for a PDF file into HTML, making well
gobbledegook...

Try setting a filename and then your overwrite attributes for the cfreport
tag.

I have the following:

cfwindow 
  closable=true 
  draggable=true  
  name=Test 
  modal=false 
  initshow=true 
  height=350 
  width=325 
  title=Test 
  x=600 
  y=150
   cfreport format=pdf 
 filename=test.pdf 
 overwrite=yes
 template=reports/newcoldfusionreport.cfr
cfreportparam name=name value=1
   /cfreport
/cfwindow

And it generated a PDF that I could find on my local machine and if I wanted
to code in reference to it, I could.

HTH,

Rob 



~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291941
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfreport question

2007-10-24 Thread Andrew Scott

I suppose you didn't try to load a src file with the extension .cfm
and use that template to set the content type to pdf with cfcontent
and load the pdf that way?

I have seen it happen from time to time with the report displaying
giberish and that has been my solution with cached content.


On 10/24/07, Luke Fromhold [EMAIL PROTECTED] wrote:
 Thanks for the suggestion Rob. Getting cfreport to save the report to a
 file, then calling it in the cfwindow is still producing the gibberish.
 Running the cfreport directly in the browser works great and so does calling
 the saved pdf though.  So I thought remove the cfreport component all
 together and just try opening some other pdf in the cfwindow.. same problem.


 I'm thinking this is heading towards the conclusion that the cfwindow can't
 open pdf or flash types?  But can anyone give this a try and confirm/deny
 that this is the case? It really would be the perfect solution for what I'm
 after.

 -Original Message-
 From: Rob Parkhill [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 24 October 2007 3:07 AM
 To: CF-Talk
 Subject: Re: cfreport question

 Luke,

 do you have the filename attribute set for your cfreport tag? If this isn't
 set it basically outputs the code for a PDF file into HTML, making well
 gobbledegook...

 Try setting a filename and then your overwrite attributes for the cfreport
 tag.

 I have the following:

 cfwindow
   closable=true
   draggable=true
   name=Test
   modal=false
   initshow=true
   height=350
   width=325
   title=Test
   x=600
   y=150
cfreport format=pdf
  filename=test.pdf
  overwrite=yes
  template=reports/newcoldfusionreport.cfr
 cfreportparam name=name value=1
/cfreport
 /cfwindow

 And it generated a PDF that I could find on my local machine and if I wanted
 to code in reference to it, I could.

 HTH,

 Rob



 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291942
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfreport question

2007-10-24 Thread Luke Fromhold

Yeah that's the way I was attempting originally. I also gave saving the
report to a variable a go (using the 'name' attrb of cfreport) and then
calling that variable via cfcontent too. Further, I've tried using cfreport
to save the report to a pdf on the hdd, then using filename and cfcontent to
display it.  All result in the same.  (and same tests with flashpaper too.)
When I put the url into the browser directly, they display great. Putting
that url into 'source' attrb of cfwindow shows the junk.  Using Firebug and
watching the call when cfwindow opens, I believe I am setting the content
type correctly.

-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 24 October 2007 6:30 PM
To: CF-Talk
Subject: Re: cfreport question

I suppose you didn't try to load a src file with the extension .cfm
and use that template to set the content type to pdf with cfcontent
and load the pdf that way?

I have seen it happen from time to time with the report displaying
giberish and that has been my solution with cached content.


On 10/24/07, Luke Fromhold [EMAIL PROTECTED] wrote:
 Thanks for the suggestion Rob. Getting cfreport to save the report to a
 file, then calling it in the cfwindow is still producing the gibberish.
 Running the cfreport directly in the browser works great and so does
calling
 the saved pdf though.  So I thought remove the cfreport component all
 together and just try opening some other pdf in the cfwindow.. same
problem.


 I'm thinking this is heading towards the conclusion that the cfwindow
can't
 open pdf or flash types?  But can anyone give this a try and confirm/deny
 that this is the case? It really would be the perfect solution for what
I'm
 after.

 -Original Message-
 From: Rob Parkhill [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 24 October 2007 3:07 AM
 To: CF-Talk
 Subject: Re: cfreport question

 Luke,

 do you have the filename attribute set for your cfreport tag? If this
isn't
 set it basically outputs the code for a PDF file into HTML, making well
 gobbledegook...

 Try setting a filename and then your overwrite attributes for the cfreport
 tag.

 I have the following:

 cfwindow
   closable=true
   draggable=true
   name=Test
   modal=false
   initshow=true
   height=350
   width=325
   title=Test
   x=600
   y=150
cfreport format=pdf
  filename=test.pdf
  overwrite=yes
  template=reports/newcoldfusionreport.cfr
 cfreportparam name=name value=1
/cfreport
 /cfwindow

 And it generated a PDF that I could find on my local machine and if I
wanted
 to code in reference to it, I could.

 HTH,

 Rob



 



~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291943
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfreport question

2007-10-23 Thread Luke Fromhold

Ok, so I'm now trying to get my reports opening within a cfwindow. I've got
the reporting.cfm page as the value of the source attribute (of cfwindow),
and am binding some form values from a cfform on the page containing the
cfwindow tag to the url in the source attribute, to be used when
reporting.cfm calls the report.  I buggered up the bind first off but
figured it out using cfdebug in my url, now I'm pretty sure they're working
well and aren't the prob.. but now when I click the button that calls the
window, it displays a window with absolute gobbledegook as its contents. It
does this, regardless of the format (flash or pdf) I choose for the report.
Before I tear my hair out trying to figure out where I'm going wrong (well,
before I pull any more out) does anyone know if I can actually use cfreport
inside a cfwindow?  Could that be causing my problem? I just haven't been
able to find a reference to it anywhere.

Thanks again
Luke

-Original Message-
From: Dale Fraser [mailto:[EMAIL PROTECTED] 
Sent: Monday, 22 October 2007 2:32 PM
To: CF-Talk
Subject: RE: cfreport question

Of course,

Just open the report in a new window, when they are done, they close the
window and are back where they were.

You could also open he report in a frame, div, cfwindow. What ever you like.
This should work equally well with either flash player or Pdf versions.

Although here we use PDF.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: Luke Fromhold [mailto:[EMAIL PROTECTED] 
Sent: Monday, 22 October 2007 2:06 PM
To: CF-Talk
Subject: cfreport question

Hi All

Just a small cfreport query that any advice you have to offer would be much
appreciated.. I've got an app that has a reporting component and while I've
made good use of cf report builder and have some very funky reports I'd
really like to find a way for users to view them without being pushed out of
their flow - ie. At the moment pages with cfreport display the reports in
the whole browser window, and to return they need to the previous screen
they need to use the back button. Is there any way to display cfreports
embedded inside the page like a cfdocument can be, so the report is viewed
in the context of the rest of the interface? My googling and livedoc'ing
have suggested this isn't the case, but I'm hoping I couldn't find the right
search term.  Or, being a mighty javascript novice, can anyone hook me up
with some js that could open a report in a new window? Is that the only
other alternative?

Cheers
Luke






~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291805
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfreport question

2007-10-23 Thread Andrew Scott

As long as you are setting the content type you should be fine.


On 10/23/07, Luke Fromhold [EMAIL PROTECTED] wrote:
 Ok, so I'm now trying to get my reports opening within a cfwindow. I've got
 the reporting.cfm page as the value of the source attribute (of cfwindow),
 and am binding some form values from a cfform on the page containing the
 cfwindow tag to the url in the source attribute, to be used when
 reporting.cfm calls the report.  I buggered up the bind first off but
 figured it out using cfdebug in my url, now I'm pretty sure they're working
 well and aren't the prob.. but now when I click the button that calls the
 window, it displays a window with absolute gobbledegook as its contents. It
 does this, regardless of the format (flash or pdf) I choose for the report.
 Before I tear my hair out trying to figure out where I'm going wrong (well,
 before I pull any more out) does anyone know if I can actually use cfreport
 inside a cfwindow?  Could that be causing my problem? I just haven't been
 able to find a reference to it anywhere.

 Thanks again
 Luke

 -Original Message-
 From: Dale Fraser [mailto:[EMAIL PROTECTED]
 Sent: Monday, 22 October 2007 2:32 PM
 To: CF-Talk
 Subject: RE: cfreport question

 Of course,

 Just open the report in a new window, when they are done, they close the
 window and are back where they were.

 You could also open he report in a frame, div, cfwindow. What ever you like.
 This should work equally well with either flash player or Pdf versions.

 Although here we use PDF.

 Regards
 Dale Fraser

 http://learncf.com


 -Original Message-
 From: Luke Fromhold [mailto:[EMAIL PROTECTED]
 Sent: Monday, 22 October 2007 2:06 PM
 To: CF-Talk
 Subject: cfreport question

 Hi All

 Just a small cfreport query that any advice you have to offer would be much
 appreciated.. I've got an app that has a reporting component and while I've
 made good use of cf report builder and have some very funky reports I'd
 really like to find a way for users to view them without being pushed out of
 their flow - ie. At the moment pages with cfreport display the reports in
 the whole browser window, and to return they need to the previous screen
 they need to use the back button. Is there any way to display cfreports
 embedded inside the page like a cfdocument can be, so the report is viewed
 in the context of the rest of the interface? My googling and livedoc'ing
 have suggested this isn't the case, but I'm hoping I couldn't find the right
 search term.  Or, being a mighty javascript novice, can anyone hook me up
 with some js that could open a report in a new window? Is that the only
 other alternative?

 Cheers
 Luke






 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291806
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfreport question

2007-10-23 Thread Rob Parkhill

Luke,

do you have the filename attribute set for your cfreport tag? If this isn't set 
it basically outputs the code for a PDF file into HTML, making well 
gobbledegook...

Try setting a filename and then your overwrite attributes for the cfreport tag.

I have the following:

cfwindow 
  closable=true 
  draggable=true  
  name=Test 
  modal=false 
  initshow=true 
  height=350 
  width=325 
  title=Test 
  x=600 
  y=150
   cfreport format=pdf 
 filename=test.pdf 
 overwrite=yes
 template=reports/newcoldfusionreport.cfr
cfreportparam name=name value=1
   /cfreport
/cfwindow

And it generated a PDF that I could find on my local machine and if I wanted to 
code in reference to it, I could.

HTH,

Rob 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291846
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cfreport question

2007-10-21 Thread Luke Fromhold

Hi All

Just a small cfreport query that any advice you have to offer would be much
appreciated.. I've got an app that has a reporting component and while I've
made good use of cf report builder and have some very funky reports I'd
really like to find a way for users to view them without being pushed out of
their flow - ie. At the moment pages with cfreport display the reports in
the whole browser window, and to return they need to the previous screen
they need to use the back button. Is there any way to display cfreports
embedded inside the page like a cfdocument can be, so the report is viewed
in the context of the rest of the interface? My googling and livedoc'ing
have suggested this isn't the case, but I'm hoping I couldn't find the right
search term.  Or, being a mighty javascript novice, can anyone hook me up
with some js that could open a report in a new window? Is that the only
other alternative?

Cheers
Luke


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291724
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cfreport question

2007-10-21 Thread Dale Fraser

Of course,

Just open the report in a new window, when they are done, they close the
window and are back where they were.

You could also open he report in a frame, div, cfwindow. What ever you like.
This should work equally well with either flash player or Pdf versions.

Although here we use PDF.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: Luke Fromhold [mailto:[EMAIL PROTECTED] 
Sent: Monday, 22 October 2007 2:06 PM
To: CF-Talk
Subject: cfreport question

Hi All

Just a small cfreport query that any advice you have to offer would be much
appreciated.. I've got an app that has a reporting component and while I've
made good use of cf report builder and have some very funky reports I'd
really like to find a way for users to view them without being pushed out of
their flow - ie. At the moment pages with cfreport display the reports in
the whole browser window, and to return they need to the previous screen
they need to use the back button. Is there any way to display cfreports
embedded inside the page like a cfdocument can be, so the report is viewed
in the context of the rest of the interface? My googling and livedoc'ing
have suggested this isn't the case, but I'm hoping I couldn't find the right
search term.  Or, being a mighty javascript novice, can anyone hook me up
with some js that could open a report in a new window? Is that the only
other alternative?

Cheers
Luke




~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfreport question

2007-10-21 Thread Luke Fromhold

Great thanks for that Dale.

-Original Message-
From: Dale Fraser [mailto:[EMAIL PROTECTED] 
Sent: Monday, 22 October 2007 2:32 PM
To: CF-Talk
Subject: RE: cfreport question

Of course,

Just open the report in a new window, when they are done, they close the
window and are back where they were.

You could also open he report in a frame, div, cfwindow. What ever you like.
This should work equally well with either flash player or Pdf versions.

Although here we use PDF.

Regards
Dale Fraser

http://learncf.com

-Original Message-
From: Luke Fromhold [mailto:[EMAIL PROTECTED] 
Sent: Monday, 22 October 2007 2:06 PM
To: CF-Talk
Subject: cfreport question

Hi All

Just a small cfreport query that any advice you have to offer would be much
appreciated.. I've got an app that has a reporting component and while I've
made good use of cf report builder and have some very funky reports I'd
really like to find a way for users to view them without being pushed out of
their flow - ie. At the moment pages with cfreport display the reports in
the whole browser window, and to return they need to the previous screen
they need to use the back button. Is there any way to display cfreports
embedded inside the page like a cfdocument can be, so the report is viewed
in the context of the rest of the interface? My googling and livedoc'ing
have suggested this isn't the case, but I'm hoping I couldn't find the right
search term.  Or, being a mighty javascript novice, can anyone hook me up
with some js that could open a report in a new window? Is that the only
other alternative?

Cheers
Luke

~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291727
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Query data to cfreport

2007-06-26 Thread chr chr

I am creating a big array of information and I want to create my report based 
on it and not an SQL query. Is this possible?

  Any help will be appreciated.
  
Thanks.
  chr

 
-
8:00? 8:25? 8:40?  Find a flick in no time
 with theYahoo! Search movie showtime shortcut.

~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282245
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFReport

2007-06-26 Thread ch g

I am creating a big array of information and I want to create my report based 
on it and not an SQL query. Is this possible?

Thanks.

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282284
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query data to cfreport

2007-06-26 Thread Charlie Griefer

convert the array into a query.

queryNew()
querySetCell()

and a loop and you should be good to go.

then pass the generated query to cfreport.

On 6/26/07, chr chr [EMAIL PROTECTED] wrote:
 I am creating a big array of information and I want to create my report based 
 on it and not an SQL query. Is this possible?

   Any help will be appreciated.

 Thanks.
   chr


 -
 8:00? 8:25? 8:40?  Find a flick in no time
  with theYahoo! Search movie showtime shortcut.

 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282300
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Cfreport and the right data

2007-06-04 Thread Chris Bleile

So I have been searching the net for about 3 days on this and no help so I now 
turn to you guys for help.  I have a report I built in Crystal Reports 11 and 
saved it into a dirctory called Reports.  The Reports folder is in the same 
directory as every thing else that my page uses.  I use a .cfc to the data for 
the report and on my return form the cfc to the index.cfm I call a page called 
GoalReport.cfm in it I have the cfreport tag.  It does dsiplay the report just 
fine the only thing that it dosent due is bring up the right data.  I have 
check my table time after time and the table has the right info in it but the 
report displays the old data.  How do I make it display the data that is in the 
table.  Here is the code that is in my GoalReport.cfm 

cfreport report = C:\Inetpub\wwwroot\Worksitenew23\Reports\Worksite Goal 
Report.rpt datasource=AgentSys username = sa password = 
/cfreport

Thanx Chris

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280046
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Try/Catch with CFREPORT

2007-03-28 Thread Greg Griffin

I am trying to leverage CFTRY/CFCATCH with some CFREPORT calls.  The CFCATCH 
block seems to catch any errors in the CFM page, but an error in the CFR does 
not seem to trigger the CFCATCH block in the calling page.

Any thoughts?

An example of what I'm doing is below.

Thanks,

Greg

- 

cftry

 bunch of code here ...

cfheader name=Content-Disposition value=#attributes.content_disposition#; 
filename=#replacenocase(attributes.reportname, ,_, 
all)#.#attributes.extension#

cfreport format=#attributes.format# template=reports/#attributes.template# 
name=myreport
 !--- loop through the form collection / submit values as reportparams ---
 cfloop collection=#form# item=key
  cfreportparam name=#key# value=#form[key]#
 /cfloop
/cfreport

cfcontent variable=#myreport# type=#attributes.mimetype# reset=Yes

cfcatch type=Any
 pError!  Try again./p
 cfabort
/cfcatch

/cftry

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273990
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Passing params to CFREPORT

2007-03-08 Thread Greg Griffin

I have no problems using the CFREPORTPARAM tags to pass variables into my 
CFREPORTS, but I want to know if there is a special scope for these paramaters.

In a nutshell, I'm trying to write a generic CFML wrapper for report calls.  I 
want to loop through the FORM structure (which might contain any number of 
paramaters) and pass this entire structure into the report instead of using 
(report specific) individual CFREPORTPARAM tags.

Am I making sense?  Has anyone tried anything like this?  Is this possible?  I 
read something about the REQUEST scope, but I coudln't get that to work.

Any clues?

Thanks,

Greg

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272030
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Passing params to CFREPORT

2007-03-08 Thread Kris Jones

I don't think there is a report parameter collection that you could
pass the form structure into, like you can with a cfc function call.

But, you could loop through your form scope, and add a cfreportparam
for each parameter you found there. Your form element names could be
such that you get the fact that it's a report param and the name of
the param from the name of the form element, and then, of course, the
value from the value of the form element.

I've made names of elements lists using the bar character, for
instance, then look at the first list element from the form element
name for a particular pattern, and get the name of the param from the
second list element from the form element name.

Cheers,
Kris

 In a nutshell, I'm trying to write a generic CFML wrapper for report calls.  
 I want to loop through the FORM structure (which might contain any number of 
 paramaters) and pass this entire structure into the report instead of using 
 (report specific) individual CFREPORTPARAM tags.

~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272033
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport Results

2007-02-19 Thread Tom Chiverton

On Wednesday 14 Feb 2007, Rick Root wrote:
  Is there something wrong with the documentation ?

 If by something wrong you mean it doesn't actually answer the question I
 asked,  The documention for cfreport makes no reference to return 
values, results,  or pages.

What do you think the chances are it has return values (ala cfhttp) but Adobe 
left them out of the docs ?

-- 
Tom Chiverton
Helping to heterogeneously e-enable frictionless e-tailers



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270098
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport Results

2007-02-14 Thread Rick Root

ping

On 2/13/07, Rick Root [EMAIL PROTECTED] wrote:

 Does CFREPORT return any data?  Like... I'm interested in knowing when I
 generate a PDF document, how many pages were generated.

 rick

 --
 I'm not certified, but I have been told that I'm certifiable...
 Visit http://www.opensourcecf.com today!




-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269783
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport Results

2007-02-14 Thread Tom Chiverton

On Wednesday 14 Feb 2007, Rick Root wrote:
ping

On 2/13/07, Rick Root [EMAIL PROTECTED] wrote:
Does CFREPORT return any data? Like... I'm interested in knowing when I
generate a PDF document, how many pages were generated.

Is there something wrong with the documentation ?

--
Tom Chiverton
Helping to conveniently generate network meta-services

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at St
James's Court Brown Street Manchester M2 2JF. A list of members is available
for inspection at the registered office. Any reference to a partner in relation
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be
confidential or legally privileged. If you are not the addressee you must not
read it and must not use any information contained in nor copy it nor inform
any person other than Halliwells LLP or the addressee of its existence or
contents. If you have received this email in error please delete it and notify
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport Results

2007-02-14 Thread Rick Root

On 2/14/07, Tom Chiverton [EMAIL PROTECTED] wrote:

 On Wednesday 14 Feb 2007, Rick Root wrote:
  ping
 
  On 2/13/07, Rick Root [EMAIL PROTECTED] wrote:
   Does CFREPORT return any data?  Like... I'm interested in knowing when
 I
   generate a PDF document, how many pages were generated.

 Is there something wrong with the documentation ?


If by something wrong you mean it doesn't actually answer the question I
asked, then yes, there's something wrong with the documentation.  I don't
ask questions like this without looking at livedocs.

The documention for cfreport makes no reference to return values, results,
or pages.

It has no attributes that I can see that allow you to get information about
the results of report generation, so I decided to ask the list in hopes that
someone might know if there's a way.

Thanks for not helping.

-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269830
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFReport Results

2007-02-14 Thread Ian Skinner

Does CFREPORT return any data? Like... I'm interested in knowing when I
generate a PDF document, how many pages were generated.

Rick

I do not know how to use this outside of the report file, but the number of
pages is available internally so that you can add output like page 3 of 5 to
the report. Beyond that, I don't know. What I suspect you may need to do is
find some widget that could introspect the pdf file. I would presume something
like that exists out there, probably even something in Java which should have a
good chance of being able to be tied into a ColdFusion app.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 | |
- Binary Soduko
| | |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269835
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport Results

2007-02-14 Thread Rick Root

On 2/14/07, Ian Skinner [EMAIL PROTECTED] wrote:


 I do not know how to use this outside of the report file, but the number
 of pages is available internally so that you can add output like page 3 of 5
 to the report.  Beyond that, I don't know.  What I suspect you may need to
 do is find some widget that could introspect the pdf file.  I would presume
 something like that exists out there, probably even something in Java which
 should have a good chance of being able to be tied into a ColdFusion app.


Just for fine, I googled getpdfinfo and found this on Ben Forta's blog

http://www.forta.com/blog/index.cfm/2006/8/11/GetPDFInfo-UDF-Returns-PDF-Information

If I'd written a UDF to do that, I would've named it getpdfinfo too I
guess!

Still, I think cfreport should have a result attribute like cfquery does...
or return some values like cfhttp and cffile do.

Rick


-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269836
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFReport Results

2007-02-13 Thread Rick Root

Does CFREPORT return any data?  Like... I'm interested in knowing when I
generate a PDF document, how many pages were generated.

rick

-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269679
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFREPORT problem: Report compilation error. Error at (158, 21: null

2006-11-08 Thread Kris Jones

Yesterday, we finally updated our QA servers to 7.02 (from 7.0). Some
reports which were running before the upgrade (with a couple of little
visual issues), now fail to run at all, generating this type of error:

Report compilation error. Error at (158, 21: null

Is there some previously compiled report cached away somewhere that
could be causing this? Any clues?

Thanks,
Kris

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259645
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFREPORT problem: Report compilation error. Error at (158, 21 : null

2006-11-08 Thread Dave Watts

 Yesterday, we finally updated our QA servers to 7.02 (from 
 7.0). Some reports which were running before the upgrade 
 (with a couple of little visual issues), now fail to run at 
 all, generating this type of error:
 
 Report compilation error. Error at (158, 21: null
 
 Is there some previously compiled report cached away 
 somewhere that could be causing this? Any clues?

I ran into a similar problem about two weeks ago. I think the fix was to
reinstall the latest Report Builder, open the reports with that, and resave
them.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259658
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFREPORT problem: Report compilation error. Error at (158, 21: null

2006-11-08 Thread Kris Jones

Found the issue on the Adobe forums (although the forums were erroring
with every click for awhile until I figured out that it didn't like an
unmatched parenthesis in my search terms).

And just for sake of the archives: CF 7.0.2 updater doesn't always
remove the older version of the commons-digester jar. Here is the
explanation and resolution:
http://www.cfreport.org/index.cfm/2006/7/3/702-update-error

Cheers,
Kris

 Yesterday, we finally updated our QA servers to 7.02 (from 7.0). Some
 reports which were running before the upgrade (with a couple of little
 visual issues), now fail to run at all, generating this type of error:
 Report compilation error. Error at (158, 21: null

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259663
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFREPORT problem: Report compilation error. Error at (158, 21 : null

2006-11-08 Thread Kris Jones

Hi Dave,

I saw at least 2 posts suggesting that re-saving the reports with the
patched report builder was the fix, but many more saying it wasn't the
the fix. And, in our case, the reports themselves had been created
with the 7.0.2 report builder, but were deployed on a server that was
running 7.0.1 or 7.0. (And, of course, the report builder itself isn't
installed on the QA and Production servers.)

Apparently the updater to 7.0.2 had a little bug where in certain
circumstances that one outdated .jar file was not getting removed when
it should have. Stopping the CF Application service, removing the .jar
file, and restarting the service fixed the problem immediately.

 I ran into a similar problem about two weeks ago. I think the fix was to
 reinstall the latest Report Builder, open the reports with that, and resave
 them.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259681
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ValueList not working in CFReport

2006-09-21 Thread david plotner

I am unable to use the valueList funtion in a CF Report (.cfr). I have seen 
multiple postings of this problem, but no resolution. Has anyone been able to 
use this function without getting an error indicating that the query field in 
invalid? If not, has anyone found a work around? I need to convert a query 
field to a comma delimited list for output purposes. Ideally, I will summarize 
multiple records in a footer, and then group the records for that group (one 
field) into a list in the footer. Any suggestions on how to do this?

Thanks!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253721
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFReport No data

Is there a way to create a CFReport that will show headings and such even when 
the query providing the data has no records at the moment.

Right now when I run the report I get a completely blank page.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253275
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Adding columns to the top of ervy page in cfreport

2006-09-15 Thread loathe

Hey,

I'm generating a PDF report using cfdocument.  I would like to have column
headers on each page of the report.  How would one do that?

L



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253280
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Adding columns to the top of ervy page in cfreport

2006-09-15 Thread Casey Dougall

 I'm generating a PDF report using cfdocument.  I would like to have column
 headers on each page of the report.  How would one do that?



cfdocumentitem type=header Header Cells/cfdocumentitem

There might be a space generated though between the header and your
table columns. but if you can guarantee the width of the columns this
might work.

-- 
Casey

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253281
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport No data

2006-09-15 Thread Jeff Fleitz

In the Report/Report Properties dialog there is a report setup parameter
called When No Query that has an option All Sections, No Detail, try
that.



On 9/15/06, Ian Skinner [EMAIL PROTECTED] wrote:

 Is there a way to create a CFReport that will show headings and such even
 when the query providing the data has no records at the moment.

 Right now when I run the report I get a completely blank page.


 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA

 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.



 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253282
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Adding columns to the top of ervy page in cfreport

2006-09-15 Thread loathe

Thanks man.

 -Original Message-
 From: Casey Dougall [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 15, 2006 1:33 PM
 To: CF-Talk
 Subject: Re: Adding columns to the top of ervy page in cfreport

  I'm generating a PDF report using cfdocument.  I would like to have
 column
  headers on each page of the report.  How would one do that?

 cfdocumentitem type=header Header Cells/cfdocumentitem

 There might be a space generated though between the header and your
 table columns. but if you can guarantee the width of the columns this
 might work.

 --
 Casey

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253283
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Adding columns to the top of ervy page in cfreport

2006-09-15 Thread loathe

Another hopefully quick one.

This report takes forever, that's just something that can't be changed :(

I would like to display a now loading/progress bar or something.

Any ideas?  I tried this without success:

cfflush
Please wait while your report is generated.
/cfflush

 

cfsavecontent variable=myReport
table style=width : 100%
tr
th colspan=7
bOrganizational Report/b
/th
/tr

cfif not len(trim(session.filter.parNo))
cfset session.filter.parNo = 0
/cfif
cf_organizationalreport level=1
ccnum_macom=#session.filter.ccnum_macom# pas_nr=#session.filter.parNo#
/table
/cfsavecontent

cfoutput
cfdocument filename=#orgReport.pdf format=PDF 
#myReport#
/cfdocument
/cfoutput

cflocation url=orgReport.pdf

 -Original Message-
 From: Casey Dougall [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 15, 2006 1:33 PM
 To: CF-Talk
 Subject: Re: Adding columns to the top of ervy page in cfreport
 
  I'm generating a PDF report using cfdocument.  I would like to have
 column
  headers on each page of the report.  How would one do that?
 
 
 
 cfdocumentitem type=header Header Cells/cfdocumentitem
 
 There might be a space generated though between the header and your
 table columns. but if you can guarantee the width of the columns this
 might work.
 
 --
 Casey
 
 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253291
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Adding columns to the top of ervy page in cfreport

2006-09-15 Thread Casey Dougall

Well, I have no idea on that one, I've only done those type of things
on form submissions.

head
script
image1 = new Image();
image1.src = /Images/Progress-Meter.gif;

function changeOn(){
document.getElementById(uploadImage).innerHTML = img
src=\/Images/Progress-Meter.gif\;
document.frmAddImage.btnSubmit.disabled = true;
document.frmAddImage.btnSubmit.value = Uploading 
Images...
}
/script
/head

body

cfform action=startreport.cfm
  cfinput type=submit onsubmit=changeOn(); 
name=btnSubmit
value=Upload Image /
/body

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253294
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFReport No data

In the Report/Report Properties dialog there is a report setup parameter called 
When No Query that has an option All Sections, No Detail, try that.

I did that with high hopes, but I still get a blank PDF.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253304
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport No data

2006-09-15 Thread Jeff Fleitz

Hey Ian,

It works for me, I just tried it again.  Are you using an embedded query in
the report (cfr), or passing the query to the report?  I am passing the
report the whole query object as opposed to parameters to an embedded query.


On 9/15/06, Ian Skinner [EMAIL PROTECTED] wrote:

 In the Report/Report Properties dialog there is a report setup parameter
 called When No Query that has an option All Sections, No Detail, try
 that.

 I did that with high hopes, but I still get a blank PDF.


 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA

 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.




 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253308
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFreport Test

Does anybody out there have a public, PDF format CFReport file that I can view? 
 I'm having a weird issue that when I view my pdf format pdf reports the text 
is mirror imaged.  I've viewed a couple dozen regular pdf files and they appear 
normally

It seems to be just me. My coworkers view the reports normally.  It seems to be 
just pdf format cfreports.  If I create a report as flash paper, it is 
displayed correctly.  If I view regular PDF file, it will display normally. 

This is incredibly weird.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253310
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport No data

2006-09-15 Thread Kris Jones

You've probably already gone through these suggestions, but I know
that I sometimes get fixated on what I think is the issue only to find
out I've waste valuable time by going down the wrong path. I spent an
afternoon trying to troubleshoot a blank report issue a while back,
thinking it was the parameters I was passing that were causing the
problem (I was passing the query into the report). It turned out it
worked fine in Firefox, just not in IE when returned as Flashpaper. I
was then able to determine that it was the security-fix that MS
installed to stop automatic execution of active content that was
causing the problem. So:

Does it work if you pass a query with records?
What format are you using (PDF, Flashpaper, etc)? Does it work with a
different format?
Have you tried a different browser (IE, vs. FF, vs Opera)?

Cheers,
Kris


On 9/15/06, Jeff Fleitz [EMAIL PROTECTED] wrote:
 Hey Ian,

 It works for me, I just tried it again.  Are you using an embedded query in
 the report (cfr), or passing the query to the report?  I am passing the
 report the whole query object as opposed to parameters to an embedded query.


 On 9/15/06, Ian Skinner [EMAIL PROTECTED] wrote:
 
  In the Report/Report Properties dialog there is a report setup parameter
  called When No Query that has an option All Sections, No Detail, try
  that.
 
  I did that with high hopes, but I still get a blank PDF.
 
 
  --
  Ian Skinner
  Web Programmer
  BloodSource
  www.BloodSource.org
  Sacramento, CA
 
  -
  | 1 |   |
  -  Binary Soduko
  |   |   |
  -
 
  C code. C code run. Run code run. Please!
  - Cynthia Dunning
 
  Confidentiality Notice:  This message including any
  attachments is for the sole use of the intended
  recipient(s) and may contain confidential and privileged
  information. Any unauthorized review, use, disclosure or
  distribution is prohibited. If you are not the
  intended recipient, please contact the sender and
  delete any copies of this message.
 
 
 
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253318
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFReport No data

Hey Ian,

It works for me, I just tried it again.  Are you using an embedded query in the 
report (cfr), or passing the query to the report?  I am passing the report the 
whole query object as opposed to parameters to an embedded query.


OK, I'm using an embedded query.  There are no parameters for this particular 
report.  They want every record.  At least at this point, I'll probably start 
passing a query in so I can make the report more flexible.

But before I do that, I have to figure out why when I and only I view the pdf 
formatted report, my text is mirror image.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253322
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFReport No data

Does it work if you pass a query with records?
What format are you using (PDF, Flashpaper, etc)? Does it work with a different 
format? Have you tried a different browser (IE, vs. FF, vs Opera)?

I am using PDF, I know for a fact that the current query returns no records.  
It is supposed to.  When it does return a record, something is wrong.  I just 
think it would be better to see the report and column headers with no data then 
a completely blank page.

At the moment I am using an embedded query.  I'll change this once I can figure 
out why I am seeing this maddening mirror image text when I open PDF formatted 
reports, not other pdf files, not other report formats and no one else has 
trouble with the PDF formatted reports.  But I see all the letters and mirror 
images in my Acrobat 7.



--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253323
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFreport Test

2006-09-15 Thread Jeff Fleitz

I have contacted you off-list about this.

On 9/15/06, Ian Skinner [EMAIL PROTECTED] wrote:

 Does anybody out there have a public, PDF format CFReport file that I can
 view?  I'm having a weird issue that when I view my pdf format pdf reports
 the text is mirror imaged.  I've viewed a couple dozen regular pdf files and
 they appear normally

 It seems to be just me. My coworkers view the reports normally.  It seems
 to be just pdf format cfreports.  If I create a report as flash paper, it is
 displayed correctly.  If I view regular PDF file, it will display normally.

 This is incredibly weird.


 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA

 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.



 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253328
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFReport mailing labels

2006-08-31 Thread Doug Bedient

Has anyone worked with this? I downloaded a tutorial and it works fine until 
you need anything to shift up if a field is blank. H-E-L-P! I love the control 
but it seems that it can't handle the simple art of maintaining the band height.

One thought I had was to build it outside of the report with returns and then 
sending one variable.

I couldn't get it to work however.

Any help would be extreemly helpful.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SOLUTION: CFReport, IE, and active content problem

2006-08-03 Thread Kris Jones

Finally found an answer to my IE, CFReport, CFC issue.

I had narrowed the issue down to occuring only when requesting
Flashpaper format. Another hapless soul posted his troubles (and
solution) on the forums yesterday. The issue is apparently an IE bug,
and only happens when asking for Flash-based objects when the form
requesting the object is sent with method=post. And here I was,
thinking it had to do with my CFC.

Knowledgebase article:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=a8a77279

And the forum posting at:
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=20threadid=1176563

Cheers,
Kris

 Trouble continues as I got the OK to update my development machine to
 7.0.2, and am still having the same problem in IE (Firefox still works
 fine).

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248738
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport, IE, and active content problem

2006-07-26 Thread Tom Chiverton

On Tuesday 25 July 2006 19:15, Kris Jones wrote:
 By better HTML wrapper do you mean change the way I'm calling the
 object, e.g., object, vs. embed? Since I am calling a CFReport tag, I
 don't have control over how that is returned. I'm unsure how I could

I am fairly sure there was/is a CFML tag that you can wrap around your call to 
CFReport.
As we don't use it, I don't recall anything much more about it, sorry !

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247729
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFReport, IE, and active content problem

2006-07-25 Thread Kris Jones

Okay, my earlier post about returning CFReport from a CFC came down to
it just not working in IE. Silly me--I work on an IE-only app, so that
is the first browser I try these days.

I have to kind of float the cursor around to find the place to click
to activate--to the user it just looks like a blank page. I'm not
crazy about the fixes published on Macromedia/Adobe for the automatic
execution of active content (this includes PDF and Flashpaper).

I see that Flash player execution is fixed in CF7.0.2 (we haven't
updated yet). Will this apply to PDF returned as well? Is there
another way to fix this without updating?

Thanks,
Kris

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247618
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport, IE, and active content problem

2006-07-25 Thread Tom Chiverton

On Tuesday 25 July 2006 16:36, Kris Jones wrote:
 I see that Flash player execution is fixed in CF7.0.2 (we haven't
 updated yet). Will this apply to PDF returned as well? Is there
 another way to fix this without updating?

You just need to use a better HTML wrapper.
There are CFML and JavaScript solutions out there, depending on what you want.

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247619
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport, IE, and active content problem

2006-07-25 Thread Kris Jones

I've checked resources at these sites:
http://www.adobe.com/devnet/activecontent/
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/overview/activating_activex.asp

By better HTML wrapper do you mean change the way I'm calling the
object, e.g., object, vs. embed? Since I am calling a CFReport tag, I
don't have control over how that is returned. I'm unsure how I could
call it from JS, as suggested on both Adobe and Microsoft, since it is
server-side object creation.

I do see that CF7.0.2 supposedly fixes the issue, and that there is a
7.0.1 hotfix that addresses it. However, because of config control
here, I am not free to implement these updates/hotfixes. (Believe me,
I'm asking for 7.0.2)

Are there other CF solutions out there that I'm just not finding?
Please elaborate.

Thanks,
Kris


 You just need to use a better HTML wrapper.
 There are CFML and JavaScript solutions out there, depending on what you want.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247642
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Return CFReport from CFC?

2006-07-21 Thread Kris Jones

Anybody? I've also tried cfcontent, setting the variable to the
returned report. It at least pops the flashpaper viewer, but no report
content. What am I doing wrong?

 Is it possible to return a report generated via CFReport from a CFC? I've 
 tried a
 couple of different things, and only end-up with a blank HTML page.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247270
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Return CFReport from CFC?

2006-07-20 Thread K Jones

Is it possible to return a report generated via CFReport from a CFC? I've tried 
a couple of different things, and only end-up with a blank HTML page.

-Name the cfreport, and returning using the name.
-Setting output=true on the method, and not returning anything.

I can save the report to a file, return the filename and call it that way, but 
how does that work when the format=flashpaper? 

In debugging, I can see my cfc.init(), the getReportXML() call, the 
getChartData_0() call, my reportmethod call. But no report? 

This worked fine outside of a CFC. Any thoughts? 

Cheers,
Kris

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247215
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFReport performance

Does anyone have any experience of bad performance when generating PDF's in
CF7 with CFReport?

Currently I'm trying to put together a process to generate around 100
dynamically populated PDF's at a time, but the performance is turning out to
be real bad (~1 min per PDF, not including getting the data.)

Does anyone know any ways of speeding things up a little?

-- 
Neil Middleton

Visit feed-squirrel.com


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247023
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport performance

2006-07-19 Thread JediHomer

What version of CF are you using?  Pro or Enterprise, because if
memory serves me correctly there is a lot more optimisation/thread
usage for PDF creation in the Enterprise version.


On 19/07/06, Neil Middleton [EMAIL PROTECTED] wrote:
 Does anyone have any experience of bad performance when generating PDF's in
 CF7 with CFReport?

 Currently I'm trying to put together a process to generate around 100
 dynamically populated PDF's at a time, but the performance is turning out to
 be real bad (~1 min per PDF, not including getting the data.)

 Does anyone know any ways of speeding things up a little?

 --
 Neil Middleton

 Visit feed-squirrel.com


 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247024
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport performance

2006-07-19 Thread Andy Allan

Depending on your requirements and environment, one possible way to
deal with this is:

1) Dedicated instance just for reporting
2) Use asynch gateway to hand off the report generation and then
forget about it.

Of course, you need Ent for this.

Andy

On 19/07/06, Neil Middleton [EMAIL PROTECTED] wrote:
 Does anyone have any experience of bad performance when generating PDF's in
 CF7 with CFReport?

 Currently I'm trying to put together a process to generate around 100
 dynamically populated PDF's at a time, but the performance is turning out to
 be real bad (~1 min per PDF, not including getting the data.)

 Does anyone know any ways of speeding things up a little?

 --
 Neil Middleton

 Visit feed-squirrel.com


 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247025
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport performance

Yeah, I thought of trying both of these.  The trouble I'm having is that
generating a single PDF page with the high-performance reporting (all
queries done outside the report) is taking longer than if I were to crack
out the crayons and draw it out myself.

On 7/19/06, Andy Allan [EMAIL PROTECTED] wrote:

 Depending on your requirements and environment, one possible way to
 deal with this is:

 1) Dedicated instance just for reporting
 2) Use asynch gateway to hand off the report generation and then
 forget about it.

 Of course, you need Ent for this.

 Andy

 On 19/07/06, Neil Middleton [EMAIL PROTECTED] wrote:
  Does anyone have any experience of bad performance when generating PDF's
 in
  CF7 with CFReport?
 
  Currently I'm trying to put together a process to generate around 100
  dynamically populated PDF's at a time, but the performance is turning
 out to
  be real bad (~1 min per PDF, not including getting the data.)
 
  Does anyone know any ways of speeding things up a little?
 
  --
  Neil Middleton
 
  Visit feed-squirrel.com
 
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247026
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport performance

2006-07-19 Thread Andy Allan

I'm assuming it's the actual PDF generation thats causing the issue?
If you run the queries on their own they spew out the data in a timely
fashion?

Out of interest, have you tried to see if flashpaper generation is quicker?

Andy

On 19/07/06, Neil Middleton [EMAIL PROTECTED] wrote:
 Yeah, I thought of trying both of these.  The trouble I'm having is that
 generating a single PDF page with the high-performance reporting (all
 queries done outside the report) is taking longer than if I were to crack
 out the crayons and draw it out myself.

 On 7/19/06, Andy Allan [EMAIL PROTECTED] wrote:
 
  Depending on your requirements and environment, one possible way to
  deal with this is:
 
  1) Dedicated instance just for reporting
  2) Use asynch gateway to hand off the report generation and then
  forget about it.
 
  Of course, you need Ent for this.
 
  Andy
 
  On 19/07/06, Neil Middleton [EMAIL PROTECTED] wrote:
   Does anyone have any experience of bad performance when generating PDF's
  in
   CF7 with CFReport?
  
   Currently I'm trying to put together a process to generate around 100
   dynamically populated PDF's at a time, but the performance is turning
  out to
   be real bad (~1 min per PDF, not including getting the data.)
  
   Does anyone know any ways of speeding things up a little?
  
   --
   Neil Middleton
  
   Visit feed-squirrel.com
  
  
  
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247028
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport performance

Well, I am now caching the queries between requests, so I have effectively
ruled that out of the equation.

However, I did notice the original report I have been given contained
TIF's.  Replacing these with JPG's made the generation time drop to less
than a second. :-)

Thanks for the help anyway.

N

On 7/19/06, Andy Allan  [EMAIL PROTECTED] wrote:

 I'm assuming it's the actual PDF generation thats causing the issue?
 If you run the queries on their own they spew out the data in a timely
 fashion?

 Out of interest, have you tried to see if flashpaper generation is
 quicker?

 Andy

 On 19/07/06, Neil Middleton  [EMAIL PROTECTED] wrote:
  Yeah, I thought of trying both of these.  The trouble I'm having is that
  generating a single PDF page with the high-performance reporting (all
  queries done outside the report) is taking longer than if I were to
 crack
  out the crayons and draw it out myself.
 
  On 7/19/06, Andy Allan [EMAIL PROTECTED]  wrote:
  
   Depending on your requirements and environment, one possible way to
   deal with this is:
  
   1) Dedicated instance just for reporting
   2) Use asynch gateway to hand off the report generation and then
   forget about it.
  
   Of course, you need Ent for this.
  
   Andy
  
   On 19/07/06, Neil Middleton  [EMAIL PROTECTED] wrote:
Does anyone have any experience of bad performance when generating
 PDF's
   in
CF7 with CFReport?
   
Currently I'm trying to put together a process to generate around
 100
dynamically populated PDF's at a time, but the performance is
 turning
   out to
be real bad (~1 min per PDF, not including getting the data.)
   
Does anyone know any ways of speeding things up a little?
   
--
Neil Middleton
   
Visit feed-squirrel.com
   
   
   
  
  
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247029
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport performance

Enterprise.

On 7/19/06, JediHomer [EMAIL PROTECTED] wrote:

 What version of CF are you using?  Pro or Enterprise, because if
 memory serves me correctly there is a lot more optimisation/thread
 usage for PDF creation in the Enterprise version.


 On 19/07/06, Neil Middleton [EMAIL PROTECTED] wrote:
  Does anyone have any experience of bad performance when generating PDF's
 in
  CF7 with CFReport?
 
  Currently I'm trying to put together a process to generate around 100
  dynamically populated PDF's at a time, but the performance is turning
 out to
  be real bad (~1 min per PDF, not including getting the data.)
 
  Does anyone know any ways of speeding things up a little?
 
  --
  Neil Middleton
 
  Visit feed-squirrel.com
 
 
 

 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247030
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport performance

2006-07-19 Thread Tom Chiverton

On Wednesday 19 July 2006 11:37, Neil Middleton wrote:
 However, I did notice the original report I have been given contained
 TIF's.  Replacing these with JPG's made the generation time drop to less
 than a second. :-)

Bet the files are a fair bit smaller too :-)

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247031
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFReport performance

Suprisingly not much...

On 7/19/06, Tom Chiverton [EMAIL PROTECTED] wrote:

 On Wednesday 19 July 2006 11:37, Neil Middleton wrote:
  However, I did notice the original report I have been given contained
  TIF's.  Replacing these with JPG's made the generation time drop to less
  than a second. :-)

 Bet the files are a fair bit smaller too :-)

 --
 Tom Chiverton

 

 This email is sent for and on behalf of Halliwells LLP.

 Halliwells LLP is a limited liability partnership registered in England
 and Wales under registered number OC307980 whose registered office address
 is at St James's Court Brown Street Manchester M2 2JF.  A list of members is
 available for inspection at the registered office. Any reference to a
 partner in relation to Halliwells LLP means a member of Halliwells LLP.
 Regulated by the Law Society.

 CONFIDENTIALITY

 This email is intended only for the use of the addressee named above and
 may be confidential or legally privileged.  If you are not the addressee you
 must not read it and must not use any information contained in nor copy it
 nor inform any person other than Halliwells LLP or the addressee of its
 existence or contents.  If you have received this email in error please
 delete it and notify Halliwells LLP IT Department on 0870 365 8008.

 For more information about Halliwells LLP visit www.halliwells.com.


 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247032
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFReport performance

2006-07-19 Thread Munson, Jacob

Neil,

I've never used report builder, but I've been curious about it lately.
When you guys are talking about report generation, I'm assuming you mean
building a bunch of PDFs that are put on the server for user
consumption.  Is that what you're doing?  And you got this down to less
than a second, for each PDF? 

 -Original Message-
 From: Neil Middleton [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, July 19, 2006 4:58 AM

 Does anyone have any experience of bad performance when 
 generating PDF's in CF7 with CFReport?
 
 Currently I'm trying to put together a process to 
 generate around 100
 dynamically populated PDF's at a time, but the 
 performance is turning
 out to be real bad (~1 min per PDF, not including getting the data.)
 Does anyone know any ways of speeding things up a little?

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247040
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport performance

Yes, on average a single page PDF, quite heavy on the design side was taking
around 2-300 ms excluding queries.  I'm currently putting it together to
make one multipage PDF for a printer, so it will be interesting to see how
long that takes.

On 7/19/06, Munson, Jacob [EMAIL PROTECTED] wrote:

 Neil,

 I've never used report builder, but I've been curious about it lately.
 When you guys are talking about report generation, I'm assuming you mean
 building a bunch of PDFs that are put on the server for user
 consumption.  Is that what you're doing?  And you got this down to less
 than a second, for each PDF?

  -Original Message-
  From: Neil Middleton [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, July 19, 2006 4:58 AM
 
  Does anyone have any experience of bad performance when
  generating PDF's in CF7 with CFReport?
 
  Currently I'm trying to put together a process to
  generate around 100
  dynamically populated PDF's at a time, but the
  performance is turning
  out to be real bad (~1 min per PDF, not including getting the data.)
  Does anyone know any ways of speeding things up a little?

 This transmission may contain information that is privileged, confidential
 and/or exempt from disclosure under applicable law. If you are not the
 intended recipient, you are hereby notified that any disclosure, copying,
 distribution, or use of the information contained herein (including any
 reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
 in error, please immediately contact the sender and destroy the material in
 its entirety, whether in electronic or hard copy format. Thank you. A1.



 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247046
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFReport performance