Custom Paging Issue 2

[CodingIsFun]

Hi all experts:

I am trying to get some custom paging to work. I have taken over this project from someone else and do not work with crystal reports alot so parden my terminology.

The custom paging I need is the following:

The initial page could be as many pages it wants to be within its own section.

I have a page break on the next section which can be 1 to many. Meaning if I have 5 of these sections they all need to start at page 1 again and represent the total pages for the individual section. The following should help:

-------------------------
first section
-------page 1 of 1-------
-------------------------
section 2 item #1
--------page 1 of 2------
section 2 item #1 next page
--------page 2 of 2------
-------------------------
section 2 item #2
--------page 1 of 1------

The current formula is giving back all sorts of wierd numbers:

NumberVar PassengersCount := {FaxData.PaxCount};
NumberVar customTotal := (TotalPageCount -1)/PassengersCount;
if(PageNumber = 1) then
"Page " + totext(PageNumber,0,"","") + " of 1"
else
"Page " + totext(PageNumber-1-((groupNumber-1)*customTotal),0,"","") + " of " + totext(customTotal,0,"","")
)

As I mentioned this is not my code and I'm a noobie when it comes to crystal reports and formula work

Any help with this would be greatly appreciated.

Thanks in advance...

 

[lbass]

Instead of referring to "sections", you need to specify whether you mean group header #1, group header #2, details, group footer #2, group footer #1, report footer, etc.

You might be able to use page N of M and reset the page number within a specific group, but I can't tell without more information.

Also it is important to explain whether there are any subreports being used. I'm assuming that the page numbering is in the main report.

-LB

 

[CodingIsFun]

Here are the elements you are referring to:

First Section
Report Header a, Report Header b, Report Header c, Page Header a... All Page headers until the Detail Sections.

Second Section
Details a, Details b and Details c

The group footers are all empty

Does this help? I think resetting the N of M for the detail Section is the way to go, but the M needs to only represent what is in the detail area.

How do you reset the N of M.

Thanks for the help

 

[lbass]

