URGENT : Report Layout
Posted: Wed Apr 13, 2011 9:53 pm
Hi, I got more than 10 reports with same report layout but I'm not sure is it able done with Stimulsoft or not..
so, I'm seeking yours advices here
format as below,
------------------------------------------------------------------------------------------------
| Product | Product 1| Product 2 | Product 3 | total
Date |------------------------|----------- |-------------|-------------|------------------
| Opening Balance | 100 | 150 | 30 | 280
------------------------------------------------------------------------------------------------
| Vendor | Resit No | | | |
-------------------------------------------------------------------------------------------------
1-june | X1 | X123 | | 30 | | 30
--------------------------------------------------------------------------------------------------
5-june | Y2 | Y234 | 40 | | | 40
-------------------------------------------------------------------------------------------------
15-june | Z1 | Z111 | | | 30 | 30
-----------------------------------------------------------------------------------------------
Total Received | 40 | 30 | 30 | 100
------------------------------------------------------------------------------------------------
2-june | A1 | A12 | 10 | | 5 | 15
----------------------------------------------------------------------------------------------
20-june | B2 | B56 | 80 | 100 | | 180
----------------------------------------------------------------------------------------------
Total Sales | 90 | 100 | 5 | 195
---------------------------------------------------------------------------------------------
Balance (OP + TR - TS) | 50 | 80 | 55 | 185
-----------------------------------------------------------------------------------------------
% in (TS/OP+TR) *100 | 64.29 | 55.56 | 8.33 | 128.18
-----------------------------------------------------------------------------------------------
fyi, the product 1, product 2, product 3 .... product n is dynamic grow ..
btw, the total at last column there must have Grand Total in last page.
Let said, my page just can fit 2 products in a page, but i have 5 products to show,
it will break 3 pages with columns as below
Page 1 : Date, Product & Opening Balance, Product 1, Product 2, sub total
Page 2 : Date, Product & Opening Balance, Product 3, Product 4, sub total
Page 3 : Date, Product & Opening Balance, Product 5, subtotal, Grand Total
Can your please advices me how to do it (or similar format) or attach a sample for me?
Thanks.
so, I'm seeking yours advices here
format as below,
------------------------------------------------------------------------------------------------
| Product | Product 1| Product 2 | Product 3 | total
Date |------------------------|----------- |-------------|-------------|------------------
| Opening Balance | 100 | 150 | 30 | 280
------------------------------------------------------------------------------------------------
| Vendor | Resit No | | | |
-------------------------------------------------------------------------------------------------
1-june | X1 | X123 | | 30 | | 30
--------------------------------------------------------------------------------------------------
5-june | Y2 | Y234 | 40 | | | 40
-------------------------------------------------------------------------------------------------
15-june | Z1 | Z111 | | | 30 | 30
-----------------------------------------------------------------------------------------------
Total Received | 40 | 30 | 30 | 100
------------------------------------------------------------------------------------------------
2-june | A1 | A12 | 10 | | 5 | 15
----------------------------------------------------------------------------------------------
20-june | B2 | B56 | 80 | 100 | | 180
----------------------------------------------------------------------------------------------
Total Sales | 90 | 100 | 5 | 195
---------------------------------------------------------------------------------------------
Balance (OP + TR - TS) | 50 | 80 | 55 | 185
-----------------------------------------------------------------------------------------------
% in (TS/OP+TR) *100 | 64.29 | 55.56 | 8.33 | 128.18
-----------------------------------------------------------------------------------------------
fyi, the product 1, product 2, product 3 .... product n is dynamic grow ..
btw, the total at last column there must have Grand Total in last page.
Let said, my page just can fit 2 products in a page, but i have 5 products to show,
it will break 3 pages with columns as below
Page 1 : Date, Product & Opening Balance, Product 1, Product 2, sub total
Page 2 : Date, Product & Opening Balance, Product 3, Product 4, sub total
Page 3 : Date, Product & Opening Balance, Product 5, subtotal, Grand Total
Can your please advices me how to do it (or similar format) or attach a sample for me?
Thanks.