display no data message

[system]

Hi,

 I have a table and a section placed on it. I have to display a 'no data' message when the table is empty for a section, and display the table when there is data. How could i achieve this?

thanks,
rao.

---

p_rao (BOB member since 2007-02-26)

[system]

There are section properties which let you display the section, even if empty. You could probably use some If statement to show “No Data” if that’s required.

---

MarkDavisCraig (BOB member since 2006-02-15)

[system]

You could use block level filters to show data table block or No Data found message blcok depending on number of rows fetched.

Check my post on using filters :-

How to select the report display

Hi, We have one requirement, for example we have one report in webi(xir2), When user running the report, one prompt should ask to choose report types Select the report format Table Chart. When users selecting the chart, the report only show the chart We don’t have any idea on this, some one give me some suggestions Thanks M.Siva… kongusiva (BOB member since 2006-08-09)

---

Roshknee (BOB member since 2007-10-29)

[system]

Hi Mark and Roshknee,

 Thanks for your replies. I tried using block level filters based on one of the empty columns from the table and it worked for now (since the table has dummy data for now). Hopefully it works even when real data is loaded.

thanks,
rao.

---

p_rao (BOB member since 2007-02-26)