How to write the no data found in XML Publiser Report in apps?

Answers were Sorted based on User's Feedback



How to write the no data found in XML Publiser Report in apps?..

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

How to write the no data found in XML Publiser Report in apps?..

Answer / mahesh govindu

if count(*)=o then
it will displays the no dtata found

Is This Answer Correct ?    7 Yes 7 No

Post New Answer

More Oracle Apps Technical Interview Questions

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)?

0 Answers  


what is the difference between procedure and function

4 Answers  


Registering parametric report?

1 Answers  


What is oracle soa suite and what are its different components?

0 Answers  






Can we create tables in apps schema?

0 Answers  


what are the match approvals in PO?

3 Answers  


what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,


Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,


I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,


how to call report from oracle oracle apps11i?

3 Answers   Genpact,


what is instead of trigger. what is the use of that?

3 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)