Hello again.
I have a report that consists of 2 subreports merged into one. Each report uses its own query to get the data. I just ran this report for a month and one of the subreports showed data but the other showed blanks in the fields. The reason for the blanks is because the query didn't produce any results.
I was wondering if it is possible to populate the fields in this subreport with something like a default value of 0. Or if I can update the query so that it shows a record with 0 in the fields instead of a query with no results (no records)
Hopefully I made sense in the question.
Thanks
I have a report that consists of 2 subreports merged into one. Each report uses its own query to get the data. I just ran this report for a month and one of the subreports showed data but the other showed blanks in the fields. The reason for the blanks is because the query didn't produce any results.
I was wondering if it is possible to populate the fields in this subreport with something like a default value of 0. Or if I can update the query so that it shows a record with 0 in the fields instead of a query with no results (no records)
Hopefully I made sense in the question.
Thanks