Grouping needs a databand and Footers not visible
Posted: Thu Feb 18, 2010 9:28 am
We are evaluating the reports.wpf version and ran into some questions.
First our datasource is a xml-file which looks like this:
1
Order 1
...
1
1
Product 1
...
1
1
Calculation 1
...
2
1
Product 2
...
1
2
Calculation 1
...
2
Order 2
...
3
2
Product 3
...
2
3
Calculation 2
...
3
3
Calculation 3
...
When I set the Datasource, I noticed that there where automaticaly added some ID-fields for relation purposes.
I am using these ID-fields for groupings.
Now I am trying to create a report which will create for each Order a page.
So this is what I created:
Attempt 1:
[GroupHeaderBand1 -> Cond: Order.Autogenerated_Order_id] --> pagebreak-options: newPagebefore, skipfirst
[GroupHeaderBand2 -> Cond: Product.Autogenerated_product_id]
[GroupHeaderBand3 -> Cond: Calculation.CalculationID]
[Databand 1 : Calculation]
[GroupFooterBand3]
[GroupFooterBand2]
[GroupFooterBand1]
Result:
Now a report is generated with 1 order, 1 product, and all the calculations
All groupfooters are visible.
Attempt 2:
I added a Product Databand like a master-detail
[GroupHeaderBand1 -> Cond: Order.Autogenerated_Order_id] --> pagebreak-options: newPagebefore, skipfirst
[GroupHeaderBand2 -> Cond: Product.Autogenerated_product_id]
[Databand 1 : Product]
[GroupHeaderBand3 -> Cond: Calculation.CalculationID]
[Databand 2 : Calculation]
[GroupFooterBand3]
[GroupFooterBand2]
[GroupFooterBand1]
Result:
Now a report is generated with 1 order, All products with their calculations
Only GroupFooterBand3 is visible after each Calculation.
Attempt 3:
I added a Order Databand like a master-detail
[GroupHeaderBand1 -> Cond: Order.Autogenerated_Order_id] --> pagebreak-options: newPagebefore, skipfirst
[Databand 1 : Order]
[GroupHeaderBand2 -> Cond: Product.Autogenerated_product_id]
[Databand 2 : Product]
[GroupHeaderBand3 -> Cond: Calculation.CalculationID]
[Databand 3 : Calculation]
[GroupFooterBand3]
[GroupFooterBand2]
[GroupFooterBand1]
Result:
Now the report is generated with 2 orders with their product(s) and their calculation(s).
Only GroupFooterBand3 is visible after each Calculation.
Questions:
1. Is it normal that there must be a databand on each grouping level???
2. Why are the GroupFooters of Band1 and Band2 not visible??
First our datasource is a xml-file which looks like this:
1
Order 1
...
1
1
Product 1
...
1
1
Calculation 1
...
2
1
Product 2
...
1
2
Calculation 1
...
2
Order 2
...
3
2
Product 3
...
2
3
Calculation 2
...
3
3
Calculation 3
...
When I set the Datasource, I noticed that there where automaticaly added some ID-fields for relation purposes.
I am using these ID-fields for groupings.
Now I am trying to create a report which will create for each Order a page.
So this is what I created:
Attempt 1:
[GroupHeaderBand1 -> Cond: Order.Autogenerated_Order_id] --> pagebreak-options: newPagebefore, skipfirst
[GroupHeaderBand2 -> Cond: Product.Autogenerated_product_id]
[GroupHeaderBand3 -> Cond: Calculation.CalculationID]
[Databand 1 : Calculation]
[GroupFooterBand3]
[GroupFooterBand2]
[GroupFooterBand1]
Result:
Now a report is generated with 1 order, 1 product, and all the calculations
All groupfooters are visible.
Attempt 2:
I added a Product Databand like a master-detail
[GroupHeaderBand1 -> Cond: Order.Autogenerated_Order_id] --> pagebreak-options: newPagebefore, skipfirst
[GroupHeaderBand2 -> Cond: Product.Autogenerated_product_id]
[Databand 1 : Product]
[GroupHeaderBand3 -> Cond: Calculation.CalculationID]
[Databand 2 : Calculation]
[GroupFooterBand3]
[GroupFooterBand2]
[GroupFooterBand1]
Result:
Now a report is generated with 1 order, All products with their calculations
Only GroupFooterBand3 is visible after each Calculation.
Attempt 3:
I added a Order Databand like a master-detail
[GroupHeaderBand1 -> Cond: Order.Autogenerated_Order_id] --> pagebreak-options: newPagebefore, skipfirst
[Databand 1 : Order]
[GroupHeaderBand2 -> Cond: Product.Autogenerated_product_id]
[Databand 2 : Product]
[GroupHeaderBand3 -> Cond: Calculation.CalculationID]
[Databand 3 : Calculation]
[GroupFooterBand3]
[GroupFooterBand2]
[GroupFooterBand1]
Result:
Now the report is generated with 2 orders with their product(s) and their calculation(s).
Only GroupFooterBand3 is visible after each Calculation.
Questions:
1. Is it normal that there must be a databand on each grouping level???
2. Why are the GroupFooters of Band1 and Band2 not visible??