Skip to Content
author's profile photo Former Member
Former Member

How can I prevent printing of this FROM location label even if suppressed?

I am using Crystal Reports 10.

The examples follow the problem description.

The idea is print a label when moving one part from one location to another.

The Control ID# is the main parameter which I must receive in order to get the values from the 3rd party software to print the label information.

The Control Rec# is from the Record Number within Crystal Reports.

The Trans Rec ID# is the data I am retrieving from the transaction table. This Trans Rec ID# s the link between the Control ID# table, which also contains the Trans Rec ID# for this table.

The 3rd party software always passes one control record#, which will always have two records - one negative quantity and one positive quantity. The records are always in order by negative then positive quantity. Also, the Trans Rec ID# is in ascending sequence. The negative record will display "FROM" in the location portion of the label.

NOTE: Each time the label is to be printed, there are two more records created in the transaction table.

Here is a list of what I have tried, by itself and/or in conjunction with the others:

- in the Record Selection, I have tried selecting just the positive quantity, which will give me a leading blank page

- suppressed the Report Header

- conditionally suppressed report header - always prints blank page at beginning (see Example #2)

- conditionally suppressed detail (this works fine - see Example #2)

- sorting records in descending order by quantity

- sorting records in descending order by Trans Rec ID#

- grouping by Trans Rec ID#

- grouping by quantity

Whenever I try to suppress the printing of the negative quantity label, which I do not want to print, it always prints as a blank page. Is there a way to keep it from doing this? Is there something I can do that I am missing?

Example #1 : Suppressing report/page headers

-


Part# ABC Control ID# 166551 Control Rec# 1 Trans Rec ID# 143497 ...

Quantity = -1 Location = DC0-19 (This is the FROM Label) .

-


Part# ABC Control ID# 166551 Control Rec# 1 Trans Rec ID# 143498 ...

Quantity = 1 Location = DOCK (This is the TO Label - no indicator of From/To prints)

=================================================================

Example #2 : In Record Select, selecting only positive quantity and suppressing headers

-


(Blank page prints here - negative record is the first record)

-


Part# ABC Control ID# 166551 Control Rec# 1 Trans Rec ID# 143505 ...

Quantity = 1 Location = DOCK (This is the TO Label - no indicator of From/To prints)

=================================================================

Edited by: Rose Goehring on Aug 10, 2010 11:54 PM

Edited by: Rose Goehring on Aug 11, 2010 12:01 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 27, 2010 at 09:44 PM

    Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

    http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage∥entCategoryID=&categoryID=11522300?resid=-Z5tUwoHAiwAAA8@NLgAAAAS&rests=1254701640551

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.