Writing Results to the Template

[drunkenneo]

i have to write a result of the query to the excel, which is a invoice template where i need to enter the data.

Depend on the result the template can grow in size also, here if the size grows there needs to be informatin coming on first page for eg: address in first page should not repeat in second page, second page have purly order details and footer at the end which have signatue and attestation.

Problem is data can be in 1 page, 2 pages, 3 pages ..or more

How can i achieve this task as all pages have water mark as page 1, page 2...sand so on...?

(A Sample i have attached)2013-xxxxx ABC - DEF.zip

[rpeare]

ummm... why wouldn't you just create this invoice in MS access rather than exporting to an excel file?

[drunkenneo]

I would but i need to know how can i expand and break according to the lines entries, does it looks same as excel template which it is given?

Also there are 20 different types pf template which need to be worked upon.

[rpeare]

There's nothing on your example invoice, but if you are correctly collecting the data (a good normalized structure) there is no reason you can't slice and dice it however you want. I do not know what you mean in your previous post. If you're talking about sorting your data in a particular way for a report (invoice) you can do that, if you're talking about putting in subtotals for certain sets of items, you can do that, if you're talking about putting in forced page breaks you can do that too.

[drunkenneo]

There's nothing on your example invoice, but if you are correctly collecting the data (a good normalized structure) there is no reason you can't slice and dice it however you want. I do not know what you mean in your previous post. If you're talking about sorting your data in a particular way for a report (invoice) you can do that, if you're talking about putting in subtotals for certain sets of items, you can do that, if you're talking about putting in forced page breaks you can do that too.

The point youmentioned is exactly what i need, could i have bitmore elaborate on the logical paet which u said, so it will b a light on my way