Summing empty Cross Tab

Topic

New Reply

I have a report that shows details from two subreports which are based on cross tab queries. Each of the sub-reports has totals calculated on the report. I want to add the two totals together.
However in some cases, there will be no data for one or both of the cross tab queries and therefore the report. This means I get an #Error# in the total of the individual sub report and also in the total. Is there any way to treat the subreport with no data as zero and therefore get a total of the two.
TIA
Steve

Reply | Quote

Replies

Reports have an “HAS DATA” property, which is true or false.

So you should be able test that with an If statement, and either use total from the report, or 0 if the report does not have data.

Reply | Quote

Reports have an “HAS DATA” property, which is true or false.

So you should be able test that with an If statement, and either use total from the report, or 0 if the report does not have data.

Sorry – senior moment.
These are in a Form not a Report

Reply | Quote