Unplanned
Last Updated: 01 Feb 2023 16:34 by Jim
Jim
Created on: 28 Apr 2020 15:33
Type: Bug Report
1
Export to CSV missing CRLF in Master Report of Master-Detail with Hidden SubReport

I have designed a report that includes an embedded SubReport. When I render it to PDF, it looks correct.  When I render it to CSV, there are two issues that are probably related:

  1. The heading row columns should contain the main report's detail row textbox names followed by the SubReport 's detail row textbox names.  However, the SubReport 's detail textbox names are repeated a few times instead of just included once.
  2. In the situation where there is no detail row in the SubReport, a CRLF is missing at the end of the main report's detail data.  The next main report detail data appears on the same row, following the previous main report's last detail column -- it should begin on the next line.

I understand that CSV Rendering is not recommend for hierarchical output as described in the CSV Design Considerations. However, I am using the Hide the SubReport if no Values to not display the SubReport when there is not data. The hidden SubReport implementation can be seen in the below binding expression.

 

<Bindings>
    <Binding Expression="=Count(Fields.AP_OPN_CHK_VCH_NO_C)>0" Path="Parent.Parent.Parent.Visible"/>
</Bindings>

 

Using the above approach, the master report is missing a CRLF when the detail data is not visible. The record shows it appended to the previous record.

I started working with Support on this issue and have discovered that it might be a bug. As a result, I am also attaching their sample to help replicate the issue. For the pdf and csv output see the first attachment in the original ticket.

 

 

Attached Files:
3 comments
Jim
Posted on: 01 Feb 2023 16:34
We decided to not allow our users to export reports with subreports to CSV, so I don't know if this has been fixed.
Darshan
Posted on: 01 Feb 2023 10:51
Is this bug fixed? I have the latest version of Telerik 16.2.22.1109 and this bug is still present in this version.
ADMIN
Ivan Hristov
Posted on: 05 May 2020 13:50

Hello Jim,

My name is Ivan Hristov and I'm a developer in the Reporting team. I'm sorry to hear you're experiencing problems with the CSV export. We recognize this behavior as a bug and we have logged it in our backlog for fixing.

As soon as we start working on it, the status of the work item will change and you'll get notified about it.

Regards,
Ivan Hristov
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.