{"id":560,"date":"2013-02-05T03:55:44","date_gmt":"2013-02-05T03:55:44","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=560"},"modified":"2016-01-01T16:26:57","modified_gmt":"2016-01-01T21:26:57","slug":"dont-open-report-if-no-data","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=560","title":{"rendered":"Don’t Open Report if No Data…"},"content":{"rendered":"

You don’t want your Users to open a Report that has nothing to show them, better to give them a message instead.\u00a0 On the Reports NoData <\/strong>event you can use…<\/p>\n

Private Sub Report_NoData<\/strong>(Cancel As Integer)<\/p>\n

\r\nOn Error GoTo Report_NoData_Error\r\n\r\n   MsgBox "No data to Display", vbOKOnly, "Report"\r\n   Cancel = True\r\n\r\nReport_NoData_Exit:\r\nExit Sub\r\n\r\nReport_NoData_Error:\r\n   If Err.Number = 2501 Then 'the report was cancelled\r\n   Exit Sub\r\n   Else\r\n     MsgBox Err.Number & " - " & Err.Description\r\nResume Report_NoData_Exit\r\nEnd If\r\n<\/pre>\n
End Sub<\/p>\n
OR\u00a0<\/strong><\/h5>\n
Private Sub Report_NoData<\/strong>(Cancel As Integer)<\/p>\n
\r\n   MsgBox "There is no data for this report. Canceling report...", vbInformation, "Report"\r\n   Cancel = -1\r\n<\/pre>\n
End Sub<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
You don’t want your Users to open a Report that has nothing to show them, better to give them a message instead. On the Reports NoData event you can use…<\/p>\n
Private Sub Report_NoData(Cancel As Integer)<\/p>\n
 On Error GoTo Report_NoData_Error MsgBox "No data to Display", vbOKOnly, "Report" Cancel = True Report_NoData_Exit: Exit Sub Report_NoData_Error: If Err.Number […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,63],"tags":[64,30],"class_list":["post-560","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-database-design","tag-access-tips","tag-reports","odd"],"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=560"}],"version-history":[{"count":10,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/560\/revisions"}],"predecessor-version":[{"id":1130,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/560\/revisions\/1130"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}