get default text value if sub report has no data 1

[tnguyen315]

Hi I have a report with several sub reports. I would like to show "N/A" value on that column if sub report has no data. Is it possible? Thanks
Please help
Again, thank you
2 colums get datas from the main report and 7 colums get data from each sub report.

 

[dhookom]

If a subreport has no data, you can use an expression like:

  =IIf(sbrptCtlName.Report.HasData,[...some expression...],"N/A")

Duane
Hook'D on Access
MS Access MVP

 

[tnguyen315]

I still don't get it. Where do I put that code? For instant, my main report named "RptResult", and subreport named "RptResult_Q1_SubRpt", and named of the control on main report named "Child12".
Please help, thanks

 

[dhookom]

You stated "show 'N/A' value on that column" which doesn't make much sense since "column" is unknown to us.

Typically you would place a text box on your main report in the save section of the report as your subreport. The expression I provided would be the control source of that text box. You didn't say what should display if the subreport has records. Assuming you don't want anything to display if there are records, try:

  =IIf(Child12.Report.HasData,Null,"N/A")

Duane
Hook'D on Access
MS Access MVP

 

[tnguyen315]

Thanks dhookom, it works perfectly. Again thanks