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 |
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
What is count(*) from po_vendors(any table)?
what is the difference between procedure and function
Registering parametric report?
What is oracle soa suite and what are its different components?
Can we create tables in apps schema?
what are the match approvals in PO?
what is unit of measure classes? give atleast two examples. name the underlying table.
Please let me know the differance between Master Item and organization Item in Inventory.
I want to print output in portrait style?where i have to change the settings?
how to call report from oracle oracle apps11i?
what is instead of trigger. what is the use of that?