Excel export extra rows

03-17-2006, 12:28 PM

Why does the excel export add an extra row to every line in my report that uses backcolor?  I have noticed this in some reports that have the PageHeader.BackColor = LightGray and in another report that sets the backcolor of every other detail line to LightGray.  When I look at the excel output, I have two rows for the lines that are gray - one row with gray background and no data and another row with gray background and the detail data.

I am using the following settings:

xls.FileFormat = DataDynamics.ActiveReports.Export.Xls.FileFormat.Xls97Plus;

xls.UseCellMerging = true;

xls.AutoRowHeight = false;

xls.RemoveVerticalSpace = true;

xls.MinColumnWidth = (float).375;

 

thanks!

Re: Excel export extra rows

03-20-2006, 10:58 AM

The first step is to make sure that you are using the latest build (1205). By default, the Active Reports assemblies should be installed at the following path on your machine: C:\Program Files\Common Files\Data Dynamics\ActiveReports for .NET 2.0. You can right click on the ActiveReports.dll, choose Properties, and then version, to check which version of the asseblies you are currently running. If you are not using the most recent build, you can download it here: http://www.datadynamics.com/forums/64/ShowForum.aspx. If this does not resolve the issue, please save your report output to the RDF format and attach it to this thread so that I can take a look at it. You can save the report to the RDF format by calling the .Document.Save method off of the report object after the report has been run.

Ex.

rpt.Document.Save(@"C:\Output.RDF");

Re: Excel export extra rows

03-20-2006, 1:17 PM

I am definitely using build 1205.  I have checked this a number of times. :-)

I am attaching a zip file with the xls and the rdf of the report so you can see what is happening.

thanks! Koren

Re: Excel export extra rows

03-20-2006, 1:36 PM
The problem seems to be related to the UseCellMerging Property. Try setting this property to false.

Re: Excel export extra rows

03-21-2006, 2:26 PM

Well, that didn't work.  Now, all of my rows that expand on the other types of reports (e.g. PDF, HTML) create two rows in excel.  Any other ideas?

thx, Koren

Re: Excel export extra rows

04-28-2008, 12:37 PM
Did anyone ever figure this out?  I am having the same problem.  It adds extra rows.  I have 30 other Excel reports that do not do this.  They are all exactly the same. The only difference is this one report is really wide.

Re: Excel export extra rows

04-29-2008, 12:23 PM
Thank you for your post. Unfortunately, I have been unable to reproduce the described behavior using the latest build of ARN2.0. Please ensure you are using the latest build of ARN2.0 available (1261). You can find the update here:

http://www.datadynamics.com/forums/64/ShowForum.aspx

Also, the attached sample works well in my testing. Would it be possible for you to modify the attached sample to reproduce the behavior you are encountering if my testing approach does not accurately represent your situation?

Thanks,
    Eric

Re: Excel export extra rows

10-28-2009, 8:53 AM
Hi
We use ActiveReports 3 SP3 (5.3.1436.2) and have the similar problem during export to excel
UseCellMerging must be set to true
RemoveVerticalSpace also has some effect...
Also, if field with non-empty background has some value, it works correctly, but if this field is empty - it doesn't
RPX sample in attachment.

Thanks,
Yevgen

Re: Excel export extra rows

10-28-2009, 1:36 PM
I was able to replicate the issue at our end. I have opened a new Case 138023 to get this issue addressed. I have also added your E-mail address as an affected user to this case. You will be notified when the issue gets fixed.

Regards,
Ankit Nigam

Re: Excel export extra rows

03-02-2010, 4:04 PM
Hi,

Is this issue resolved? I am using AR 6 (version 6.0.2250.0) and getting similar issue for excel export. When I give backcolor to a text box and exported to excel, it creates extra row with no data and with back color. It works fine with pdf and excel export works fine when backcolor is removed.

Please let me know.

Thanks

Re: Excel export extra rows

03-03-2010, 1:33 AM
Hello,

Currently the issue is assigned to our development team. I have attached your E-mail address to the list of affected users for this case. You will be notified when the issue gets fixed.

Regards,
Ankit Nigam

Re: Excel export extra rows

07-11-2011, 12:49 AM
i also encountered this problem which the backolor will take more than 1 rows.Is this problem solved???

Re: Excel export extra rows

07-11-2011, 5:11 AM
Hello,

The above mentioned case is yet not fixed. You will be notified when the issue gets fixed.

Thanks,
Subodh

Re: Excel export extra rows

05-18-2012, 1:31 PM
Any word on a fix for this? I have the same issue with Active Reports 6...

Re: Excel export extra rows

05-20-2012, 9:44 PM
earl.seay,

The case 138023 is yet to be resolved. However, I have added your email address to the list of affected users by it. You would be notified as soon as the case would get resolved in future.

Best Regards,
Pragati Kaushik