Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Items not printing on 2nd page of 2 page form

Items not printing on 2nd page of 2 page form

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 ponder

RE: Items not printing on 2nd page of 2 page form

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:


'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 AND = :CO_CUSTOMER_ID AND col.cust_order_id = :CO_ID AND col.line_no = :LN_LINE_NO AND = :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'

RE: Items not printing on 2nd page of 2 page form

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.

RE: Items not printing on 2nd page of 2 page form

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?

RE: Items not printing on 2nd page of 2 page form

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.


RE: Items not printing on 2nd page of 2 page form

Thanks anyways for trying Steve.  I do appreciate it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close