Multiple Records on one PDF page.

Applications Report PDF
#1

How do I put multiple rows from my select statement on one page of the PDF?

Scriptcase puts each row on a new page. But I have rows that don’t have a lot of columns, so I would like to put more than one row on a page.

Thanks.

#2

Hello,

Please contact our support regarding this issue. Our chat is active on workdays from 8:00am to 6:00pm (GMT -3), and our ticket system is always available.

regards,
Bernhard Bernsmann

#3

One of the reasons I posted this on the forum is so that the answer will become available to other users in the forum.

I have figured out that if you make the report “Lines per page” and do something like this:

      /*------------------ Page 1 -----------------*/
        //sc_pdf_print($cell_shipto_code);
        //sc_pdf_print($cell_p_custname);
        //sc_pdf_print($cell_p_addr1);
        //sc_pdf_print($cell_p_addr2);
        //sc_pdf_print($cell_city_state);
        //sc_pdf_print($cell_zip);
        //sc_pdf_print($cell_p_addr4);
      /*-------------------------------------------*/

sc_pdf_cell(20,5,{shipto_code});
sc_pdf_multi_cell(0,5,{p_custname}."
“.
{p_addr1}.”
“.
{p_addr2}.”
“.
{city_state}.” “.{zip}.”
".
{p_addr4});

it mostly works. Unless you have a header entry. Then the header on the FIRST page overlaps the data. It is correct on all the other pages.

And… we don’t have a support contract, so the chat/support is not available to me.

#4

It appears that there is a bug in the generated code that processes the PDF setup. I will open an item in the Bugs section. But I believe that this is the problem:

     if ($Init_Pdf)
      {
          $this->Pdf_init();
          $this->Pdf->AddPage();
          $this->Pdf->SetY(5);
          $Init_Pdf = false;
      }

The call to SetY ignores any positioning and content that is output during the first header.