one record per page 1

[abhishekpant]

hi all,
I want to print one record per page .i have a group of customer homecountry
usa has 2 customer so my first page will be like this
like..

customer name first name
usa
usa motors abhishek

next page
customer name first name
allen motors allen

and when the record for usa finishes then the record for the follwing country follows in the same way
like
if canada have 5 customers then it will have next five pages for all its customers
and the page number also changes with the county name that is if usa have 2 customer than at the page footers it shows 1 of 2,2 of 2 and when the records for canada starts the page number are like 1 of 5 ,2 of 5 and so on...

can anyone help

 

[synapsevampire]

Place the fields in the details and then right click the details section on the left side and select format section.

Now select New Page After and close it

Now Select Insert->Group and select the Country field.

Now right click the Country group and select format section->reset page number after

-k

 

[lbass]

And then of course insert the Page N of M function from the field explorer->special fields.

-LB

 

[abhishekpant]

i tried what synapsevampire told it worked fine and i did the same as lbass told of the page number but it didnt work.it did work for the first record as the first country has only one customer so it show 1 of 1, but the second country has 6 customer so on the first page it shows 1 of 1 and on the next it show 1 of 6. and so on till 6 of 6 and on the sixth it include the name of another country ..

 

[lbass]

You should have "new page after" checked for the group footer, and have the "Reset page number after" checked only for the group footer. For the detail section, if you want the group footer on the same page as the final detail for the group, go to details->new page after->x+2 and enter:

{#cntwingrp} <> count({table.field},{table.groupfield})

//where {#cntwingrp} is a running total that uses a count of a recurring field, evaluate for every record, reset on change of group.

You probably also want to put a formula in the new page after formula area for the group footer:

not onlastrecord

...so that you don't get a blank last page.

-LB

 

[abhishekpant]

I TRIED THIS BUT IT GIVE THE SAME PROBLEM WHICH I WAS FACING EARLIER

 

[lbass]

Yelling will get you nowhere fast--it will drive away potential respondents.

I tested my solution, so I know it works. I think you should check the section expert and report back with your settings for each section. Please explain what you mean by the same problem you were facing earlier. Do you mean that the numbering is odd?

Please also report back whether you have any conditionally suppressed groups.

-LB

 

[abhishekpant]

hello,
i am very sorry lbass and others too, if my post was looking as i was yelling pardon me for that please.........

number of pages things works of few countries but in some case which have customers more than one it gives problem suppose if the country has 6 customers than on the first page it shows 1 of 1, and next page it shows 1 of 6, so it also take the customer of next country.

 

[lbass]

Please provide the information I requested in my last post:

1-check the section expert and report back with your settings for each section--page header, group header, details, group footer, page footer.

2-Please also report back whether you have any conditionally suppressed groups.

-LB

 

[abhishekpant]

thanks for your help,
I did all the steps carefully and correctly ,you told and able to get the result this time...

thanks a lot for your help