CODEWITHSUNDEEP
business-objectswebi
VJAI
VJAI

Reputation: 111

Conditional display of rows in Webi report

I've created a WebI report to display all Transactions Done for a day for a certain product.

The report works fine, but I've a new requirement wherein the report needs to display No Records Available message in case no records match the query and WebI report is empty.

Can this be achieved? If yes... can you please help me with the process?

-Vjai

Upvotes: 1

Views: 2724

Answers (1)

VJAI
VJAI

Reputation: 111

Got it....Hopefully It'll help someone else just in case...

Create a variable in the webi using the below Formula....Insert a blank cell and assign it a value of the variable.

Now change the properties of the Cell to Hide when Empty...

If NumberofRows(Query1)=0 Then "No Records Available"

Upvotes: 1

Related Questions