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 inbound and outbound interface?
how to move the one file from one instance to another instance?and ur scripts also?
What is ERP? Architecture of apps?
Challenges faced during upgradation of 11i to R12
What is an Index , Types od index why we are use index.
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
Can u define operating units inplace of inventory?
Give a brief overview on OrderManagement.
what is organization id
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
what is global tempory table?