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
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by soa?
do you know is it possible to run the interface without using oracle apps?
what is global tempory table?
What are the different components of soa suite?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
What is count(*) from po_vendors(any table)?
What is sca and how is it useful?
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
please send me forms, xml pulisher questions,answers
what are the different transaction clauses in AR?
Which oracle apps version you are very confident in?
how do you describe O2C along with tables
What do you understand by a set of books?
How can a process be deployed in soa?