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
Solved! Go to Solution.
Hi Steven,
The repeat itself will handle the creation of the additional rows; I believe this format will accomplish what you are wanting:
Hi Steven,
The repeat itself will handle the creation of the additional rows; I believe this format will accomplish what you are wanting:
Thank you James! That worked as you described. I needed to strip away the other rows and use the format you listed. The report generated new rows for the repeats in the same formatting. Saved me so much time. Really appreciate it!