I have a View which displays signup data in tabular form, including "Additional Signup Info". In the Page version of the view, the style of which is Table, I group results so that open signups appear at the top of the listing, with closed signups appearing below. That works fine.
But my users need to be able to download a spreadsheet of the signup results. I added a Feed display to the view, leaving all the rest of the definitions exactly the same as the working Page display. The results don't group, but that's not really critical. The problem is that the "Additional Signup Info" is not correct for any of the resulting rows. I have tried selecting "Parent sort" in the style setting, but no change. It doesn't matter which format I choose, e.g. XLS or CSV. No matter what I do, all signup data, including the email address, is correct EXCEPT for the Additional Signup Info, which just repeats the same (incorrect) data for every row.
I am using Drupal core 6.19, Signup 6.x-1.x-dev (2010-Jul-11), Views 6.x-2.11, Bonus: Views Export 6.x-1.0.
I looked a the SQL code generated for both views, and the only difference I can see is that the Page code ends with
ORDER BY node_data_field_start_field_start_value ASC
whereas the Feed version doesn't have this statement. Both SQL code sets include
signup_log.form_data AS signup_log_form_data,
Both also include
LEFT JOIN signup_log signup_log ON node.nid = signup_log.nid
I'm stumped. Any suggestions?