Cross Tab with Rep + Sub Rep Inside

cesarino80

Hello,

I started my experience with BIRT few days ago and I need to do something:

I Have 3 Data set.

I used one to create a Cross Tab and the others to create a report and sub report.

I putted the report and subreport in the Cross Tab summary row. Now I would like to filter the report with a value of the Cross Tab... there is a way to do that?

I try to give you an exemple:

1 Data set with: Date, Item_ID, Number of sales in this date (Cross Table)
2 Data set with: Item_ID, Name_ID (Report)
3 Data set with: TimeStamp, Item_ID (Sub Report)

So, In the cross tab I have for each day, the total sales for each item but, in each of this row I want to have a subreport inside to display the list of the single order: date + time.

How can I take the values from the Data Cube field to use to filter in the report?

Thanks fro you help

Felix

Tianli

Hi,

You can add your sub report in ITEM_ID level area, and add a filter on the sub report like, row["ITEM_ID"] equal to row._outer["ITEM_ID"].

The row["ITEM_ID"] is the binding of your sub report, and the row._outer["ITEM_ID"] is reference to the outer binding in crosstab.