Maximum size of an advanceddataband

Etienne Jacquet

Hello,

I explain to you the problem. It might be something easy but I didn't manage to find how to do it.

Our customer is printing his invoices a pre-printed paper, with all the column and everything. I need to limit the size the advancedataband with the rows of the invoice so it will fit in the pre-printed paper and I will have a free space at the bottom of all pages (only the last pages should have the tax and total).

I tried with the can grow function on false but I cant manage to limit the size of the data band and when there are two pages, the rows are going too far in the document. For your information, I started from the Fr standard layout.

Thanks in advance for your help.

Etienne

Philipp Knecht

Hi Etienne

You can limit the dynamic space with the PageHeader and PageFooter - Element. Everything between will then be used by the Advanced Databand.

hth

Etienne Jacquet

Hi Philipp,

Yes, it is working like this and I did use it to limit the dynamic space.

However, I have still a problem because the footer of all the pages have to be blank but not for the last one where there should be the VAT sum for each VAT code and the total.

It seems that it is not possible to put databand in the PageFooter so, I can't get the sum by VAT code which is coming from DocumentVatSum Data band of the standart layout.

I even tryied to display the footer only when PageCount > PageNumber so I could have the good footer on the last page but it doesn't work neither (it is creating one page more or no break depending of the size of the PageFooter)

I don't know if the request is clear enough but I can give you some exemples in PDF.

Thanks for your answers.

Etienne Jacquet

Philipp Knecht

Hi Etienne

I've attached an SampleFooter for you.
I hope you get the idea.

hth

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-file-uploads/philipp/SampleVATFooterLine.txt]SampleVATFooterLine.txt[/url]

Etienne Jacquet

Hi Philipp!

Thanks for the script, I used it and now it should be good, I can have the VAT details without data band.

Regarding the script you gave, I have one more question. I tried to use the same idea for the serial number to have all the serial number in line and not in columns :

Serial1, Serial2, Serial3

Instead of :

Serial1
Serial2
Serial3

I used the script like this :


If Engine.IsDoublePass Then
Dim sn As System.Data.DataTable= Engine.Objects("DocumentRow.DocumentRowSerialNumbers")
If sn.Rows.Count > 0 Then

For i as Integer = 0 To sn.Rows.Count - 1
SerialNums.value = SerialNums.value & " " & sn.Rows(i)("IntrSerial")
Next

End If
End If

I create a detail in the data band "DocumentRow" where I put the text "SerialNums"

But it doesn't work for me. The value of the text box doesn't change. Is there something wrong with the scirpt?

Thanks in advance.

Philipp Knecht

Hi Etienne

Use the script from thread:

http://www.coresuite.ch/index.php?id=48&L=&tx_mmforum_pi1[action]=list_post&tx_mmforum_pi1[tid]=42&tx_mmforum_pi1[page]=1#pid2030

And fill the textbox in both passes. Elsewise you'll get 2 different rendering results in first and second pass which is bad for pagesums, etc...

hth