sorry to ask my problem in this thread, because i can't write new thread in this forum.
my question is: how to search outstanding purchase order (PO), or search PO inquiry by Supplier's reference?
because in the search block, the # input field only search into column reference.

hi ajospace,

what FA version do you use? have u ever managed to use writeHTML in reporting in FA?
i try to use writeHTML in rep109.php to create additional page but not success at all.
the progress bar will keep back and forth without generate PDF.

i hope you could give me a clue as almost have same problem.

-jo-

3

(2 replies, posted in Reporting)

have you try to modify file reporting/rep109.php?

why i can't use writeHTML function in this condition?
the PDF document does not generate successfully.

// just testing
        // create some HTML content
        $html = '<table border="1">
        <tr>
            <td colspan='2'>testing 1,1 and testing 1,2</td>
        </tr>
        <tr>
            <td>testing 2,1</td>
            <td>testing 2,2</td>
        </tr>
        </table>';

        // output the HTML content
        $rep->writeHTML($html, true, false, false, false, '');

i try to create a new header function called Header4() in pdf_report.inc and wants to call in rep109.php.

i add new function in rep109.php name print_tax_invoice(); calls under print_sales_orders();

some difficulties i encounter was when i want to create table header with column and row span, so i think it's easier to use HTML table to create report. but when i write  syntax html like <table><tr><td> and so on in the report, the progress bar keep continuing move back and forth unfinished. whereas when i NOT using <table> tags the result is ok.

for example (in rep109.php, function print_tax_invoice()):
               ...
               ...
               ...
        $rep->SetHeaderType("Header4"); // i call Header4 here to create different header style
        $rep->NewPage(0);

        // just testing
        // create some HTML content
        $html = '<table border="1">
        <tr>
            <td>testing 1,1</td>
            <td>testing 1,2</td>
        </tr>
        <tr>
            <td>testing 2,1</td>
            <td>testing 2,2</td>
        </tr>
        </table>';

        // output the HTML content
        $rep->writeHTML($html, true, false, false, false, '');

        if ($email == 1)
        {
            $rep->End($email);
        }
    }
    if ($email == 0)
        $rep->End();

dear masters,

I need to add a page at the bottom of the sales order called a tax invoice.
I tried (in rep109.php) adding a line:

// START my modification
$rep->NewPage();
/*
here i want to write predefined html report here
*/
// END my modification

before the end of the script, exactly above

if ($ email == 1)
  {
    $ rep-> End ($ email);
  }
}
if ($ email == 0)
  $ rep-> End ();

the result is that there is a new page with the same format with the sales order,
but I want to create a new page with a blank format because I haven't write any script yet.

is there anyone that can give me guidance on how to realize my purpose.

I wonder if the functions used to create a report on the FA is wrapped tcpdf. is it true?

-jojo-

hi bhoo-day,
how is your code? does janusz reply solve your problem?
i just searching approval module in many step in purchasing, sale, etc.
i hope bhoo-day can spread the code if it's good result.

thanks tclim.
that's works for me.