Interested to Buy Any Domain ? << Click Here >> for more details...
How to write the no data found in XML Publiser Report in apps?
- 2 Answers
- 26852 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by soa and what are the benefits of using this architecture?
What is instead of trigger in where we will use?
What do you understand by concurrent programs?
What does appl_top directory contain?
How can we import the data into a database using sql * loader?
What are the benefits of using soa architecture?
how can i print random rows in plsql table
Explain what are the tables of auto invoice?
Are you familiar with internet architecture of oracle apps 11i?
What do you understand by a set of books?
What are the different components of soa suite?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
In sequence i want to 11 and 15th values how we will write?
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.
Tell me where we find the status of order information?
