Report Export formatted like spreadsheet for multiple survey responses

Question

Hi there,

I am wanting to export out a report that lists each survey response by row, rather than individual reports.

This is an example of what I mean. Normally, the survey results are exported as a pdf from an Excel spreadsheet.

Survey responseSurnameFirst nameDateContact TypeStakeholder GroupNotes1      2      3

Is this possible? There will be rows and rows of these responses.

elpinguino · Answer

Thanks Deon. I am using a related table, so that could work for me. Could you show me how I'd write that out though to capture the operation name and date? I'm not so good with code. I have the template attached in the original post.

For now, I'm exporting it as a word doc, and then the user will have to manually open up in word and change those lines.

DeonLengton · Answer

Hi

We had a similar requirement and I have a solution in my head that I still need to put into reality:

If you create a dummy "main" feature layer and capture your records into a repeat (related table) then you could get this to work using the repeat reporting functionality...

But like i say i havent done it yet

elpinguino · Answer

I'm almost there, but was wondering if someone who understands code a bit more could point out what I'm doing wrong here. I've attached my template. This is the error I'm getting.

Comms_Record_sampleTemplateSummary_amended.docx