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?

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


Please Help Members By Posting Answers For Below Questions

where to define interorganization transaction charges and what are the different options?

2369


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

1134


what is the difference between request group and request security in oracle apps?

5790


Is soa a part of oracle fusion middleware?

1037


Can u give the Documentation of Custom.pll in oracle apps

3419


What are do's and dont's of Interface?

2368


Tell me where we find the status of order information?

1100


In sequence i want to 11 and 15th values how we will write?

2022


How to move the one file from one instance to another instance? And your scripts also?

1067


What do you understand by soa?

1100


In support project one ticket alloted which steps follows manualy tell me ?

2611


What is a flexfield? List out its types.

1109


What do you understand by a set of books?

1042


Tell me how to find the custom directory in front end?

1053


do you know is it possible to run the interface without using oracle apps?

1065