I'm sure there is a simple solution to this, but for some reason I can't get this to work. In Crystal 9.0 I have four subreports all with seperate sections in the main reports group footer. I insert a text field into the subreport that checks for the number of records, if there are 0 records returned in the subreport then I want to display a text field that says "No records for this report" and then have that passed back to the main report. For some reason it will not show up in the main report. I have checked to make sure that the Suppress Blank Subreport is not checked. Does anyone know a simple way to return a message on the main report if the subreport does not have records? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Displaying a text field in a blank subreport
- Thread starter oneilltnc
- Start date
- Thread starter
- #2
OK, I knew there had to be a simple solution to this. I was so concerned about making sure that the Suppress Blank Subreport option wasn't checked that I overlooked another one of the critical report options. I just forgot to uncheck the Suppress Printing if No Records option in the subreport. Problem solved.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question