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
what is pay run id ?
Do you know what are user profiles in apps. Any examples you can give?
What is oracle soa suite?
Is soa a part of oracle fusion middleware?
can we get profile values in report without using user exists is it possible how?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what is the differences between internal requisition and internal sales order?
Can you explain the difference between architecture followed in 10g & 11g?
In sequence i want to 11 and 15th values how we will write?
Tell me where we find the status of order information?
Do you know what is applysys in oracle application database schema, what is apps?
What are the Standard Reports and Forms in HRMS?
what is the difference between request group and request security in oracle apps?
Can you define an erp system?
List the various types of value set.