I need to export this as a .csv file with pipe delimited.

 

When I do the export with these parameters and then open the file in Excel, none of the subreport data appears.  Other data in the main report does appear correctly.

 

What gives?  I can export as a .txt file and the subreport data is included in the export file.....why not in the .csv file? 

 

Is there a setting I'm missing somewhere?

 

Thanks in advance for any advice.