Unanswered: Main report is blank if one subreport has no data
I am having a problem with a report I created that contains 2 subreports. 1 subreport lists the cost of all Loadsheets (items going to a job from inventory), and the other subreport lists all of the Returns (items being returned to inventory from a job). The main report calculates the total loadsheets value, the total returns value and the difference. The problem I'm having is that whenever either subreport doesn't contain data, the entire main report shows up blank, with no error messages being generated. Is there a way to force the report to show the subreport that does contain data, even if the other subreport doesn't? Also, it will need to do the calculations making the total zero if there is no data in one of the reports. Any help would be greatly appreciated.