AnsweredAssumed Answered

Custom Reports with Repeats Issue

Question asked by sworkmanhs on Feb 1, 2019
Latest reply on Feb 7, 2019 by sworkmanhs

Hi everyone.

 

I'm having an issue with formatting of answers from a repeated section of my form in a customized report.  I need to know if this functionality is possible.  If not then I need to explore other options.  Is there a way to split the answers from a repeated section of my form into multiple rows in a table? Please help! This is a big issue that is slowing down a deliverable that needs to be submitted. 

 

My report has 3 sections of rows in a table that need to be populated with answers from 3 records in a repeated group. Right now it is grouping all answers in one row.  See my screen shots below. I've also attached a word document that may be easier to read.  

 

My custom report is set up like this:

 

Pipe Num

Clk Pos

Pipe Dir

Pipe Material

Pipe Shape

Pipe Dia

Seal Condition

Special Condition

Access Point ID

${#Manhole_Connections} ${Pipe_Number} ${/Manhole_Connections}

${#Manhole_Connections} ${Clock_Position} ${/Manhole_Connections}

${#Manhole_Connections} ${Direction} ${/Manhole_Connections}

${#Manhole_Connections} ${Material} ${/Manhole_Connections}

${#Manhole_Connections} ${Shape}${/Manhole_Connections}

${#Manhole_Connections} ${Diam_1} ${/Manhole_Connections}

${#Manhole_Connections} ${Seal_Condition} ${/Manhole_Connections}

${#Manhole_Connections} ${Special_Condition}${/Manhole_Connections}

${#Manhole_Connections} ${Structure_ID} ${/Manhole_Connections}

Comments:

${#Manhole_Connections} ${Comments} ${/Manhole_Connections}

${#Manhole_Connections} ${Pipe_Number} ${/Manhole_Connections}

${#Manhole_Connections} ${Clock_Position} ${/Manhole_Connections}

${#Manhole_Connections} ${Direction} ${/Manhole_Connections}

${#Manhole_Connections} ${Material} ${/Manhole_Connections}

${#Manhole_Connections} ${Shape}${/Manhole_Connections}

${#Manhole_Connections} ${Diam_1} ${/Manhole_Connections}

${#Manhole_Connections} ${Seal_Condition} ${/Manhole_Connections}

${#Manhole_Connections} ${Special_Condition}${/Manhole_Connections}

${#Manhole_Connections} ${Structure_ID} ${/Manhole_Connections}

Comments:

${#Manhole_Connections} ${Comments} ${/Manhole_Connections}

${#Manhole_Connections} ${Pipe_Number} ${/Manhole_Connections}

${#Manhole_Connections} ${Clock_Position} ${/Manhole_Connections}

${#Manhole_Connections} ${Direction} ${/Manhole_Connections}

${#Manhole_Connections} ${Material} ${/Manhole_Connections}

${#Manhole_Connections} ${Shape}${/Manhole_Connections}

${#Manhole_Connections} ${Diam_1} ${/Manhole_Connections}

${#Manhole_Connections} ${Seal_Condition} ${/Manhole_Connections}

${#Manhole_Connections} ${Special_Condition}${/Manhole_Connections}

${#Manhole_Connections} ${Structure_ID} ${/Manhole_Connections}

Comments:

${#Manhole_Connections} ${Comments} ${/Manhole_Connections}

 

The report generates results that look like this:

 

 

Pipe Num

Clk Pos

Pipe Dir

Pipe Material

Pipe Shape

Pipe Dia

Seal Condition

Special Condition

Access Point ID

 1  2  3

 6  12  3

 OUT  IN  IN

 Vitrified Clay Pipe  Vitrified Clay Pipe  Vitrified Clay Pipe

 Circular Circular Circular

 8  8  8

 Sound  Sound  Sound

 Gravity Relief ConnectionGravity Relief ConnectionGravity Relief Connection

 21843MH_21855MH  21862MH_21843MH  31349MH_21843MH

Comments:

     

 1  2  3

 6  12  3

 OUT  IN  IN

 Vitrified Clay Pipe  Vitrified Clay Pipe  Vitrified Clay Pipe

 Circular Circular Circular

 8  8  8

 Sound  Sound  Sound

 Gravity Relief ConnectionGravity Relief ConnectionGravity Relief Connection

 21843MH_21855MH  21862MH_21843MH  31349MH_21843MH

Comments:

     

 1  2  3

 6  12  3

 OUT  IN  IN

 Vitrified Clay Pipe  Vitrified Clay Pipe  Vitrified Clay Pipe

 Circular Circular Circular

 8  8  8

 Sound  Sound  Sound

 Gravity Relief ConnectionGravity Relief ConnectionGravity Relief Connection

 21843MH_21855MH  21862MH_21843MH  31349MH_21843MH

Comments:

     

 

 

I'd like my report to generate results that look like this:

 

Pipe Num

Clk Pos

Pipe Dir

Pipe Material

Pipe Shape

Pipe Dia

Seal Condition

Special Condition

Access Point ID

 1

 6

 OUT

 Vitrified Clay Pipe

 Circular

 8

 Sound

 Gravity Relief Connection

 21843MH_21855MH

Comments:

     

 2

 12

 IN

 Vitrified Clay Pipe

 Circular

 8

 Sound

 Gravity Relief Connection

21862MH_21843MH

Comments:

     

3

 3

 IN

Vitrified Clay Pipe

 Circular

 8

 Sound

 Gravity Relief Connection

 31349MH_21843MH

Comments:

     

 

Thank you for any help that you can offer.

 

Steven

Attachments

Outcomes