This is a migrated thread and some comments may be shown as answers.

Blank rows in Export to Excel with Subreport

2 Answers 164 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Hrushikesh Mokashi
Top achievements
Rank 1
Hrushikesh Mokashi asked on 24 Dec 2009, 12:58 PM
Hi All,

I am using Q3 2008 version of Telerik Reporting.
I have 1 report which contains a subreport in it.
Subrport is for each row (e.g. For each Date field in main report I am showing events for the dates in the subreport below that row).

I have aligned the report and subreport properly.
When I do export to excel a blank row gets created between tow main report records event regardless of whether there is data exists in subreport or not.

(If subreport has multiple rows for a record then there is no blank row between s8ubreport records but still it shows a blank row between tow main report records).

If I remove subreport from the main report and do export to excel then there is no blank row betwen two records.

Is this a correct scnerio that if there is any subreport then it takes a row for that subreport?
If not then can anyone please let me knowm what could be missing?

Best Regards,
Hrushikesh.

2 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 04 Jan 2010, 09:46 AM
Hello Hrushikesh,

We suspect that you're talking about spacer rows which are created when the items in the report are not aligned properly - see Design Considerations for Excel Rendering topic for more info.
Usually the easiest way to detect where an empty space is coming from is to apply some background color to the report section/item. The SubReport item is a separate data region and as such it has groups and report header/footer - are those visible by any chance and create "an empty row"?

Regards,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Dada
Top achievements
Rank 1
answered on 30 Sep 2013, 07:21 AM
Hi Hrushikesh,
If you still facing the problem, you can try this.

You can set the height of the detail section in the report to  height that actual records takes
(details height = detailheight - subreport height)
if subreport has doesnt  have rows whils hiding the report also set the height..

this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(0.3D);
Tags
General Discussions
Asked by
Hrushikesh Mokashi
Top achievements
Rank 1
Answers by
Steve
Telerik team
Dada
Top achievements
Rank 1
Share this question
or