How to display word 'Continue' 1

[foru11]

Hi all,

I am using CR 10 and data source is from XML file.

I have requests from user as below,
a) the report is currently group by invoice number. If the invoice number having details that will print to second or third page, user would like to have the word 'Continue' on page 1, page 2 etc. The word should not display at the final page of the group invoice number.

b) is it possible to limit the number of lines print at Details section?

Thanks in advanced for help.

 

[crystalkiwibruce]

If InRepeatedGroupHeader then "Continued"

Place in Group Header section and set that section to "Repeat on New Page"

Alternatively, if in Page Header Section...
if {Table.InvoiceNo}=Previous({Table.InvoiceNo})
Then "Continued"

InRepeatedGroupHeader only works in a group header section.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[foru11]

Hi Bruce, thanks for replying so fast.

InRepeatedGroupHeader will print at second page. But if I would like to print at the bottom of 1st page? Which method should I use?

I have tried the alternative way suggested, but that giving me a problem that it will only print after the last line of records. Meaning it will print at second page too. I put the function at GF1a. I can't set this to Print at bottom because I have another info need to be printed at the bottom of the page (also at GF1b).

User would like to see the word 'Continued' at the bottom of 1st page.

Thanks.

 

[lbass]

Use the following formula in the page footer:

if {Table.InvoiceNo}=Next({Table.InvoiceNo}) Then
"Continued"

To limit the number of records in the detail section, insert a running total that does a count of any recurring (non-null) field, evaluate for each record, reset on change of the group. Then go into the section expert->details->suppress->x+2 and enter:

{#yourrunningtotal} > 5 //or whatever number of records you want displayed per group

-LB

-LB

 

[foru11]

Thanks for replying LB.

I have tried on the number of records limitation function. I put {#yourrunningtotal} > 4, it displays 4 records on 1st page, but the remaining it is not display on 2nd page. Is there anything I've done wrong?

 

[lbass]

Are you trying to limit the details to 4 records per page? Or 4 per group? Please describe the report set up a little more, explain what you want to limit to four records, and explain how the results you are getting are different from what you would like to see.

-LB

 

[foru11]

I am trying to limit to 4 records per page for the details section.

The report is group by invoice number. The report will show detailed description for the invoice number. The page number will reset when the invoice number is changed. Invoice number is a parameter pass by selection screen.

The limit is needed because user don't want the records to be too close to the bottom of the page when there is more than 1 page of records.

The limit can work in this case because at 1st page it will show only 4 records but the fifth records onwards, I would expect it to show at 2nd page but it is not being displayed on 2nd page.

 

[lbass]

Try a formula like this in the section expert->details->new page after->x+2:

remainder({#rt},4)=0 and
{table.invoicenumber} = next({table.invoicenumber})

-LB

 

[foru11]

Thanks LB. The result is exactly what I'm expecting.

Appreciate much for your help.