Report Design: Blank lines in data section

Blank lines in data section

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7234
Printed Date: 17 May 2024 at 8:41pm

Topic: Blank lines in data section

Posted By: GowthamSen
Subject: Blank lines in data section
Date Posted: 03 Aug 2009 at 12:04pm

Hi,

I am using a box in data section to display data in a table. Its working fine.

But some times, some blank lines are being displayed in the report.

This happens only when the table expands to another page.

So in the first page at the end of the table some times, a blank line is being displayed.

What I observed is, if I increase the space between rows, its disappeared. I understand that.. this is a format issue.

Due to the alignment, one extra blank line is appearing in the table.

Any idea, how we can solve this problem?

-------------
Thank you
Regards,

Gowtham Sen.

Replies:

Posted By: GowthamSen
Date Posted: 03 Aug 2009 at 12:17pm

One more update on this: When I de-select option "Keep object together" from object propertie, the blank sections are disappeared. Because, the half of the column content is displayed in the row, as it is previously a blank row.

-------------
Thank you
Regards,

Gowtham Sen.

Posted By: GowthamSen
Date Posted: 05 Aug 2009 at 12:26pm

Is there any way, we can delete the blank row and keeping column content together in the same page.

Thank you,

Regards,

Gowtham Sen

Posted By: DBlank
Date Posted: 05 Aug 2009 at 12:38pm

I have nt really followed your post but you can suppress blank detail rows by going into the Section Expert, selecting the Detail section and mark "Suppress Blank Section" as TRUE (checked).

Posted By: GowthamSen
Date Posted: 05 Aug 2009 at 1:10pm

Hi DBlank,

Its not exactly blank row. This option is already selected.

The row data is available. But As I selected the object property "Keep objec together", for the last record in the data section, its creating a blank row and the entire content of that row is displayed in the second page.

For example, we are having a coulmn "Sample". Which is having width of 5. And the object content for 5 rows are as follows

Sample

-----------

1213

345

11232109dflj

sfsdkjoerl

abcdedfghijklm

So, when we display this data in data section, the section would be like this.

------ In Report ----

Sample

---------

1213

345

11232

2109d

flj

sfsdk

joerl

abcde

dfghi

jklm

So For example, Let's say the first rows are fit on the first page. And the fith row is half fit in the first page and rest will go to the second page. (When deselected the option "keep object together")

Then the report looks like this.

--------------------------------------

------ FIRST PAGE -----

Sample

---------

1213

345

11232

2109d

flj

sfsdk

joerl

abcde

------ SECOND PAGE -----

dfghi

jklm

When we selected the option "keep object together", then the report would look like this.

------ FIRST PAGE -----

Sample

---------

1213

345

11232

2109d

flj

sfsdk

joerl

------ SECOND PAGE -----

abcde

dfghi

jklm

Here I would like to avoid this blank row. As I am using a box, to display data in a table, the blank row is visible.

Thank you,

Regards,

Gowtham Sen.

Posted By: augustine96
Date Posted: 06 Aug 2009 at 4:44am

this link willl helps u ppl a lot
http://codesforprogrammers.blogspot.com/search/label/How%20to%20suppress%20blank%20row(s)%20in%20detail%20section%20of%20the%20report%3F

Posted By: GowthamSen
Date Posted: 06 Aug 2009 at 9:48am

Thank you augustine96.

I have gone through the link. But I didn't find any solution for the scenario which I explained.

-------------
Thank you
Regards,

Gowtham Sen.

Posted By: GowthamSen
Date Posted: 10 Aug 2009 at 3:44pm

Hi, One update on this.

I tried to create a sample report to replicate the issue in a new report. But this case didn't occur and the blank rows are not created.

It seems, the issue is specific to some reports. I checked the properties of Box, objects and Sections. All the properties are matching with the sample report which is displaying data as expected.

Except that in the original report there are many sub reports included.

-------------
Thank you
Regards,

Gowtham Sen.

Posted By: GowthamSen
Date Posted: 18 Aug 2009 at 8:04am

Hi All,

I got the resolution for this problem.

There is one option which needs to be selected in such cases.

File --> Report options ---> Respect keep Group Together on First Page

-------------
Thank you
Regards,

Gowtham Sen.