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 |
why do we go for oracle apps technical other than sap and other packages?
what are the error tables in AP?
Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems
what are the tables of auto invoice.
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
How will you get the concurrent program output as email?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
In support project one ticket alloted which steps follows manualy tell me ?
what are the different calculation columns available in reports?
What is Summary columns?
q)what are the validations in sql*loader