Hi,
Is there a way to display a message when there is no data in the report. For eg. Lets say i am having a list for a particular case it returned empty report, but i want to show a message saying "No Data Available"
Thanks
Hi,
Hereââ,¬â,,¢s a method to show a customized message when no data is returned:
Create a list report and select the list using the select ancestor tool in the properties panel.
Create a List Footer and select the text item in the List Footer. Modify it to the custom message you want, ie: No Records Were Returned.
Create a new boolean variable. Using the built in function RowNumber(), create the expression: RowNumber()>0
Select the List Footer in the list in your report and set the Conditional Style in the properties panel to use the variable you just created.
Using the Conditional Explorer select the "Yes" value from your variable.
Set the "Box Type" property for the List Footer to "None".
Change the "Border" property to be style set to "None" on all sides and apply
Turn off the Conditional Explorer and use a prompt or filter to test your report.
i had found this solution in some other forum.
hope this helps
Thanks Dude it works fine. But one thing more, is there a way tht i can hide the list headers too if there is No recaords are there
Thanks
one more thing, if it is a crosstab then is this approach works fine ? or do we need to apply any other strategy ? mean while i will try to play arround with the crosstab. Please let me know if u have any solution for showing "No Data Found" for crosstab too
Thanks