How to write the no data found in XML Publiser Report in apps?
Answer Posted / 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 |
Post New Answer View All Answers
where to define interorganization transaction charges and what are the different options?
What is oracle soa suite and what are its different components?
what is the difference between request group and request security in oracle apps?
Is soa a part of oracle fusion middleware?
Can u give the Documentation of Custom.pll in oracle apps
What are do's and dont's of Interface?
Tell me where we find the status of order information?
In sequence i want to 11 and 15th values how we will write?
How to move the one file from one instance to another instance? And your scripts also?
What do you understand by soa?
In support project one ticket alloted which steps follows manualy tell me ?
What is a flexfield? List out its types.
What do you understand by a set of books?
Tell me how to find the custom directory in front end?
do you know is it possible to run the interface without using oracle apps?