We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

CFMAIL and CFCHART

Larry Brister
on
Medium Priority
338 Views
Last Modified: 2013-12-24
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
Comment
Watch Question

Commented:
You need to either embed the image in the message or have it an <image src="http://yourdomain.com/pathtochart.jpg"> in the message
Larry Bristersr. Developer

Author

Commented:
mrichman,
  That chart is dynamic and looking at live data.

So the page that has the chart is http://mnydomain/chart.cfm
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Larry Bristersr. Developer

Author

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>
Larry Bristersr. Developer

Author

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.

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.