I have created a report using the wizard based on two tables - Purchase Order and Purchase Order Detail.
The sections of the report are the normal headers / footers but also a PurchaseOrder_PurchaseOrderID header, which I assume is something to do with a subreport being set up.
I want to add a subtotal field and it would look like the best place for this is in a new footer (PurchaseOrder_PurchaseOrderID Footer)
This is not displayed however - How can I add this to my report?
Also ,judging by some of the posts I have searched I envisage I may also get a problem with the subtotal (ie get a #error) is there also a way round this.
Should I be including someting in the tables so the wizard automatically enters the footer and subtotal?
Many thanks
The sections of the report are the normal headers / footers but also a PurchaseOrder_PurchaseOrderID header, which I assume is something to do with a subreport being set up.
I want to add a subtotal field and it would look like the best place for this is in a new footer (PurchaseOrder_PurchaseOrderID Footer)
This is not displayed however - How can I add this to my report?
Also ,judging by some of the posts I have searched I envisage I may also get a problem with the subtotal (ie get a #error) is there also a way round this.
Should I be including someting in the tables so the wizard automatically enters the footer and subtotal?
Many thanks
