Blank row between Details a and b when exporting to Excel

building reports crystal reports
1

I created a report which is comprised of two sections: Details a and Details b. All other sections are suppressed or hidden. The two sections each contain a subreport. The subreports are formated so that they look the same, i.e. same alignments, same columns widths, same data types, same number of columns, etc. However the data is pulled very differently by the two subreports.

The purpose of the report is to be scheduled and exported to an excel spreadsheet which will be used as a data file that will be picked up by an another application each month and loaded into another database.

Here is what the report looks like in preview:

4 02/30/09 84848 73
4 03/03/09 37232 73
4 03/02/09 13131 70
4 03/05/09 23542 70
4 02/07/09 23432 70

The first two rows are from the subreport that resides in section Details a. The last three rows are from the subreport that resides in section Details b.

Here is what the data looks like when it is exported to an excel spreadsheet:

4 02/30/09 84848 73
4 03/03/09 37232 73

4 03/02/09 13131 70
4 03/05/09 23542 70
4 02/07/09 23432 70

Here is my question, how can I prevent that extra row from being created in the xls file during the export? I need the data to be just like it is shown in the preview (with no extra rows). Also, I tried to place both subrports in Section Details however they will still export with that extra row.

Anyone ever run into this issue?

pete171 (BOB member since 2008-09-22)

2

reduce the sub-report size… hide all other sections in the subreport where you dont have any report fields…

hope this helps

Muna :india: (BOB member since 2008-08-05)

3

Unfortunately, I tried that already and it did not make a difference. The blank row still exists.

pete171 (BOB member since 2008-09-22)

4

is there any null values ??

Muna :india: (BOB member since 2008-08-05)

5

Are you exporting to Excel or Excel Data Only?

If you are exporting to Excel, I’ve found that the separater between sections is rendered as an empty row in Excel.

So the separater between DetailsA and DetailsB is creating the blank row you are seeing I believe.

If you are exporting to Excel Data Only, I’ve found that subreports just don’t convert well. It’s a well known issue with the Excel Exporter for Crystal.

jesibl (BOB member since 2008-11-18)

6

Hi pete171

Try to put two subreports in one detail section instead of two and suppress unwanted sections.

It will works :yesnod:

Arjun (BOB member since 2008-07-28)