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