Go to the section expert (right click on the gray area to the left of the report canvas or depending upon your version, go to format->section or report->section expert. Select the higher order detail section (not the detail_a, _b,_c_)->check "reset page number after". This assumese that you have "new page after" set for the same higher order detail section. Then go to the field explorer->special fields->Page N of M and drag it onto your report.

-LB

 

[CodingIsFun]

ibass:

That worked well, but the person who made this originally has certain components visible for the first page based on the page number. So when I reset the page numbers using the section expert these elements appears in the detail portion. I can not change the format of the visibilities there is too much involved and requires me to make database changes which I do not have access to do.

So, I how can I recognize when the page is within the detail, so I can overide the text? And how can I find what the paging elements are for the detail group? Is this even possible?

Thanks again for all your help.

 

[lbass]

It seems to be that it would be much simpler to use the section formatting that I suggested and then for the conditional suppression based on the first page, create a formula to be placed in the page header or page footer:

whileprintingrecords;
numbervar pageno := pageno + 1;

Then in the suppression formatting that you mention, if the conditional formatting orginally was:

pagenumber <> 1

...then, instead use:

whileprintingrecords;
numbervar pageno;

pageno <> 1

-LB

 

[CodingIsFun]

There are ~386 header elements with their suppression controlled by datatier flags, which I cannot change. In this case I prefer not to change this because all the logic works at the moment. For this particular report Im willing to take the easiest route, not neccessarily the best, because my boss is growing very impatient.

If your telling me it cannot be done within a formula then I have to break the bad news about deliverables, you guys are the experts not me. I don't quite like the lack of flexibility of crystal but what else is there .

Are there individual group element variables I can leverage within the detail section.

 

[lbass]

I'm not saying there is no other way. If you explain what your groups are, we might be able to adapt the original formula. I'm assuming that there are multiple details within each group, is that correct? By that I mean that if you unsuppressed the group headers, you would see more than one detail_a per group.

It might help if you provided some sample data, including groups (even if not displayed).

-LB

 

[lbass]

Actually I'm a little confused by your layout, and in reviewing my earlier suggestion, I think I should have said for you to format a new page after for the higher order detail section, but to reset the page number after the group footer. I'm assuming that you have a group that clusters sets of details together, with each set of detail_a,_b,_c on a separate page.

When you are referring to the suppression based on page number 1, it sounds like you are saying there are hundreds of detail fields suppressed if they are not on page 1. This sounds very odd.

Another oddity: If you have clusters of details without displaying any group headers or footers, there would be no apparent break between groups. The report header section only appears at the beginning of the entire report.

If you want more help, you should be sure to identify the exact sections of the report by using the labels in the gray area to the left of the report: PHa, PHb, GH1, Da, Db, etc., and also supply sample data.

-LB

 

[CodingIsFun]

I would like to start out, with saying you have been a great help -LB. I will do my best to give you all the labels.
Yes, I agree this was done poorly/oddly, but I try not to talk about other's programing work that way. Im trying to hang on to the positives . At this point everything in the report works correctly except for the page numbering, which is broken in production and no one has noticed yet. Until I pointed out that the numbering was wierd and I asked if the client wanted it that way.

Okay here it goes:
RHa, RHb, RHc
PHa, PHb, PHc, PHd
GH#1a, GH#1b,GH#1c (GH#1a is never suppressed)
GH#2
DetailsA(has insert page break before in the section expert)
DetailsB
DetailsC
DetailsD
DetailsF
DetailsG
DetailsH

The footers are all empty except for the Page Footer which has the Custom Paging element

What I need to be able to represent with the paging is as follows:

When the detail sections are rendered they need to have their own Page Numbering starting at 1 and ending with the #of pages within that one detail section. The detail sections are basically the end of the page because there are no footers except for the numbering.
What makes this more complicated is the fact that some elements are suppressed based on the Page number being == 1.
Not my choice, but again it works so I would prefer not to change any of that logic. Which leaves me with the formula option. I have currently taken out the original formula becuase it really makes no sense. So currently the paging goes from 1 to N...

Some of the detail areas are supressed based on the incoming data, DetailsA is not supressed at all.

In order to help you understand better please tell me where I need to fill in the gaps.

Thanks again for all your help..

 

[lbass]

A few questions:

In what section are the fields that are suppressed using pagenumber = 1?

What is the pagenumbering supposed to be for non-detail sections?

Are there new page settings on any group sections?

Does the numbering restart for each change of Group #2? Or is it based on Group #1?

-LB

 

[CodingIsFun]

1) Page header b,c,d and it is > 1 not ==
2) Page numbering is normal for non detail.
3) No new page settings anywhere
4) I would like it to start for each change of Group #2, currently there is nothing.

 

[lbass]

The following appears to work in a mock report. First go to the section expert and highlight GH#1 and check "New page before". Then highlight GH#2->"new page before"->x+2 and enter:

{table.group#1field} <> previous({table.group#1field})
//substitute the field you are grouping on for Group #1

You already have new page before set for the higher order detail section. Then create the following formula and place it in the page footer:

whileprintingrecords;
numbervar pageno;
numbervar grpcnt;
numbervar cnt := cnt + 1;

if onfirstrecord or
{table.group#2field} <> previous({table.group#2field}) then
(
pageno := 1;
grpcnt := 1
) else
pageno := pageno + 1;
if cnt >= 2 then
grpcnt := count({table.group#2field},{table.group#2field});
if {table.group#2field} <> next({table.group#2field}) then
cnt := 0;

"Page " + totext(pageno,0,"") + " of " + totext(grpcnt,0,"");

-LB

 

[lbass]

Correction: The conditional formula for new page before on the GH#2 should be:

{table.group#1field} = previous({table.group#1field})

-LB

 

[CodingIsFun]

I will try that tonight, I was side tracked with one of my other projects.

Once again thanks for your help.