Items not printing on 2nd page of 2 page form

[NBVC]

Hi again...

...more forms problems...

I have a form (Packing Slip) that has information in the Page Header section. The information is a combination of Input Items, Input Variables and Formulas...

The problem is that some of these items do not print on the 2nd page of a 2-page report... I cannot figure out why... it seems to be only some of the input variables that are not printing...other variables print on both pages

[NBVC]

Updated information:

I found out that the items don't appear on the 2nd page only when a part Id is not listed on that second page...

so if only the "extra" stuff... (e.g notes) appear then it doesn't show the data on the 2nd page.

Here is the code for the extended query for the input variables:

CODE

'SELECT co.currency_id, cust.contact_fax, cust.contact_first_name, cust.contact_last_name, cust.contact_phone, col.orig_country_id, co.carrier_id, p.mfg_name, p.mfg_part_id, col.hts_code FROM customer_order co, customer cust, cust_order_line col, part p WHERE co.id = :CO_ID AND cust.id = :CO_CUSTOMER_ID AND col.cust_order_id = :CO_ID AND col.line_no = :LN_LINE_NO AND p.id = :LN_PART_ID INTO :var_order_currency, :var_contact_fax, :var_contact_first_name, :var_contact_last_name, :var_contact_phone, :var_orig_country_id, :var_carrier_id, :var_mfg_name, :var_mfg_part_id, :var_hts_code_new'

[Steve Leighton]

Hi Vittorio

Just a shot in the dark - maybe list the 'Part ID' on the second page and make it invisible if its not required.
Sometimes I know that on a second page, the Page Header stuff does not show - if its just a continuation of the first page, i.e. all the stuff wont fit on the first page.

[NBVC]

Hi Steve,

I am not sure how to do that... right now, the Part ID's will continue onto page 2 if there are more than can fit on page 1... Do you mean to force Part ID on page 2 and hide it if not needed? If so, how do I do that?

[Steve Leighton]

Hi Vittorio

I'm afraid the only way to see what's going on here is to break point in the calling application, around about where its SQLFetchNext(), and each time it breaks, investigate what's in the result set, and in each input variable ( I.e. the ones not being displayed ).
That is very easy to do if you can get access to the source code - which I cant.

Sorry I cant be more help with this one.

[NBVC]

Thanks anyways for trying Steve.  
I do appreciate it.