nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Best way to let user know when a report executes & fetches no data (For eg: Display something li

Mat

<p>Hi Folks,</p><p> </p><p>I am wondering if there is a good way (user-friendly & at the same time reusable in some fashion when done for a lot of report templates) to handle the case of a report fetching no data when it executes and wanting to let the user know in a good fashion rather than displaying empty report items (like table, etc).</p><p> </p><p>I know of one way of handling this as explained in the below posts,</p><p> </p><p><a data-ipb='nomediaparse' href='http://digiassn.blogspot.in/2007/03/birt-hide-report-table-when-no-data-is.html'>http://digiassn.blogspot.in/2007/03/birt-hide-report-table-when-no-data-is.html</a></p><p> </p><p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/devshare/_/designing-birt-reports/522-birt-display-no-data-when-table-is-empty-example'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/522-birt-display-no-data-when-table-is-empty-example</a></p><p> </p><p>Almost all of our current report templates involve a bunch of tables (2 -3 tables). I am wondering if there is a way to include a script which can handle this (programatically) so handling this on all the reports would be easier rather than doing, say for example, the above logic manually for each report. </p><p> </p><p>For eg: Is there a way i can plug (script) into any of the report/report item events & dynamically display a label saying "No data was found" (instead of empty tables) when on generation the report fetches no data and also be able to reuse that in all the report templates.</p><p> </p><p>Thanks</p><p>Mat</p><div> </div>

Find more posts tagged with

Comments

kclark

<p>If you put all of your reports into a single cell grid then you can use some script to drop the table if no data is returned. Or you can create one report that has your "no data returned" message then use window.location to forward them to this report if no data is returned.</p>

Mat

<p>Thanks [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:14px;]Kristopher!. I implemented the latter. For the benefit of others, i have the below function(s) in my script file (which is added as a java script resource in all reports). For each report that i need to implement the support, all i have to do is just pick up a key table which is to be used for determining that the report didn't fetch any data & call the below function in the beforeFactory passing in the table name as parameter (set via bookmark on the table).[/color]</p><p> </p><p><strong><em><span style="font-size:14px;">function addSupportForNoDataReturned(tblNameToChkForNoData) {</span></em></strong></p><div><strong><em>importPackage(Packages.org.eclipse.birt.report.model.api);</em></strong></div><div><strong><em>importPackage(Packages.org.eclipse.birt.report.model.api.elements);</em></strong></div><div> </div><div><strong><em>var rptDesignHandle = reportContext.getDesignHandle();</em></strong></div><div><strong><em>var tblHandle = rptDesignHandle.findElement(tblNameToChkForNoData);</em></strong></div><div> </div><div><strong><em>var hideRule = StructureFactory.createHideRule();</em></strong></div><div><strong><em>hideRule.setFormat(DesignChoiceConstants.FORMAT_TYPE_ALL);</em></strong></div><div><strong><em>hideRule.setExpression("var rowsReturned = Total.count();var noDataRptURL = getNoDataReportURL();Total.count() == 0;");</em></strong></div><div><strong><em>var propHandle = tblHandle.getPropertyHandle(TableHandle.VISIBILITY_PROP);</em></strong></div><div><strong><em>propHandle.addItem(hideRule);</em></strong></div><div> </div><div><strong><em>var elementFactory = rptDesignHandle.getElementFactory();</em></strong></div><div><strong><em>var textItemHandle = elementFactory.newTextItem(null);</em></strong></div><div><strong><em>textItemHandle.setContentType(DesignChoiceConstants.TEXT_CONTENT_TYPE_HTML);</em></strong></div><div><strong><em>textItemHandle.setContent("<script type="text/javascript"> function redirectIfNoDataGotFetched() {var rowsFetched = <VALUE-OF>rowsReturned</VALUE-OF>;if($(rowsFetched) < 1){window.location = "<VALUE-OF>noDataRptURL</VALUE-OF>";}} head.ready(document, function() {redirectIfNoDataGotFetched();}); </script>");</em></strong></div><div><strong><em>rptDesignHandle.getBody().add(textItemHandle);</em></strong></div><div> </div><div><strong><em>hideRule = StructureFactory.createHideRule();</em></strong></div><div><strong><em>hideRule.setFormat(DesignChoiceConstants.FORMAT_TYPE_ALL);</em></strong></div><div><strong><em>hideRule.setExpression("rowsReturned != 0;");</em></strong></div><div><strong><em>propHandle = textItemHandle.getPropertyHandle(TextItemHandle.VISIBILITY_PROP);</em></strong></div><div><strong><em>propHandle.addItem(hideRule);</em></strong></div><div><strong><em>}</em></strong></div><div> </div><div><strong><em>function getNoDataReportURL() {</em></strong></div><div><strong><em>var sessionId = getSessionId();</em></strong></div><div><strong><em>var noDataReportUrlPath = "https://" + Packages.java.net.InetAddress.getLocalHost().getHostAddress() + "/birtservlets/frameset?__report=No_Data_Returned_Notification_Report.rptdesign&paraSessionId=" + sessionId + "&__showtitle=false";</em></strong></div><div> </div><div><strong><em>var servletRequest = reportContext.getHttpServletRequest();</em></strong></div><div><strong><em>if (servletRequest != null) {</em></strong></div><div><strong><em>var qryString = servletRequest.getQueryString();</em></strong></div><div><strong><em>if (qryString.indexOf("__document") != -1) {</em></strong></div><div><strong><em>qryString = qryString.replace("__document","documentURL");</em></strong></div><div><strong><em>}</em></strong></div><div><strong><em>noDataReportUrlPath = servletRequest.getScheme() + "://" + servletRequest.getServerName() + "/birtservlets/frameset?__report=No_Data_Returned_Notification_Report.rptdesign&paraSessionId=" + sessionId + "&__showtitle=false&URLQryStrSegment=" + encodeURIComponent(qryString);</em></strong></div><div><strong><em>}</em></strong></div><div> </div><div><strong><em>return noDataReportUrlPath;</em></strong></div><div><strong><em>}</em></strong></div><div> </div><div>In the report that displays the no data returned message, i have the below function in the beforeFactory which is used in my html text to provide a hyperlink for the user to retry running the report,</div><div> </div><div><div><em><strong>function getReportRetryURL() {</strong></em></div><div><em><strong>var reportRetryURL = "https://" + Packages.java.net.InetAddress.getLocalHost().getHostAddress();</strong></em></div><div><em><strong>var servletRequest = reportContext.getHttpServletRequest();</strong></em></div><div><em><strong>if (servletRequest != null) {</strong></em></div><div><em><strong>reportRetryURL = servletRequest.getScheme() + "://" + servletRequest.getServerName();</strong></em></div><div><em><strong>}</strong></em></div><div><em><strong>var qryStrSegment = params["URLQryStrSegment"].value;</strong></em></div><div><em><strong>if (qryStrSegment != null && qryStrSegment.length != 0) {</strong></em></div><div><em><strong>qryStrSegment = decodeURIComponent(qryStrSegment);</strong></em></div><div><em><strong>if (qryStrSegment.indexOf("documentURL") != -1) {</strong></em></div><div><em><strong>qryStrSegment = qryStrSegment.replace("documentURL","__document");</strong></em></div><div><em><strong>}</strong></em></div><div><em><strong>if (qryStrSegment.indexOf("__overwrite") == -1) {</strong></em></div><div><em><strong>qryStrSegment = qryStrSegment + "&__overwrite=true";</strong></em></div><div><em><strong>} else if (qryStrSegment.indexOf("__overwrite=false") != -1) {</strong></em></div><div><em><strong>qryStrSegment = qryStrSegment.replace("__overwrite=false","__overwrite=true");</strong></em></div><div><em><strong>}</strong></em></div><div><em><strong>reportRetryURL = reportRetryURL + "/birtservlets/frameset?" + qryStrSegment;</strong></em></div><div><em><strong>} else {</strong></em></div><div><em><strong>reportRetryURL = reportRetryURL + "/reports/reports.xhtml";</strong></em></div><div><em><strong>}</strong></em></div><div><em><strong>return reportRetryURL;</strong></em></div><div><em><strong>}</strong></em></div></div>

kclark

<p>You're welcome. Thanks for posting your solution!</p>