Databand Counting Problem »

[mkarthick]

 Databand expands for upto 24

 and note that it is affected by page header TextItem (25 Customer)

 and then the databand continues with sl_no 26

 how to rectify it..?

[solomon78]

You need to adjust the height of report header, data header, data e.t.c in your retailsales.lrxml file so that it can print in a page. The column of Qty should be integer not float or decimal. You also need to adjust the width of column Amt to be able to take more digits and uniform decimal points. You can also reduce the width of the product column and abbreviate the items.

[mkarthick]

It is my requirement that qty should come with decimal.
That is not my problem.
Actual thing is the serial number adds extra 1 count in next page.
It actually affects on the report header of the customer name display..
Why it is happening..?

[mkarthick]

Is there any event after databand finished printing ?

[solomon78]

27CUSTOMER Madurai and 25CUSTOMER Madurai are two different things, BILL NO 24 in a common entity between the two. The problem might has to do with query. You should use Report Header for the Bill No, the date, the customer's name and the address, using page header for the above entities will be reflected in all page you will printing, which I believe is not required on the label.

[mkarthick]

I'm adding sl variable in TextItem20 which is in the databand
It adds 1 count everytime.
Coming to the 2nd page it seems to be added extra 1 count

[solomon78]

okay, why not using $S{line("DataBand1")}?

[solomon78]

Use calculator to sum up the Amt, my answer is different from your 11309.80.

[mkarthick]

Line() works now.. Thank you..

And the sum() of the value is also correct..

Gross Amount + Round Off = Net Amount

[solomon78]

How do you connect to limereport? Are you using Qt?

[mkarthick]

Yes

[solomon78]

Please share me your code on how you connected Qt to Lime Report, I only need that part including the query. This is my email: solorea1@gmail.com, Thanks in advance

[mkarthick]

My humble appologies to you..

I'm working with java script only

Connections and queries are built in .exe

and I use it to develop further applications