Page Break

[nikol]

How can I display my report pagewise like
I want last_names starting with "A" on page1
"B" on page 2
"C" on page 3...so on
Any help

 

[BobSuruncle]

Create a formula to extract the first letter of the last name.

Left({Table.LastName},1)

Now Create a group on this formula.

In the Section Expert, select the Group Footer for this group and click the X2 button beside the "New Page After" propery. In the formula editor, enter the following
NOT OnLastRecord




Bob Suruncle

 

[Madawc]

Note that if there is a letter missing from your list, there will be no group for it and no indication that it was missed. So if there were no names starting with Q, you'd have a page for P followed by a page for R.

If this is a problem, the best answer might be to do 26 running totals, one per letter. Then in the report footer, show whichever counts are zero.

Madawc Williams (East Anglia, UK)

 

[nikol]

Hi BobSuruncle,
I tried ur way but its giving me 1 client per page. Can u please help me. I want alphabets per page like "A" on page1 ,"B" on page2,"C" page3

thanks for ur time

 

[lbass]

If you followed Bob's instructions and inserted a group on his formula, then make sure that in the section expert you have the group footer (NOT the detail section) highlighted when you select "new page after". Remove "new page after" on the details section.

-LB

 

[nikol]

Hi Ibass,
Thanks alot.I got it.