Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Suppress Line Post Reply Post New Topic
Author Message
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Topic: Suppress Line
    Posted: 13 Nov 2007 at 2:45am
Hi
 
Can anyone tell me how can I suppress Line appearing on new page.
 
Scenario
 
I have a report which have two details section, I have inserted a horizontal Line in details b section ,I want to suppress all the lines which appear on top of details a section of new page...... is their a way to do that...
 
 
Thanks
Rahul
 
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 14 Nov 2007 at 10:29am
I'm not entirely certain what you are asking here.

You have two details sections, A and B.  They might look like:
Originally posted by Details A


{SomeData1}
{SomeData2}
{SomeData3}

Originally posted by Details B


__________________________
{OtherData1}
{OtherData2}
{OtherData3}


Yes?

Now, there are several possible scenarios:

A and B are on the same page entirely.  Print the separator line.

A spans a page break.  Print the separator line?

B spans a page break.  Print the separator line?

A page break comes exactly between A and B.  Suppress the separator line.


How does that look?  Is that more or less what you're trying to achieve?


IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 15 Nov 2007 at 5:32am
Hi Lugh
 
What I meant was section a finished on page and scection B starts on new page so when it does that I want to supress the line for first record
 
E.g.
 
Section a  1234
Section b________
Section a  1234
Section b________
 
one page
 
Next page
 
section b____________ so I want to supress this line only
Section a 1234
Section b ___________
 
Rahul
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 15 Nov 2007 at 6:08am
The classic solution for this problem is to use a global variable.  Declare a global variable, and initialize it to 0.  In section Details A, set it to 1.  In your page header, set it to 0.  In section Details B, set the conditional formatting to suppress the line if the variable is 0.

The only way the variable can be 0 is if a page header has been printed between Details A being printed and the condition on the line in Details B being checked.  I.e., if Details B is at the top of a new page.

Note that it is important to specify WhilePrintingRecords in each of the formulas where you set the variable.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 15 Nov 2007 at 7:15am
Not Clear friend ..... It is supressing my entire details B section ......
 
 
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 16 Nov 2007 at 7:14am
Huh.  I learned something new here.  Lines don't support conditional formatting.

Okay, we have to get tricky with it.  Instead of a line, create a text box.  It will have no text in it.  In the format dialog, go to the Border tab.  Put a condition on the Bottom border to show crSingleLine if the variable is 1, or crNoLine if the variable is 0.

This should create the effect you are looking for.


IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 20 Nov 2007 at 5:44am
Thanks .............
 
It works............
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 20 Nov 2007 at 8:06am
OPPS TOO early.... to reply still not working....
 
 
Still printing the line at top.........
 
 
 
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.016 seconds.