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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incremental Number

Status
Not open for further replies.

BigglesUK

MIS
Jun 29, 2005
23
0
0
GB
An easy one I know but im tired and the end of the day. Using Crystal 10. I dont need any connectivity to any db either!

I just want to use crystal to make a document. Ive got to print out a list of numbers in 4 colums over several pages.

Number list starts at 25,001 and goes up to 40,000.

4 colums per page like this:

25001 250026 250051 250076

25002 250027 250052 250077

25003 250028 250053 250078

etc etc etc etc

up to 250025 up to 250050 up to 250075 up to 250100

Then another page same setup all the way up to 40000.

does anyone have a little technique how to do this please?

cheers, Andrew

 
I think you have to have a datasource, but you could just use the xtreme database. Link the orders table to the orders detail table with a < join and linking then use a record selection formula like:

{Orders.Order ID} < 1015

which will return about 50000 records in the report, if you add the order ID field and a field from the detail table to the detail section and suppress them. Then create a formula like this [@cnt}:

recordnumber + 250000

Then go to the section expert->details->new page after->x+2 and enter:

remainder({@cnt},100) = 0

Also, check "format with multiple columns"->layout->set width and gap to force four columns->check "down then across".

Then in the main report, adjust the height of the detail section until you force 25 numbers per column.

-LB
 
Thanks lb, once again your knowledge is superb.

Slightly tweeked your idea and made an excel file with the records in and used that as my datasource.

Spot on!

Andrew
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top