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 balancing segments in AR?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What are the User PARAMETERS in the Reports?
how will u do documentation
what is the database size you used?
what are version control tools used in oracle apps?
HOW CAN U KNOW THE STAUS OF PO?
what are the tables of auto invoice.
What are Mandatory triggers to write in the block, which is created on view?
what is aim methodolozy
why do we go for oracle apps technical other than sap and other packages?
What repots or concurrent program run to transfer data from Inventory to GL.