Crosstab formatting

Is there anyway I can get the crosstab to format as below:

Customer Name
Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09 Oct-09 Nov-09 Dec-09
Last, First (customer name here)
**** **** **** **** **** **** **** **** ****

I tried creating a table with customer name column in one detail row and the second detail row crosstab, but that didn't help. Is there any way I can have a crosstab with customer name in an entire row and then the measures on the below row?

Also, if I want to give the user an option (using report parameters) to sort either by name or total amount (sum of all the months), how do I do it? Sort Key expression on crosstab didn't quite work for me.

Thanks.

Find more posts tagged with

Comments

mwilliams

Hi jyol,

What version of BIRT are you using? Are their going to be multiple customers in your report? Or will the above be the entire report? 1 customer? Let me know.

jyol

Hi, thanks for responding.

I'm using BIRT 2.5.1 (designer version="3.2.20" from the report design)

I have multiple customers and for each customer, I need to have the customer name on one row and the #s in the next row.

Also, any idea about sorting based on report parameters or any other way based on user's selection?

Thanks.

mwilliams

jyol,

You could embed crosstabs into a grouped outer table, grouped on customer with 4 group header rows and hide the "measure" elements in the 2nd row and the "dimension" elements in the 4th row. You'd put customer name in the first row and fullname in the 3rd row. Then, you'd use a filter on the crosstab's to allow the data for each customer to be shown. You may have to do a little formatting on this as the crosstab cells you hide the elements from will still show. Let me know if you have questions.

jyol

Is it possible for you to provide a sample for this?

Thanks

mwilliams

jyol,

This is what I described. You'll probably want to do some extra formatting and some modifications if this isn't exactly what you're looking for, but this might help get you started. Let me know if you have questions.