Does cross-tab component work within a group band for the data being grouped?
Lets say I have 1 datasource that contains a list of all product orders that includes the customer id/name, the Product and it's category.
I want to group the datasource by customer. In the group band I want to show the customers name and a summary of all their product orders.
The summary should be displayed in a cross tab with the rows set to Category, the Columns set to Product, and the Summary set to product count.
So the cross tab should be displaying a breakdown of category/product count per grouped customer.
I've tried placing a cross tab into the group band but it seems to apply to the entire datasource and not the grouped filter.
I've also tried setting the cross tab filter to the current customer ID being grouped but the same thing applies.
Currently what I have done is created a new Datasource based on other datasource. Made this to be a list of grouped customers with a relation to the main data source and a relation in the main datasource back to the grouped customer data source. Then I made a master-detail report based on this info using the cross-tab in the master with the relation set.
Cross-Tab and Group Band?
Cross-Tab and Group Band?
Hello,
Unfortunatelly you can't place Cross-Tab on GroupHeaderBand. Main problem is how work GroupHeaderBand. This band does not create any special list or arrays with groupped data. Report engine only output GroupHeaderBand and GroupFooterBand in required places. In result you will receive result for full list of rows.
Thank you.
Unfortunatelly you can't place Cross-Tab on GroupHeaderBand. Main problem is how work GroupHeaderBand. This band does not create any special list or arrays with groupped data. Report engine only output GroupHeaderBand and GroupFooterBand in required places. In result you will receive result for full list of rows.
Thank you.