Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Friday, June 28, 2013

How to change the report heading based on type?

In Ar invoice report Display Credit memo for type credit memo and debit memo for debit memo type invoices.

Solution
---------

For this i took A form field in heading and increase size by ctrl+{ buttons or manually increase size because it is heading.

Then in  that form field write below code.

<?xdofx:if to_char(TYPE)='INV'  then ’TAX INVOICE’else if to_char(TYPE)='CM' then ’CREDIT MEMO’ else  ’DEBIT MEMO’ end if?>

The rtf Look like below...




No comments:

Post a Comment