Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Blank lines in data section Post Reply Post New Topic
Author Message
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet Topic: Blank lines in data section
    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.
IP IP Logged
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet 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.
IP IP Logged
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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).
IP IP Logged
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet 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
 
<blank row>
 
------ 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.
IP IP Logged
augustine96
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 3
Quote augustine96 Replybullet 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

IP IP Logged
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet 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.
IP IP Logged
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet 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.
IP IP Logged
GowthamSen
Groupie
Groupie


Joined: 03 Jun 2009
Location: India
Online Status: Offline
Posts: 65
Quote GowthamSen Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.017 seconds.