0 회신 929913 님이 Oct 18, 2013 8:15 AM에 마지막 답글

    Matrix report in XML publisher with dynamic column groups

    929913

      hi,

      i have one matrix report in txt format having 5 columns under 1 month heading.

      Now i want that all these 5 columns should repeat for multiple months depending upon input parameters.

       

      S. No.Organization NameOrganization IdProject Code
      1GRANDWOODS 268251495monthJanuary
      Wrk Count VenWrk Cont Prw NewWrk Amt Ven NewWrk Amt Prw NewTot Amt New
      New00000
      Existing010255000255000
      Total010255000255000

       

      rtf template is as follows:

      1. S. No.

      Organization Name

      Organization Id

      Project Code

       

       

       

       

       

       

      F CS_11

      ORGANIZATION_NAME

      ORGANIZATION_ID

      PROJECT_CODE E

       

      month

       

       

      Wrk Count Ven

      Wrk Cont Prw New

      Wrk Amt Ven New

      Wrk Amt Prw New

      Tot Amt New

      New

      F WRK_COUNT_VEN_NEW

      WRK_CONT_PRW_NEW

      WRK_AMT_VEN_NEW

      WRK_AMT_PRW_NEW

      TOT_AMT_NEW

      Existing

      F WRK_CONT_VEN_EXISTING

      WRK_CONT_PRW_EXISING

      WRK_AMT_VEN_EXISTING

      WRK_AMT_PRW_EXISTING E

      TOT_AMT_EXIS

      Total

      TOT_CONT_VEN_NEW_EXIS

      TOT_CONT_PRW_NEW_EXIS

      TOT_AMT_VEN_NEW_EXIS

      TOT_AMT_PRW_NEW_EXIS

      TOT E

      E

       

       

      now, please help me as to how repeat these 5 columns for multiple months.

       

      if anybody has some template for matrix report with multiple coloumn group repeatation, pls. share along with sample data.

       

       

      regards,

      mohit gupta