If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display "No details" if subreport has no records
I've got a report that has group headings which may or may not have detail
information (in a subreport). I've got the subreport Can Shrink set to True, but would like to display something like "No details" in a textbox where the subreport should be, if the there are no records in the sub. Any recommendations on how to do this? ---- Dale |
#2
|
|||
|
|||
Display "No details" if subreport has no records
Dale,
Try this... Put a label, lblNoDetails, with a caption of "No Details" behind your subreport. In the On_Format section place the below code changing the name to your subreport. If Me.YourSubReport.Report.HasData Then Me.lblNoDetails.Visible = True Else Me.lblNoDetails.Visible = False End If -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Dale Fye" wrote in message ... I've got a report that has group headings which may or may not have detail information (in a subreport). I've got the subreport Can Shrink set to True, but would like to display something like "No details" in a textbox where the subreport should be, if the there are no records in the sub. Any recommendations on how to do this? ---- Dale |
#3
|
|||
|
|||
Display "No details" if subreport has no records
Dale,
Try this... Put a label, lblNoDetails, with a caption of "No Details" behind your subreport. In the On_Format section place the below code changing the name to your subreport. If Me.YourSubReport.Report.HasData Then Me.lblNoDetails.Visible = True Else Me.lblNoDetails.Visible = False End If -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Dale Fye" wrote in message ... I've got a report that has group headings which may or may not have detail information (in a subreport). I've got the subreport Can Shrink set to True, but would like to display something like "No details" in a textbox where the subreport should be, if the there are no records in the sub. Any recommendations on how to do this? ---- Dale |
#4
|
|||
|
|||
Display "No details" if subreport has no records
Dale,
Try this... Put a label, lblNoDetails, with a caption of "No Details" behind your subreport. In the On_Format section place the below code changing the name to your subreport. If Me.YourSubReport.Report.HasData Then Me.lblNoDetails.Visible = True Else Me.lblNoDetails.Visible = False End If -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Dale Fye" wrote in message ... I've got a report that has group headings which may or may not have detail information (in a subreport). I've got the subreport Can Shrink set to True, but would like to display something like "No details" in a textbox where the subreport should be, if the there are no records in the sub. Any recommendations on how to do this? ---- Dale |
Thread Tools | |
Display Modes | |
|
|