gberdugo_1

Hello again. I managed to get the crosstab working, now I have only one doubt: I have configured a Row Group Total to show the sum of the cost price for every supplier and show it by the end of the crosstab, this is working great. But if the report contains more than one page (due to a big list of itens), i need to show the sum on every page. Something like this: -------- Page 1 ---------------- Itens Supplier A Supplier B Code Quantity Unit Price Cost Price Total Price Unit Price Cost Price Total Price Item A 1 1 0.5 1 1.1 0.6 1.1 Item B 2 1 0.3 2 1.2 0.7 2.2 Total: 2 Itens Sub-total 0.8 3 Sub-total: 1.3 3.3 ------------ Page 2 ------------- Itens Supplier A Supplier B Code Quantity Unit Price Cost Price Total Price Unit Price Cost Price Total Price Item C 2 2 1.5 4 2.1 1.6 4.2 Item D 2 3 1.6 6 1.9 1 3.8 Total: 2 Itens Sub-total 3.1 10 Sub-total: 2.6 8.0 I could not find any property on the crosstab that allows me to print the row total per page. Is it possible to do this? Thanks again! Gustavo

Hello everybody, this is the first time that I'm using crosstabs and I have a doubt about how design the following report: Itens Supplier Name Supplier Name Code Quantity Unit price Cost price Total price Unit price Cost price Total price 00.0001 1 $1.00 $0.50 $1.00 $2.00 $0.80 $2.00 00.0002 2 $0.50 $0.10 $1.00 $1.50 $1.00 $3.00 Total: 2 itens Total price $0.60 $2.00 Total price $1.80 $5.00 As you can see, I have a report that groups itens by supplier. The fields code, quantity, supplier name and prices comes from a List of JavaBeans. I have created a crosstab with the two row groups (code and quantity), one column group (supplier name) and three measures (unit, cost and total prices). I tried to use the total by code variable to print the sum of the cost price column but it wont work. Is this the right aproach or there is another way to do this report? Thanks for your help! Gustavo Berdugo