Subreports blank when previewed from main report, populated when viewing separately
Hello. I am having trouble getting subreports to display properly. When in Print Preview for the main report, the subreports are blank. However, when double-clicking the subreport in Print Preview, the Print Preview for the subreport opens, and everything is displayed properly. This appears to be caused by linking the subreport parameter to the main report using a formula. I just don't understand why it displays properly when opening the subreport. I have also tried changing the formula. When I simply input the design parameter as a string instead of calculating and returning a value, everything seems to work. It's only when trying to perform the calculation that it fails. I have also checked the value being returned by the formula, and it is correct (otherwise the values in the Print Preview for the subreport would be wrong). If anyone can offer any insight, I would greatly appreciate it.