Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,


How to print multi currency,multi language in xml?

1 Answers  


what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,


how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,


what is the difference between procedure and function

3 Answers   Wipro,


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

5 Answers   Wipro,


Define MultiOrg Structure

5 Answers   Convergys,


what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,


any one can expalin report registration steps?

6 Answers   Infosys,


what is user exit and wat program do we write in user exit?

4 Answers   iGate,


How to send the e-mail notification in XML Pub Report?

2 Answers   Accenture, Oracle,


what is meant by lexical parameter

1 Answers   Wipro,


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)