Data Spacing issue in the exported Excel File

[Former Member]

Hello

I am upgrading my application from crystal 8.5 to latest crystal 13 API.

Upon previewing report is coming absolute fine but on exporting it in Microsoft Excel 97-2003 Data only format, there are few extra rows coming up in excel. On further investigation, I found there are 30 sections which have "Suppress blank section" property enabled.

These sections are not visible in report preview but while exporting previewed report from crystal report viewer, it seems this property is not entertained anymore. It is displaying 30 rows for 30 blank sections.

Is there anyway through which we can suppress generation of these rows in excel?

I am using below mentioned tools for this:

Visual Studio 2012

Crystal designer 2013

Crystal RAS API: 32 bit Support Pack 10 (v. 13.0.10.1385)

VB.Net

Thanks for looking into the issue.

Saurabh

[former_member11696 · Accepted solution]

Hi Saurabh,

Do you see the same thing when exporting from the Designer?

Don

[Former Member · Accepted solution]

Yes I do. It displays the same behavior using designer too.