List of crosstab

Hello,
I need to design report whitch has dynamic list - from dataset and inside is a crosstab but cell or row of list feed crosstab in other words one row list is one crosstab for one customer only but he can has more product.I just need bind list customer id to row of list and then to crosstab or something like that.Any suggestion will be VERY VERY VEEEERY HELPFULL

Find more posts tagged with

Comments

mwilliams

Let me see if I'm understanding correctly, you want to have a list of customers. Inside that list, you want to have a crosstab for just that customer that shows their products? Or something else? Let me know! Also, let me know your BIRT version so I can work in your version if a sample is needed! Thanks!

BirtN00bie

THX for replay you understand this correctly but in meantime I solved this problem soo Im done with this report.Have a nice day

mwilliams

Glad to hear! Let us know whenever you have questions! I'll post a solution anyways, for anyone else who stumbles across this thread looking for the same!

The best way to do this is to create a list or table with a grouping on "Customer Number". Then, when you create your dataCube, you'd set it up normally with the dimensions and measures you want to see in the crosstab. After you've done this, you'd select one of your dimensions and then select the "edit" button. Here, you can add an attribute field. For your attribute field, add the "Customer Number" field. This way, your customer number doesn't have to be visible in the crosstab, but you can still use it to limit your crosstab data. Finally, select your crosstab and add a filter that compares the customer number attribute to the customer number field from your outer table/list.

BirtN00bie

EXACTLY it took me 3days <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/tongue.gif as I say Im a birt noob

Brasi

just out of curiosity.. why is mwilliams post before BirtN00bie and is "Posted 02 November 2011 - 12:45 PM" but BirtN00bie is at "Posted 02 November 2011 - 10:35 PM"??

mwilliams

I see 2:45pm for my post on the 2nd and BirtN00bie's at 12:35am on the 3rd. Either it's been fixed or there is some sort of time conversion issue!

Brasi

this is what I see. 
 
<a class='bbc_url' href='http://www.freeimagehosting.net/5e285'><img src='http://www.freeimagehosting.net/t/5e285.jpg' alt='Posted Image' class='bbc_img' /></a>

mwilliams

Ha. I didn't look at the times right in your post. Those times are correct! 12:45pm is noon:45, so 10:35pm the same day would indeed be later!

Brasi

oh wow, you're right. LOL I feel silly now. sorry about that

ajay2906

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="84844" data-time="1320332573" data-date="03 November 2011 - 08:02 AM">
Glad to hear! Let us know whenever you have questions! I'll post a solution anyways, for anyone else who stumbles across this thread looking for the same! 
 
The best way to do this is to create a list or table with a grouping on "Customer Number". Then, when you create your dataCube, you'd set it up normally with the dimensions and measures you want to see in the crosstab. After you've done this, you'd select one of your dimensions and then select the "edit" button. Here, you can add an attribute field. For your attribute field, add the "Customer Number" field. This way, your customer number doesn't have to be visible in the crosstab, but you can still use it to limit your crosstab data. Finally, select your crosstab and add a filter that compares the customer number attribute to the customer number field from your outer table/list. </blockquote>
 
Hi Michael 
 
I tried the above solution for creating crosstab in a list. But when I am not getting correct result after applying the filter. My problem is I want to filter the crosstab data based on a dimension which is not added to the cube. I tried adding this dimension as an attribute field to an existing group and then use this in filter to compare with outer dimension in the list. But the filter doesn't give me proper results. 
 
Also I would like to know how should to create filter on "Detail" option in crosstab. I think this might solve my problem. 
 
Thanks 
Ajay

mwilliams

What is your BIRT version? I'll create an example showing the attribute value filter. Can you explain more about the filter on "Detail"? Are you talking of filtering a crosstab based on the measure value? Let me know.

ajay2906

My BIRT Version is 3.7.0
Please refer to the attached screenshot. When I try to create filter for crosstab then I get these three options:
1. Group level
2. Measure level
3. Detail

The first two are supposed to be used for filtering based on dimension and measures respectively. As per the documentation the last option is used to "filter based on field which is not defined in crosstab but part of the cube". I think this is what I want to do. Please let me know how to use this option, any examples would be much appreciated.

Thanks
Ajay

mwilliams

Can you show me some sample data that is from the dataSet that the dataCube uses? Then, can you tell me what the crosstab setup is? Finally, what is the dataSet that the outer list uses, like?

That'd be very helpful. If you can create flat files that represent your dataSets and use them to make a sample, with your setup already done, that'd be even more helpful! Thanks!