Crosstab report design

0

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

gberdugo_1's picture
Joined: Jan 15 2013 - 2:06pm
Last seen: 6 years 7 months ago

2 Answers:

0

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

oesina's picture
225
Joined: Jun 20 2011 - 10:27am
Last seen: 6 years 1 month ago
0

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

 

gberdugo_1's picture
Joined: Jan 15 2013 - 2:06pm
Last seen: 6 years 7 months ago

Hi Gustavo.
You need to enlarge your report size.
Increase the width of your report page then it will come to row total page.

bschundawat143 - 6 years 1 month ago
Feedback
randomness