Hi All, first post here so hopefully I give enough information.
I have a report for generating an invoice that contains a sub-report which shows the invoice details. In the sub-report I have a textbox control for CurrentBilling which shows the billing for each item/row in the sub-report. I then used a separate textbox with Running Sum property set to Over All to get the total CurrentBilling for the invoice. I then created a textbox in the sub-report footer and set it equal to the running sum text box. The main report sub-total refers to the textbox in the footer of the sub-report.
When I view the report in Report View, everything looks good and the values are correct. When I change the view to Print Preview, the subtotal value shows 0. This happens for four text boxes on the main report (all of which have their control source set to textboxes in the footer of the sub report). I've found lots of posts on textboxes disappearing when changing views but nothing relating to the value of the textbox going to zero.
Anyone else have this happen to them before? Any help would be much appreciated!
I have a report for generating an invoice that contains a sub-report which shows the invoice details. In the sub-report I have a textbox control for CurrentBilling which shows the billing for each item/row in the sub-report. I then used a separate textbox with Running Sum property set to Over All to get the total CurrentBilling for the invoice. I then created a textbox in the sub-report footer and set it equal to the running sum text box. The main report sub-total refers to the textbox in the footer of the sub-report.
When I view the report in Report View, everything looks good and the values are correct. When I change the view to Print Preview, the subtotal value shows 0. This happens for four text boxes on the main report (all of which have their control source set to textboxes in the footer of the sub report). I've found lots of posts on textboxes disappearing when changing views but nothing relating to the value of the textbox going to zero.
Anyone else have this happen to them before? Any help would be much appreciated!