Skip to Content
0
Former Member
Aug 10, 2010 at 03:53 PM

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

24 Views

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