Crystal Report page break and page number

[Chong]

I'm using CR in VB.NET and I couldn't figure out how to put a page break on the report design. I wasn't sure if there is such thing as page break in CR. Another thing is, I want to be able to determine where the page ends and the next page begins in design time.

If anyone knows, please help.

Many thanks in advance.

Chong

[Lunatic3]

No, you dont have such a thing called Page Break as in Access reports. Any section has a feature called "New Page After' or "New Page Before'. There you can set the desired page break.

[Chong]

Thanks for helping me out. Yes, I saw that when I right click and go to Format Section. The problem I have is, how do I set a page break if, let's say, I want to put a page break after a database field name answer1? I saw the icon with the x+2 and a pencil underneath, but I wasn't sure how to enter the formula in the Format Formula Editor.

Chong

[Lunatic3]

You want to have a page break after a special field? or based on the field value? In any case you want to have it in which section?

If you want to have a page break after a special field. lets say "ansewr1" which is located in Details section you can add another Detail section and put the fields that come after 'answer1' in that section. And set 'New page after' in the first detail section.

If you want to put a page break after a special value of a filed then you make a formula , either in Basic or CR syntax with a boolean result: for example

{answer1}="bal bal bal...";

[Chong]

It works by adding a new section after field answer1. Two more questions I have is, how would I do if I want to put a page break after the field answer1 without adding additional section? What sort of formula would I need to write? And I want to put a page break base on field value, what formula do I need?

Again, thank you very much! You've saved my day. I have been looking for the page break for the whole day today.


Chong

[Lunatic3]

For your first question:
I am afraid that wont be easy to do.

And for the formula:

It may be something like this:


{ansewer1}="something";
' or other condition to insert new page


depending on the situation you may need to put
whileprintingrecords;
or
whilereadingrecords;

before that to work.

[Chong]

Thanks! I'll keep that in mind if I ever need it.

Chong