{"id":152,"date":"2015-12-03T15:57:38","date_gmt":"2015-12-03T15:57:38","guid":{"rendered":"http:\/\/o-calcpro.com\/wiki\/?p=152"},"modified":"2015-12-03T16:03:43","modified_gmt":"2015-12-03T16:03:43","slug":"adding-a-custom-chart-to-a-report","status":"publish","type":"post","link":"http:\/\/o-calcpro.com\/wiki\/2015\/12\/03\/adding-a-custom-chart-to-a-report\/","title":{"rendered":"Adding a custom chart to a report"},"content":{"rendered":"

In a previous posting ( http:\/\/o-calcpro.com\/wiki\/2015\/12\/02\/creating-a-real-report\/<\/a>\u00a0) we saw how to create a simple report. In that case it was the Applied Load report. In this article we are going to extend that report by adding a chart of the heights.<\/p>\n

\"\"<\/p>\n

O-Calc includes a graphing API that is used to generate all of the graphs that appear on the “Charts” tab of the main interface. To keep a consistent look and feel you can take advantage of that same API when defining your reports.<\/p>\n

The following code would be added to the bottom of the “AddPole” (immediately after the FinalizeTable(); cDocument.LastSection.AddParagraph(“\\n”); code) method of the report defined in the previous article (see link at the top of this article) and will result in the generation of the chart and its inclusion in the resulting report. See inline documentation for an understanding of the code.<\/p>\n

\n\n\t\t
\n\n\t\t
\n\t\t\t\t\t\t< View plain text<\/span> ><\/a>\n\t\t\t\t\t<\/div>\n\n\t\t
C#<\/div>\n\n\t\t\n\t\t
\n\n\t<\/div>\n\t\n\t
\n\t\t
  1. using<\/span> (<\/span>ZedGraphControl zedGraph =<\/span> new<\/span> ZedGraphControl(<\/span>)<\/span>)<\/span><\/div><\/li>\n
  2.             {<\/span><\/div><\/li>\n
  3.                 \/\/create the report<\/span><\/div><\/li>\n
  4.  <\/div><\/li>\n
  5.                 GraphPane graphPane =<\/span> zedGraph.<\/span>GraphPane<\/span>;<\/span><\/div><\/li>\n
  6.                 graphPane.<\/span>CurveList<\/span>.<\/span>Clear<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
  7.  <\/div><\/li>\n
  8.                 \/\/ Set the titles and axis labels and get data<\/span><\/div><\/li>\n
  9.                 graphPane.<\/span>Title<\/span>.<\/span>Text<\/span> =<\/span> "Load Heights"<\/span>;<\/span><\/div><\/li>\n
  10.                 graphPane.<\/span>XAxis<\/span>.<\/span>Title<\/span>.<\/span>Text<\/span> =<\/span> " "<\/span>;<\/span><\/div><\/li>\n
  11.                 if<\/span> (<\/span>PPLGridModel.<\/span>Attribute<\/span>.<\/span>UnitsConvention<\/span> ==<\/span> PPLGridModel.<\/span>Attribute<\/span>.<\/span>UNITS_CONVENTION<\/span>.<\/span>METRIC<\/span>)<\/span><\/div><\/li>\n
  12.                 {<\/span><\/div><\/li>\n
  13.                     graphPane.<\/span>YAxis<\/span>.<\/span>Title<\/span>.<\/span>Text<\/span> =<\/span> "Height Meters"<\/span>;<\/span><\/div><\/li>\n
  14.                 }<\/span><\/div><\/li>\n
  15.                 else<\/span><\/div><\/li>\n
  16.                 {<\/span><\/div><\/li>\n
  17.                     graphPane.<\/span>YAxis<\/span>.<\/span>Title<\/span>.<\/span>Text<\/span> =<\/span> "Height Feet"<\/span>;<\/span><\/div><\/li>\n
  18.                 }<\/span><\/div><\/li>\n
  19.  <\/div><\/li>\n
  20.  <\/div><\/li>\n
  21.                 zedGraph.<\/span>RestoreScale<\/span>(<\/span>graphPane)<\/span>;<\/span><\/div><\/li>\n
  22.                 graphPane.<\/span>YAxis<\/span>.<\/span>Type<\/span> =<\/span> AxisType.<\/span>Linear<\/span>;<\/span><\/div><\/li>\n
  23.                 graphPane.<\/span>YAxis<\/span>.<\/span>Scale<\/span>.<\/span>Mag<\/span> =<\/span> 0<\/span>;<\/span><\/div><\/li>\n
  24.                 graphPane.<\/span>YAxis<\/span>.<\/span>Scale<\/span>.<\/span>MagAuto<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>\n
  25.                 graphPane.<\/span>YAxis<\/span>.<\/span>Scale<\/span>.<\/span>IsUseTenPower<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>\n
  26.                 graphPane.<\/span>XAxis<\/span>.<\/span>Type<\/span> =<\/span> AxisType.<\/span>Linear<\/span>;<\/span><\/div><\/li>\n
  27.                 graphPane.<\/span>XAxis<\/span>.<\/span>Scale<\/span>.<\/span>Mag<\/span> =<\/span> 0<\/span>;<\/span><\/div><\/li>\n
  28.                 graphPane.<\/span>XAxis<\/span>.<\/span>Scale<\/span>.<\/span>MagAuto<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>\n
  29.                 graphPane.<\/span>XAxis<\/span>.<\/span>Scale<\/span>.<\/span>IsUseTenPower<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>\n
  30.                 graphPane.<\/span>XAxis<\/span>.<\/span>MinorGrid<\/span>.<\/span>IsVisible<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>\n
  31.                 graphPane.<\/span>YAxis<\/span>.<\/span>MinorGrid<\/span>.<\/span>IsVisible<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>\n
  32.  <\/div><\/li>\n
  33.                 PointPairList points =<\/span> new<\/span> PointPairList(<\/span>)<\/span>;<\/span><\/div><\/li>\n
  34.  <\/div><\/li>\n
  35.                 foreach<\/span> (<\/span>ForceSummary fs in<\/span> loads)<\/span><\/div><\/li>\n
  36.                 {<\/span><\/div><\/li>\n
  37.                     PointPair pp;<\/span><\/div><\/li>\n
  38.                     if<\/span> (<\/span>PPLGridModel.<\/span>Attribute<\/span>.<\/span>UnitsConvention<\/span> ==<\/span> PPLGridModel.<\/span>Attribute<\/span>.<\/span>UNITS_CONVENTION<\/span>.<\/span>METRIC<\/span>)<\/span><\/div><\/li>\n
  39.                     {<\/span><\/div><\/li>\n
  40.                         pp =<\/span> new<\/span> PointPair(<\/span>0<\/span>, PPLGridModel.<\/span>Attribute<\/span>.<\/span>InchesToMeters<\/span>(<\/span>fs.<\/span>cHeightOfForceApplicationAboveGLinInches<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>\n
  41.                     }<\/span><\/div><\/li>\n
  42.                     else<\/span><\/div><\/li>\n
  43.                     {<\/span><\/div><\/li>\n
  44.                         pp =<\/span> new<\/span> PointPair(<\/span>0<\/span>, PPLGridModel.<\/span>Attribute<\/span>.<\/span>InchesToFeet<\/span>(<\/span>fs.<\/span>cHeightOfForceApplicationAboveGLinInches<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>\n
  45.                     }<\/span><\/div><\/li>\n
  46.                     points.<\/span>Add<\/span>(<\/span>pp)<\/span>;<\/span><\/div><\/li>\n
  47.                 }<\/span><\/div><\/li>\n
  48.                 \/\/add the groundline<\/span><\/div><\/li>\n
  49.                 points.<\/span>Add<\/span>(<\/span>0<\/span>, 0<\/span>)<\/span>;<\/span><\/div><\/li>\n
  50.  <\/div><\/li>\n
  51.                 LineItem curve =<\/span> graphPane.<\/span>AddCurve<\/span>(<\/span>"Attachment Points"<\/span>, points, Color.<\/span>Blue<\/span>, SymbolType.<\/span>Star<\/span>)<\/span>;<\/span><\/div><\/li>\n
  52.                 curve.<\/span>Line<\/span>.<\/span>Width<\/span> =<\/span> 2<\/span>;<\/span><\/div><\/li>\n
  53.  <\/div><\/li>\n
  54.  <\/div><\/li>\n
  55.                 \/\/Add the chart to the report<\/span><\/div><\/li>\n
  56.                 zedGraph.<\/span>Width<\/span> =<\/span> 640<\/span>;<\/span><\/div><\/li>\n
  57.                 zedGraph.<\/span>Height<\/span> =<\/span> 500<\/span>;<\/span><\/div><\/li>\n
  58.                 \/\/ signal we are done and rendering can begin<\/span><\/div><\/li>\n
  59.                 zedGraph.<\/span>AxisChange<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
  60.  <\/div><\/li>\n
  61.                 \/\/get the resulting chart as a bitmap<\/span><\/div><\/li>\n
  62.                 Image img =<\/span> zedGraph.<\/span>ImageRender<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
  63.  <\/div><\/li>\n
  64.                 \/\/save the bitmap to a temp file<\/span><\/div><\/li>\n
  65.                 String<\/span> fname =<\/span> System.IO<\/span><\/span>.<\/span>Path<\/span>.<\/span>GetTempFileName<\/span>(<\/span>)<\/span> +<\/span> ".jpg"<\/span>;<\/span><\/div><\/li>\n
  66.                 img.<\/span>Save<\/span>(<\/span>fname)<\/span>;<\/span><\/div><\/li>\n
  67.  <\/div><\/li>\n
  68.                 try<\/span><\/div><\/li>\n
  69.                 {<\/span><\/div><\/li>\n
  70.                     int<\/span> imgWidth =<\/span> 0<\/span>;<\/span><\/div><\/li>\n
  71.                     int<\/span> imgHeight =<\/span> 0<\/span>;<\/span><\/div><\/li>\n
  72.  <\/div><\/li>\n
  73.                     using<\/span> (<\/span>System.Drawing<\/span><\/span>.<\/span>Image<\/span> bimage =<\/span> PPL_CorvusImageViewer.<\/span>CorvusBitmap<\/span>.<\/span>FromFile<\/span>(<\/span>fname)<\/span>)<\/span><\/div><\/li>\n
  74.                     {<\/span><\/div><\/li>\n
  75.                         imgWidth =<\/span> bimage.<\/span>Width<\/span>;<\/span><\/div><\/li>\n
  76.                         imgHeight =<\/span> bimage.<\/span>Height<\/span>;<\/span><\/div><\/li>\n
  77.                         bimage.<\/span>Dispose<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
  78.                     }<\/span><\/div><\/li>\n
  79.  <\/div><\/li>\n
  80.                     MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Section<\/span> section =<\/span> cDocument.<\/span>LastSection<\/span>;<\/span><\/div><\/li>\n
  81.                     MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Paragraph<\/span> paragraph =<\/span> section.<\/span>LastParagraph<\/span>;<\/span><\/div><\/li>\n
  82.  <\/div><\/li>\n
  83.                     double<\/span> printableAreaWidth =<\/span> ReportFont.<\/span>cPageWidth<\/span>;<\/span><\/div><\/li>\n
  84.                     double<\/span> printableAreaHeight =<\/span> printableAreaWidth *<\/span> 3.0<\/span> \/<\/span> 4.0<\/span>;<\/span><\/div><\/li>\n
  85.  <\/div><\/li>\n
  86.                     MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Shapes<\/span>.<\/span>Image<\/span> image =<\/span> paragraph.<\/span>AddImage<\/span>(<\/span>fname)<\/span>;<\/span><\/div><\/li>\n
  87.                     paragraph.<\/span>Format<\/span>.<\/span>Alignment<\/span> =<\/span> MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>ParagraphAlignment<\/span>.<\/span>Center<\/span>;<\/span><\/div><\/li>\n
  88.                     double<\/span> scaleWidth =<\/span> printableAreaWidth \/<\/span> (<\/span>(<\/span>double<\/span>)<\/span>imgWidth)<\/span>;<\/span><\/div><\/li>\n
  89.                     double<\/span> scaleHeight =<\/span> printableAreaHeight \/<\/span> (<\/span>(<\/span>double<\/span>)<\/span>imgHeight)<\/span>;<\/span><\/div><\/li>\n
  90.                     image.<\/span>Height<\/span> =<\/span> new<\/span> MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Unit<\/span>(<\/span>printableAreaHeight, MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>UnitType<\/span>.<\/span>Inch<\/span>)<\/span>;<\/span><\/div><\/li>\n
  91.                 }<\/span><\/div><\/li>\n
  92.                 catch<\/span> {<\/span> }<\/span><\/div><\/li>\n
  93.             }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n\"Facebook\"<\/a>\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"

    In a previous posting ( http:\/\/o-calcpro.com\/wiki\/2015\/12\/02\/creating-a-real-report\/\u00a0) we saw how to create a simple report. In that case it was the Applied Load report. In this article we are going to extend that report by adding a chart of the heights. O-Calc includes a graphing API that is used to generate all of the graphs that ..<\/p>\n

    <\/div>\n

    Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-152","post","type-post","status-publish","format-standard","hentry","category-report-development"],"_links":{"self":[{"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts\/152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/comments?post=152"}],"version-history":[{"count":2,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts\/152\/revisions"}],"predecessor-version":[{"id":154,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts\/152\/revisions\/154"}],"wp:attachment":[{"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/media?parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/categories?post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/tags?post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}