I have a report that I am generating with 5 subreports embedded in it. When one of the queries that the subreports are generated from has no data, the subreport does not show when I run the main report. I would like all subreports to be displayed, regardless if there is underlying data or not. I have tried using the Details section of the main report and setting all of my subreports' visible property to True using VB, but this is still not working. Any suggestions?

Display a message in the place where the subreport should be stating that there is no data.

mmcdonal

Also, when you placed your subreport into your report at design time, it had a label. Having the label showing above the spot where the data goes with no data is also an indicator that "X marks the spot."


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for the suggestions. Unfortunately I need the subreports to show up because I have a text box on each subreport footer that sums the data for each subreport. Then I have a totals box on the main report that totals all the 5 subreport totals boxes. I have those to be set to 0 if there is no data in the subreport, so I'm getting an error on the totals box on my main report because it's looking for the text boxes and not finding some of them. I know there's a way to use hasdata with an if statement but that seemed like a lot of coding and it would be easier if the subreport would just show up with a zero on it instead of hard coding all of my summation boxes.

BPH, Have you found a solution to this problem? I have the same problem. One of my parameters is MTD/WTD. If MTD I determine the start / end date for the month and pass that to my subreports. The main report displays daily information but there may be no data for the day but I still want the subreports to display the monthly information.