A little maths should sort you out. The attached creates a unique id for each feature, then using the floor function puts every feature into a group of 500 features. You then use that attribute group id as part of your sheet name so that you can fanout sheets by groups of 500.

Hope that helps, Dave

assigngroupsof500.fmw

Thanx Dave!

One Question again...

I want to insert a fixed line (with fixed attrbs) on first line on first sheet under the column row

but only on the first sheet!

like this

how can I do this?

Greetz

Franco

So, 501 records is allowable on Sheet1 or must it be 500 including the fixed record?

You could do it like this, Creators allow you to send the feature before the main flow. If this doesn't work you could perhaps sort the features.

assigngroupsof500.fmw

i have a column line also.....(component, Nominal Diameter,....)

Franco

thanx dave ids start at 1 and the insert line id is 0

Greetz