How to write the no data found in XML Publiser Report in apps?
Answers were Sorted based on User's Feedback
Answer / eldho
We can do it in 2 ways.
In rdf, we can define a summary column (say
CF_COUNT)which counts the number of rows of a group, and in
the rtf layout create a text form field and put the help
text as <?if:CF_COUNT=0?>No Data Found<?end if?>
Other way, no need of summary column, in the rtf layout
create a text form field and put the help text as
<?if:
count(./LIST_G_SO_NUMBER/G_SO_NUMBER/LIST_G_SO_NUMBER1/G_SO_NUMBER1)=0?>No
Data Found<?end if?>
where
./LIST_G_SO_NUMBER/G_SO_NUMBER/LIST_G_SO_NUMBER1/G_SO_NUMBER1
is the expected path to the group, from the root of the xml,
that we define. This expression will count the number of
occurances of the group "G_SO_NUMBER1"
Is This Answer Correct ? | 10 Yes | 4 No |
Answer / mahesh govindu
if count(*)=o then
it will displays the no dtata found
Is This Answer Correct ? | 7 Yes | 7 No |
how to find the custom directory in front end.
1 Answers IBM, Sierra Atlantica,
What is secuirity's in R12 features.
can we pass bind variablein lexical parameter?
What is template?
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
what is the error you will get if field is referenced in wrong repeating frame?
Tell me some thing about SQL-LOADER.
how to print multi lay outs,muti currency,muti language in xml publisher
How do you register report in oracle apps?
How many schemas we have? how many you have used?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
Tell me how to debug the report?