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 |
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
where the accounting related data is stored ? all type of accounting related data costing etc...
what is tuning in oracle apps technical
Tell me some interface tables on ordermangement.
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
What r the validation done in ap inbound ?
how many groups we can create for query?
what type of testing u r doing?
How will you get the concurrent program output as email?
What is REF Cursor?
19 Answers Infosys, Intelligroup,
what is pick selection list generation report.