Crosstab report design

[gberdugo_1]

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

[oesina]

Hi Gustavo,

If you used a wizard, make sure you select checkboxes to display Row Groups and Subgroups.

Since you added 3 measures it looks you already modifying the default crosstab with the crosstab design mode. Crosstab object creates all the subgrouping/grouping calculated variables for you automatically and uses names for it for example

Cost price by Code

Cost price by Quanitty

Cost price by Code/Quantity

Cost price by Code/Quantity/Supplier Name

You would need to create new text field in the crosstab summary areas pointing to those variables (not fields!).

If unsure, create a simple crosstab using wizard with a single measure and look into report inspector and the XML code.

Good luck with Crosstabs!

Olga

[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

 

[bschundawat143]

Hi Gustavo.

You need to enlarge your report size.

Increase the width of your report page then it will come to row total page.