Solved

Format Crystal Report

Posted on 2007-12-05
8
148 Views
Last Modified: 2013-11-26
In my Crystal Report, I have it set up like this
Section Details a
             FieldDirectorate
Section Details b
             FieldDivision
Section Details c
       TestTitle
Section Details d
      Description....

And in Section Details a and Section Details b, I format them to 'Supress if Duplicated'. My report right now looks like this

Directorate 1
Divsion 1.1
Test Title 1
Descripion 1

Divsion 2
Test Title 2
Desctiption 2

Directorate 2
Divsion 2.1
Test Title 1
Descripion 1

Divsion 2.2
Test Title 2
Desctiption 2

What I need is to insert a page break when the Directorate 2 start. but don't know how. Please help. Thanks

0
Comment
Question by:CochiseCounty
  • 4
  • 4
8 Comments
 
LVL 17

Expert Comment

by:pssandhu
Comment Utility
Right click on the Details a on the left hand side and select "Section Expert". Under section expert, check the box where it says "New page before" OR
Right click on the Details d on the left hand side and select "Section Expert". Under section expert, check the box where it says "New page after"

Hope this helps.

p.
0
 

Author Comment

by:CochiseCounty
Comment Utility
I just want new page before a new Directorate start, something like this.
Directorate 1
Divsion 1.1
Test Title 1
Descripion 1
..break...
Directorate 1
Divsion 2
Test Title 2
Desctiption 2
...break....
Directorate 2
Divsion 2.1
Test Title 1
Descripion 1
...break...
Directorate 2
Divsion 2.2
Test Title 2
Desctiption 2

If I do the way you suggest, my page looks like this

Directorate 1
Divsion 1.1
Test Title 1
Descripion 1

Divsion 2
Test Title 2
Desctiption 2
...break....
Directorate 2
Divsion 2.1
Test Title 1
Descripion 1

Divsion 2.2
Test Title 2
Desctiption 2

0
 

Author Comment

by:CochiseCounty
Comment Utility
Opps,
I just want new page before a new Directorate start, something like this.

Directorate 1
Divsion 1.1
Test Title 1
Descripion 1

Divsion 2
Test Title 2
Desctiption 2
...break....
Directorate 2
Divsion 2.1
Test Title 1
Descripion 1

Divsion 2.2
Test Title 2
Desctiption 2

If I do the way you suggest, my page looks like this

Directorate 1
Divsion 1.1
Test Title 1
Descripion 1
..break...
Directorate 1
Divsion 2
Test Title 2
Desctiption 2
...break....
Directorate 2
Divsion 2.1
Test Title 1
Descripion 1
...break...
Directorate 2
Divsion 2.2
Test Title 2
Desctiption 2
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 250 total points
Comment Utility
Under Supress if Duplicated, there is a label called Display String. Click on the formula button in front and type in "Dup".
Then go to section a, right click, click on section expert and click on the formula button in front of "New page before" and type in

FieldDirectorate <> "Dup"

Let me know how it goes.

P.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:CochiseCounty
Comment Utility
'Under Supress if Duplicated, there is a label called Display String', I couldn't find this.
0
 
LVL 17

Expert Comment

by:pssandhu
Comment Utility
What version of Crystal Report are you using?

Right Click on the FieldDirectorate field and select "Format Field". Then under the Common Tab, there whould be a check box with "Suppress if Duplicated" lablen in front. Right below there, it should say "Display String".
0
 

Author Comment

by:CochiseCounty
Comment Utility
I am using Crystal Report that goes together with Visual Studio .NET. Maybe that's why I don't have the 'Display String'.
0
 
LVL 17

Expert Comment

by:pssandhu
Comment Utility
May be! Let me have a look see.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now