Several issues with the report generator:
1. Is there a way to make an "Answer" report by not having to make x number of new columns and drag each of my codes to a new column? i.e. Could I just choose one of my code sets and specify that I want to export all nested codes under that code each in a separate column?
2. I'd love to make a single report with chosen columns exported as "Answer" and others as "Question".
I know I can export separate reports and then combine them but this is inconvenient when working with a lot of codes.
3.It would be much more convenient if report columns would automatically change their headline to the name of the answer code dragged to them. Renaming them manually is a great pain when working with many codes.
4.I do exporting so that I can work with my codes in Excel. The most convenient method I've found is export report to html, and then copy to Excel. However, Excel takes line breaks within the html table cells as new rows. E.g.
"Code name
comes out as two rows in Excel.
so I also have to add a step where I copy the html to a text editor and remove all the line breaks.
Consequently it would be easier if you included direct export to an Excel compatible format or at least made the cell output for one code without a line break at the bullet point.
Any advice is welcome.