This discussion is archived
0 Replies Latest reply: Oct 18, 2013 1:15 AM by 929913 RSS

Matrix report in XML publisher with dynamic column groups

929913 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points