Click here to Skip to main content
15,898,134 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I Want this Type of Bill…
If Product is Max then Total amount on next Page … and one page product is 10. total amount show Page Footer Area


Product Qty MRP Total
Sony Xperia mini pro 1 12500 12500
Xperia P 2 22500 45000
Samsung Grand 1 17500 17500
Samsung Core 1 12000 12000
Micromax sd4356 2 6500 13000
XOLO we5332 1 9500 9500
Lenovo cs34 1 14600 14600
Lenovo s434 1 11500 11500
LAVA X1 1 6500 6500
LAVA X2 1 7500 7500
Total : Bill Continue on next page



Product Qty MRP Total
Xperia Z 1 40000 40000
Xperia E 1 10500 10500
Samsung g4545 1 11500 11500
Samsung sd434 1 12000 12000






Total : 223600
Posted
Comments
[no name] 15-Sep-14 7:49am    
just to make the question clear , you need show bill total amount in the last page and for other pages before it show this text Total : Bill Continue on next page
[no name] 15-Sep-14 8:09am    
check my solution below for this scenario , if you require something else please clarify

1 solution

consider @Total = Qty * MRP

add a formula to your report and check for current page as follows


if PageNumber >=1 and PageNumber < TotalPageCount
then "Total :   Bill Continue on next page  "
else
"Total :    " + totext( Sum ({@Total}))
 
Share this answer
 
Comments
dhanaji kumbhar 16-Sep-14 4:12am    
Thanks Boss... My Problem is Solved...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900