Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to print one data of a group in a page

Status
Not open for further replies.

abhishekpant

Programmer
Dec 21, 2004
38
US
i have a data which required to print per page i.e
i have a group of countries on the report. i want to preview one country name per page that include the list of customers in that country.and the page number is set according to the country. if a country have 5 customer than it shows the total number of pages as 5 . i want the report like
for example .usa has two customers usa moters and aleen wholesale.
customer name contact first name
USA
usa moters john



1 of 2
_______________________________________________________________________________
customer name contact first name

aleen moters allen




2 of 2
___________________________________________________________

and similarly for all the countries so if the next country has 5 customer than it has five pages and the pages are like 1 of 5, 2 of 5 ............

can anyone help?





 
You could use a summary total to find the total number of customers for a group (country). And then a running total that increases by 1 for each customer. You can put this as if it was a page number, and it is a simpler fix than manipulating the actual page numbers.

Right-click on a field and choose Insert to get a choice of Running Total, Summary and Grand Total. Or else use the Field Explorer, the icon that is a grid-like box.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
And then a running total that increases by 1 for each customer. You can put this as if it was a page number, and it is a simpler fix than manipulating the actual page numbers.?

i really didnt understand this part can you please simplify this part
 
Hello,

In the section expert, for your country group footer check new page after and reset pagenumber after.

Dana
 
Since you did not mention what Crystal version you have, I'll mention that I use Crystal 8.5 and ianoctdec's solution worked as you requested.

-LW
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top