{"id":182,"date":"2015-12-11T14:47:03","date_gmt":"2015-12-11T14:47:03","guid":{"rendered":"http:\/\/o-calcpro.com\/wiki\/?p=182"},"modified":"2015-12-13T01:23:56","modified_gmt":"2015-12-13T01:23:56","slug":"implementing-a-bulk-summary-report","status":"publish","type":"post","link":"http:\/\/o-calcpro.com\/wiki\/2015\/12\/11\/implementing-a-bulk-summary-report\/","title":{"rendered":"Implementing a Bulk Summary Report"},"content":{"rendered":"

In O-Calc Pro there exists the concept of a “Bulk Summary Report”. This is a report where a compact bit of information for each of a collection of poles (as determined through the batch report system) is added to a single report page. This is as opposed to the normal report where each pole is represented by a single page or pages. <\/p>\n

\"\"\/<\/p>\n

Implementing a Bulk Summary Report is very nearly identical to a normal report.<\/p>\n

First change the report’s “Type” property to return “REPORT_TYPE.BULK_SUMMARY”.<\/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. public<\/span> override<\/span> REPORT_TYPE Type {<\/span> get<\/span> {<\/span> return<\/span> REPORT_TYPE.<\/span>BULK_SUMMARY<\/span>;<\/span> }<\/span> }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

    Next implement the report as normal. It is important to remember that unlike a normal report the method “CreateReport” will be called once and the method “AddPole” will be called MULTIPLE TIMES!<\/p>\n

    In previous examples we sometimes see that the header (for example) is implemented in the “AddPole” section, in a bulk report it must be implemented in the “CreateReport” section.<\/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. public<\/span> override<\/span> void<\/span> CreateReport(<\/span>PPLMain pPPLMain, List<<\/span>FileInfo><\/span> pSelectedFiles)<\/span><\/div><\/li>\n
    2.         {<\/span><\/div><\/li>\n
    3.             cPPLMain =<\/span> pPPLMain;<\/span><\/div><\/li>\n
    4.             string<\/span> groupName =<\/span> Name;<\/span><\/div><\/li>\n
    5.             foreach<\/span> (<\/span>FileInfo finfo in<\/span> pSelectedFiles)<\/span><\/div><\/li>\n
    6.             {<\/span><\/div><\/li>\n
    7.                 string<\/span> str =<\/span> System.IO<\/span><\/span>.<\/span>Path<\/span>.<\/span>GetDirectoryName<\/span>(<\/span>finfo.<\/span>FullName<\/span>)<\/span>;<\/span><\/div><\/li>\n
    8.                 int<\/span> idx =<\/span> str.<\/span>LastIndexOf<\/span>(<\/span>'\\\\<\/span>'<\/span>)<\/span>;<\/span><\/div><\/li>\n
    9.                 groupName =<\/span> str.<\/span>Substring<\/span>(<\/span>idx +<\/span> 1<\/span>)<\/span>;<\/span><\/div><\/li>\n
    10.                 break<\/span>;<\/span><\/div><\/li>\n
    11.             }<\/span><\/div><\/li>\n
    12.  <\/div><\/li>\n
    13.             cDocument =<\/span> new<\/span> MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Document<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
    14.             cPPLMain.<\/span>BuildStandardGroupReportHeader<\/span>(<\/span>cDocument, "Capacity Summary Report"<\/span>, groupName)<\/span>;<\/span><\/div><\/li>\n
    15.  <\/div><\/li>\n
    16.             MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Paragraph<\/span> paragraph =<\/span> cDocument.<\/span>LastSection<\/span>.<\/span>AddParagraph<\/span>(<\/span>"\\n<\/span>"<\/span>)<\/span>;<\/span><\/div><\/li>\n
    17.             paragraph.<\/span>Format<\/span>.<\/span>Borders<\/span>.<\/span>Top<\/span>.<\/span>Color<\/span> =<\/span> MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Colors<\/span>.<\/span>Blue<\/span>;<\/span><\/div><\/li>\n
    18.             paragraph.<\/span>Format<\/span>.<\/span>Borders<\/span>.<\/span>Top<\/span>.<\/span>Width<\/span> =<\/span> new<\/span> MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>Unit<\/span>(<\/span>.<\/span>025, MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>UnitType<\/span>.<\/span>Inch<\/span>)<\/span>;<\/span><\/div><\/li>\n
    19.             paragraph.<\/span>Format<\/span>.<\/span>Alignment<\/span> =<\/span> MigraDoc.<\/span>DocumentObjectModel<\/span>.<\/span>ParagraphAlignment<\/span>.<\/span>Center<\/span>;<\/span>        <\/div><\/li>\n
    20.         }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

      Now we implement a section that adds a new paragraph, table, row, etc. depending on the output we desire. For example…<\/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. public<\/span> override<\/span> void<\/span> AddPole(<\/span>PPLPole pPole, String<\/span> pPoleName)<\/span><\/div><\/li>\n
      2.         {<\/span><\/div><\/li>\n
      3.             while<\/span> (<\/span>cPPLMain.<\/span>cCapReport<\/span>.<\/span>poleCapacitySummary1<\/span>.<\/span>GuyWireStatus<\/span>.<\/span>Text<\/span>.<\/span>EndsWith<\/span>(<\/span>"..."<\/span>)<\/span>)<\/span><\/div><\/li>\n
      4.             {<\/span><\/div><\/li>\n
      5.                 System.Threading<\/span><\/span>.<\/span>Thread<\/span>.<\/span>Sleep<\/span>(<\/span>500<\/span>)<\/span>;<\/span><\/div><\/li>\n
      6.                 cPPLMain.<\/span>UpdateCapacitySummaryView<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
      7.             }<\/span><\/div><\/li>\n
      8.             String<\/span> poleName;<\/span><\/div><\/li>\n
      9.             if<\/span> (<\/span>pPoleName ==<\/span> null<\/span> ||<\/span> pPoleName.<\/span>Trim<\/span>(<\/span>)<\/span> ==<\/span> String<\/span>.<\/span>Empty<\/span>)<\/span><\/div><\/li>\n
      10.             {<\/span><\/div><\/li>\n
      11.                 poleName =<\/span> " "<\/span> +<\/span> pPole.<\/span>GetValueAndConvertToString<\/span>(<\/span>"Pole Number"<\/span>)<\/span>;<\/span><\/div><\/li>\n
      12.             }<\/span><\/div><\/li>\n
      13.             else<\/span><\/div><\/li>\n
      14.             {<\/span><\/div><\/li>\n
      15.                 poleName =<\/span> pPoleName;<\/span><\/div><\/li>\n
      16.             }<\/span><\/div><\/li>\n
      17.             cPPLMain.<\/span>CapacitySummaryViewToMigraDoc<\/span>(<\/span>cDocument.<\/span>LastSection<\/span>, poleName, "Summary of "<\/span>)<\/span>;<\/span><\/div><\/li>\n
      18.             cDocument.<\/span>LastSection<\/span>.<\/span>AddParagraph<\/span>(<\/span>"\\n<\/span>"<\/span>)<\/span>;<\/span><\/div><\/li>\n
      19.         }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

        Now this report will appear in the “Bulk Reports” section of the batch reporting tool but WILL NOT be included in the normal reports tab of the main user interface. When select all of the poles in a batch report will be included in order on a single report which will be placed at the beginning of a merged report (if one was requested).<\/p>\n\"Facebook\"<\/a>\"twitter\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>","protected":false},"excerpt":{"rendered":"

        In O-Calc Pro there exists the concept of a “Bulk Summary Report”. This is a report where a compact bit of information for each of a collection of poles (as determined through the batch report system) is added to a single report page. This is as opposed to the normal report where each pole is ..<\/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-182","post","type-post","status-publish","format-standard","hentry","category-report-development"],"_links":{"self":[{"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts\/182","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=182"}],"version-history":[{"count":3,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"predecessor-version":[{"id":185,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/posts\/182\/revisions\/185"}],"wp:attachment":[{"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/o-calcpro.com\/wiki\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}