Latest Contributions by SMW_GIS

For future releases of Portal for ArcGIS, will the option to generate reports WITH photos become available? James Tedrick‌ ... View more

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 ... View more