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 are the prerequisite set ups for inter organization transaction?
What are documents and test cases u followed.
What are the benefits of using soa architecture?
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
How to register a form and stored procedure in oracle apps
What is the package?
Tell me where we find the status of order information?
How can a process be deployed in soa?
where we find the status of order information.
What repots or concurrent program run to transfer data from Inventory to GL.
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?