Custom Reports with Repeats Issue

SMW_GIS — Fri, 01 Feb 2019 15:14:44 GMT

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

Re: Custom Reports with Repeats Issue

JamesTedrick — Mon, 04 Feb 2019 23:49:07 GMT

Hi Steven,

The repeat itself will handle the creation of the additional rows; I believe this format will accomplish what you are wanting:

Re: Custom Reports with Repeats Issue

SMW_GIS — Thu, 07 Feb 2019 14:48:11 GMT

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!

topic Re: Custom Reports with Repeats Issue in ArcGIS Survey123 Questions

Custom Reports with Repeats Issue

Re: Custom Reports with Repeats Issue

Re: Custom Reports with Repeats Issue