where is the page footer?

[kingz2000]

Hi,
is there a page footer in crystal report 10, aswell as the report footer which I seem only to see. I guess there must be alone for the summing of tables..page by page..I'm just too blind

 

[vidru]

Yes, the visible sections of a main report will always be:
Report Header/Footer
Page Header/Footer
Details

If you don't see the Page Header or Footer, it sounds like you're inside a subreport, which doesn't support the page header/footer concept.

-dave

 

[kingz2000]

Oh christ,

I have 10 subreport in one giant report..the 10 subreports are divided in header sections. so I have 10 header sections. unfortunately, the report can exceed a page, and it naturally goes over the page then..but I still need a page footer to get the total sums for that page. I sthere anway I can get around this?? In fact, I want to automatise the whole thing so that I don't even have to worry about the presentation after a certain point, but stuff like that is holding me back.

Or have I tackled the problem completely wrongly?? The report consists of 10 pages with each having its own data source.
Please help.
[even if it means directing me to a different reportmaker!]
thanks in advance.

 

[hjohnson919]

Is there a reason, like a grand total, to put all 10 reports in one? Could you print each of the 10 reports separately and just bind the paper together?

 

[kingz2000]

well, it is supposed to come together, for example, the page no. at the bottom should follow..Ok, that could be done statically..but the idea was actually to be in a position to simply load a rpt, get the 10 pages, refresh the data, and then simply print them out at once. I don't really want to load each of the 10 pages seperately and then print seperately. In fact, I was hoping to be able call crystal report externally somehow so that the reports are automatically printed at the beginning of the month. Is that possible somehow?
Currently, I am even frustrated with the constant data access to the database while flicking page by page.
I appreciate any help.

 

[lbass]

If you are okay with creating a page break after a certain number of records in a subreport, the following will work. First create a faux page header in the subreport by creating a formula that is true for all records, e.g.:

{table.ID} > 0

Then insert a group on this formula and choose "repeat group header on each page". Then suppress the group header.
Next create two formulas:

//{@reset} to be placed in the suppressed group header:
whileprintingrecords;
numbervar counter := 0;
numbervar sumamt := 0;

Insert a second detail section and place the following formula in detail_b:

//{@accum}:
whileprintingrecords;
numbervar counter := counter + 1;
numbervar sumamt := sumamt + {table.amt};

Then still within the subreport, go to the section expert->detail_b->suppress->x+2 and enter:
whileprintingrecords;
numbervar counter;
counter <> 60 //plug in your number of records per page for 60

Then with detail_b still highlighted go to "new page after"->x+2 and enter:

whileprintingrecords;
numbervar counter;
not onlastrecord and
counter = 60

Detail_b becomes your faux page footer.

-LB

 

[kingz2000]

excellent, I am happy there is a solution, but you will have to elaborate please mr. lbass!! Firstly what is a faux page with a formula table.id>0?? I don't understand..Is that in the formula fields??

 

[lbass]

In the subreport, go to the field explorer->formula->new and create a formula like the one above or use:

whilereadingrecords;
1

When you insert a group on this and check "Repeat group header on each page", you are creating a faux or fake page header. Just remove the group name and put your page header fields in it.

-LB

 

[kingz2000]

ok,nearly there guys...

I just don't understand
'detail_b->suppress->x+2'
do u mean I should supress detail_b and then create a new formula called 'x+2' where I enter:
whileprintingrecords;
numbervar counter;
counter <> 60 //plug in your number of records per page for 60
??

what exactly is x+2? excuse my novice questions. I do, however, appreciate all this. I am merely delighted there is a solution.

 

[lbass]

All conditional formula areas are identified by a button with "x+2" written on it. In this case, you would go to the section expert, highlight detail_b and then click on the x+2 button next to "suppress". This opens up a formula area where you would enter the formula.

-LB

 

[kingz2000]

Ok, I understand now, I didn't know 'x+2'was referring to the button.
However, I don't get the pagebreak at the end of my summing.The summing detail_b just writes over my existing data

 

[lbass]

I don't know what you mean. The running total sum belongs in detail_b and could not overwrite detail_a unless you formatted detail_a with "Underlay following sections"--which you shouldn't do. Did you place the formula in the new page after formula area for detail_b?

Please reread my earlier post to make sure you have followed each step fully.

-LB

 

[kingz2000]

ok, I had the wrong counter number(counter<>30)

I thought I could break the 30 datasets however I wanted, but I just set counter<>30 to get it on the last line. The problem is now, that on the 2nd page I only have the 3 remaining datasets, but I don't get the summ again. I have gone thorugh everything again..but I can't find the error!!??

 

[lbass]

Change the section suppression formula on detail_b to:

whileprintingrecords;
numbervar counter;
onlastrecord or
counter <> 60

-LB

 

[kingz2000]

i get the datasets individually on seperate pages with the above code

 

[kingz2000]

..but I see what you're trying to do, I think. If the 'mod' function was available, it should look like this,right?:
whileprintingrecords;
numbervar counter;
onlastrecord or
counter=mod(25)

So how do I get around it??

 

[lbass]

Sorry, that should have been:

whileprintingrecords;
numbervar counter;
not onlastrecord and
counter <> 30

This formula belongs in the section suppression area for detail_b. Do not change the formula for "new page after".

-LB

 

[kingz2000]

No, with that I get the individual datasets on seperate pages again.However with this:

whileprintingrecords;
numbervar counter;
onlastrecord and
counter =29

in the "new page after"->x+2

and

whileprintingrecords;
numbervar counter;
counter<>29

in the supressed section..
I seem to get everything on one page. Its just the 'page footer'(3explanatory sentences), which ends up being alone on the next page..grrrrr..*G*

I'm not sure if that helps to find a dynamic solution. After all, the 29 datasets is just for this round. Next month it could be 50 datasets.

 

[lbass]

I don't know what you mean by 29 datasets. You are using the counter to count records within the subreport. The value would not need to change with different total record counts, since you are resetting the counter on each page.

You have the formulas wrong. First, before using the formulas, you need to determine how many records fit on the page. If it is 30, then the formulas should be:

In the "new page after"->x+2:
whileprintingrecords;
numbervar counter;
not onlastrecord and
counter = 30

In the detail_b suppression x+2 area:
whileprintingrecords;
numbervar counter;
not onlastrecord and
counter <> 30

-LB

 

[kingz2000]

ah yes, i cut it to 20 lines to get a larger page footer. Now, to conclude,I don't understand why i must suppress the group header, because for the 2nd page of the list, I would like to have the same colum headings, so I presume I need to place my column names, which at the moment are in the report header into the group header section.Is that right?