"Do not display items with no value in summary" not working

SELECT node_data_field_scripture_book.field_scripture_book_value AS node_data_field_scripture_book_field_scripture_book_value,
COUNT(node.nid) AS num_records
FROM drup_node node 
LEFT JOIN drup_content_field_speaker node_data_field_speaker ON node.vid = node_data_field_speaker.vid
LEFT JOIN drup_node node_node_data_field_speaker ON node_data_field_speaker.field_speaker_nid = node_node_data_field_speaker.nid
INNER JOIN drup_content_field_scripture_book node_data_field_scripture_book ON node.vid = node_data_field_scripture_book.vid
WHERE (node.status <> 0) AND (node.type in ('sermon'))
GROUP BY node_data_field_scripture_book_field_scripture_book_value
ORDER BY node_data_field_scripture_book_field_scripture_book_value ASC

I'm having trouble getting the exported View to appear correctly, so here's a link to it in a pastebin.

http://drupal.pastebin.com/f260f42e5

I did read the submission guidelines. This, however, seems like it is not a CCK issue, since the same thing is happening with a view based on taxonomy term. The part of the view that is based on a CCK field is at line 1058 of the pastebin, and the one based on taxonomy term is at line 817. If you still think that it's a CCK issue, I'll gladly move the issue to their queue.

Here's the preview query for the taxonomy-based argument:

SELECT term_node.tid AS term_node_tid,
term_data.name AS term_data_name,
COUNT(node.nid) AS num_records
FROM drup_node node 
LEFT JOIN drup_content_field_speaker node_data_field_speaker ON node.vid = node_data_field_speaker.vid
LEFT JOIN drup_node node_node_data_field_speaker ON node_data_field_speaker.field_speaker_nid = node_node_data_field_speaker.nid
LEFT JOIN drup_term_node term_node ON node.vid = term_node.vid
LEFT JOIN drup_term_data term_data ON term_node.tid = term_data.tid
WHERE (node.status <> 0) AND (node.type in ('sermon')) AND (term_data.vid in ('7'))
GROUP BY term_data_name, term_node_tid
ORDER BY term_data_name ASC

and here is the one for the CCK-based argument:

SELECT node_data_field_scripture_book.field_scripture_book_value AS node_data_field_scripture_book_field_scripture_book_value,
COUNT(node.nid) AS num_records
FROM drup_node node 
LEFT JOIN drup_content_field_speaker node_data_field_speaker ON node.vid = node_data_field_speaker.vid
LEFT JOIN drup_node node_node_data_field_speaker ON node_data_field_speaker.field_speaker_nid = node_node_data_field_speaker.nid
INNER JOIN drup_content_field_scripture_book node_data_field_scripture_book ON node.vid = node_data_field_scripture_book.vid
WHERE (node.status <> 0) AND (node.type in ('sermon'))
GROUP BY node_data_field_scripture_book_field_scripture_book_value
ORDER BY node_data_field_scripture_book_field_scripture_book_value ASC

Hope that helps.