Awes
07-08-2003, 12:59 AM
Hi All
I have a report being used as an Invoice that contains two sub-reports, Parts Used and Sundries Used.
These sub-reports have a text box in their report footer containing a SUM equation, which gives the total cost of items used.
This text box is not visible when seen on the main report.
On the main report is a text box linked to each of the 'total' text boxes on the sub-reports.
In addition there are a number of other text boxes containing cost data from various sources.
At the bottom of this group of text boxes a final text box does some maths using the data from the other text boxes to calculate the total cost for the Invoice.
This is working exactly as I want it except for when one or both of the two sub-reports contain no records associated with the invoice, i.e. there are no parts or sundries used.
When this occurs the associated text box Parts Total or Sundries Total displays a message 'Error'.
This then causes any text box referring to the text boxes Parts Total or Sundries Total in their equations to also display the
text 'Error'.
I would like the text boxes displaying the Parts Total and Sundries Total to have a default value of £0.00 if
there are no records to display in the sub-report so that the rest of the calculations will still work, but I'm not sure how to go about it.
Any pointers/advice would be appreciated.
Many thanks
AWES.
I have a report being used as an Invoice that contains two sub-reports, Parts Used and Sundries Used.
These sub-reports have a text box in their report footer containing a SUM equation, which gives the total cost of items used.
This text box is not visible when seen on the main report.
On the main report is a text box linked to each of the 'total' text boxes on the sub-reports.
In addition there are a number of other text boxes containing cost data from various sources.
At the bottom of this group of text boxes a final text box does some maths using the data from the other text boxes to calculate the total cost for the Invoice.
This is working exactly as I want it except for when one or both of the two sub-reports contain no records associated with the invoice, i.e. there are no parts or sundries used.
When this occurs the associated text box Parts Total or Sundries Total displays a message 'Error'.
This then causes any text box referring to the text boxes Parts Total or Sundries Total in their equations to also display the
text 'Error'.
I would like the text boxes displaying the Parts Total and Sundries Total to have a default value of £0.00 if
there are no records to display in the sub-report so that the rest of the calculations will still work, but I'm not sure how to go about it.
Any pointers/advice would be appreciated.
Many thanks
AWES.