Page footer to appear after detail secion

[krishnappan]

Once the data in the detail section is complete, i want the page footer to close right there instead of the end of the page ... could u let me know how to do that? ... i tried options like suppress blank data ...but did not seam to work ...help pls...

 

[PatriciaObreja]

You can use Report Footer section for last page, instead of Page Footer.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[krishnappan]

I have a table border that closes ...the report runs multiple pages ... in the last page if the report finishes in half of the page , i want to close the table there ... if i drop in report footer the initial pages will have a problem?

 

[lbass]

Create a formula like this:

whilereadingrecords;
""

Insert a group on this and place your page footer text in the new group footer. Suppress the group header.

Also create a formula:

//{@true} to be placed in the group footer:
whileprintingrecords;
booleanvar flag := true;

Then suppress the page footer conditionally using this formula:

whileprintingrecords;
booleanvar flag;
flag = true;//note no colon

-LB

 

[lbass]

Actually, the report footer makes most sense.

-LB

 

[PatriciaObreja]

You added the table border using Insert Box?
If so, draw the box only untill RF section, and not PF section.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[krishnappan]

I have vertical lines in the details section ... had a horizontal close line in the page footer

 

[PatriciaObreja]

Drag the horizontal line into Report Footer section.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[krishnappan]

report footer was good ...but i want to suppress the page footer if its the last page ... i am a new bee ...please give me steps ...

 

[PatriciaObreja]

If you want to suppress the Page Footer on the last page go to Section Expert > Page Footer > x + 2 and enter:

if OnLastRecord then
    true
else
    false

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[krishnappan]

Thanks a zillion PatriciaObreja and all others ....

 

[lbass]

onlastrecord will work except if the last record is one page and the report footer is on the next, you will have the last two pages of page footers suppressed, so you might want to use my flag formula--place it in the report footer and then add the conditional suppression in the
section expert.

-LB

 

[krishnappan]

I placed the following code in suppress report footer

whileprintingrecords;
booleanvar flag := true;

And the following code in suppress page footer

whileprintingrecords;
booleanvar flag;
flag = true;//note no colon

The report footer no longer appear ...could u pls explain the logic ...what is := and why = ... if some thing like global variable , why declare in both places... and could u give me pointers on any tutorial i could look for understanding this formula section ...

 

[lbass]

The first formula should be created in the field explorer and then placed in the report footer and suppressed. Please remove it from the section expert suppression area for the report footer.

The first formula sets the value using the colon, while the second formula tests the value using just the = sign.

-LB

 

[krishnappan]

Thats perfect .. but in the second formula why you are declaring the variable again

whileprintingrecords;
booleanvar flag; --why declaring it again , are we not refering to the already created variable?
flag = true;//note no colon --this is for comparison

 

[AndyMc]

krishnappan,

Crystal requires variables to be declared in every formula where that variable is used even if it has previously been declared in another formula. Note that if you were to remove the declaration and check the formula, it would error out.

Andy

 

[krishnappan]

then how does crystal differentiate between global and local variables .. if the declared variable name is the same it becomes global?

 

[lbass]

Global is the default, but you would have to identify shared or local variables. Still, you have to declare them at the beginning of each formula, as in:

shared numbervar amt;
numbervar amt; //(global)
local numbervar amt;

-LB