Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

CFMAIL and CFCHART

Hello,
  I have a CFMAIL process that is working fine.

I can pass data from SQL Server and send to our Executive Management the Sales information they need.

Now....

They want to see the data in a bar chart.

I have a page that returns the data fine in a regular page...
But when I try and pass it through CFMAIL...there are no errors...but no chart either.

I'm sending the page in HTML format.

Can this be done?

Thanks
0
lrbrister
Asked:
lrbrister
  • 3
  • 2
1 Solution
 
mrichmonCommented:
You need to either embed the image in the message or have it an <image src="http://yourdomain.com/pathtochart.jpg"> in the message
0
 
lrbristerAuthor Commented:
mrichman,
  That chart is dynamic and looking at live data.

So the page that has the chart is http://mnydomain/chart.cfm
0
 
mrichmonCommented:
But the chart is actually generating into something.  Or if not you can force it to do so with the output attribute.  Then that is what you send in the email - otherwise the best you can do is link to the page.
0
 
lrbristerAuthor Commented:
mrichman...
  I plan on awarding you the points momentarily.  The chart is returned to the page with the code below.

Are you saying I can change the output some way?

<cfchart
    xAxisTitle="My Company Sales By QTR"
    yAxisTitle="Sales"
      chartwidth="500"
      showygridlines="yes"
           scaleFrom="0"
           scaleTo="400000"
      gridlines="5"
      show3d="yes">
      <cfchartseries type="bar"
      seriesLabel="This Year" seriescolor="336699">
                                                 <cfchartData item="QTR1" value="#sby.QTR1#">      
                                                  <cfchartData item="QTR2" value="#sby.QTR2#">
                                                  <cfchartData item="QTR3" value="#sby.QTR3#">            
                                                     <cfchartData item="QTR4" value="#sby.QTR4#">
                                        </cfchartseries>                  
                        </cfchart>
0
 
lrbristerAuthor Commented:
mrichman,
  Looks like even when I make those changes and have the output as a jpg format I get the red x image blank page.

Whether I run it on the cfmail page or include it.

Thanks for trying...looks like the effort may not be worth the return.  CEO will just have to learn to live with his disappointment. :-)

Points being awarded now.

0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now