Crystal Reports - Checks Design

Yahoo Archive
1
Having check stubs on AP checks for an "Office Copy" has come up a few times
on the list and we have been working in a slightly different direction.
Instead of printing two identical stubs on the same check, we run the check
file through a different Crystal that looks like a check but without MICR
numbers and with a "Not Negotiable" watermark on it. This way, we didn't have
to mess with the standard Crystal, we get copies, and we get to use the full
check for as many invoices that the standard software can use. (In 8.03)

The only issue is getting the second printing to occur automatically.
Currently, after the checks print, we go into Crystal, set the AP Check file
as the source and print the copies. Does anyone know a clever way to run a
second Crystal on an existing .XML file automagically?

I've never been able to get BAM to work but maybe there are other clever
ideas.

Mark W.
2
Hello,



We are using Crystal Reports XI to design our check layout.

The checks that we use have two check stubs. One that we keep for our
records and one we send to the customer.



We can get the first stub to print correctly but the second one only
prints the last record. I can visualize why this is but my question is
how can we get the check stub information to reprint on the second stub?



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



[Non-text portions of this message have been removed]
3
Mr. Joe: We looked at this a while back and the short answer is
that you cannot do it. I submitted a suppor request for this
ability some time ago, however it has never been addressed.

What we do now is copy the entire check and then send the entire
page to the vendor.

Sorry, not the answer you were looking for, but I thought there may
be some comfort knowing you are not the first to ask.

DaveO

--- In vantage@yahoogroups.com, "Joe Rojas" <jrojas@...> wrote:
>
> Hello,
>
>
>
> We are using Crystal Reports XI to design our check layout.
>
> The checks that we use have two check stubs. One that we keep for
our
> records and one we send to the customer.
>
>
>
> We can get the first stub to print correctly but the second one
only
> prints the last record. I can visualize why this is but my
question is
> how can we get the check stub information to reprint on the second
stub?
>
>
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@...
>
>
>
> [Non-text portions of this message have been removed]
>
4
Just my $0.02 since I don't have Crystal XI

Is it possible to make the paper size 1/3 of the page, then print three
reports on three thirds of a page?

Maybe there is function to reset the record number?

Again I haven't tried any of this.

Russ Dover





_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Wednesday, August 23, 2006 2:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - Checks Design



Hello,

We are using Crystal Reports XI to design our check layout.

The checks that we use have two check stubs. One that we keep for our
records and one we send to the customer.

We can get the first stub to print correctly but the second one only
prints the last record. I can visualize why this is but my question is
how can we get the check stub information to reprint on the second stub?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@tnco- <mailto:jrojas%40tnco-inc.com> inc.com

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
Some one sent me a reply offline with a crystal report. The solution is
to use a sub report for each check stub.



Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Russ Dover
Sent: Thursday, August 24, 2006 8:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Checks Design



Just my $0.02 since I don't have Crystal XI

Is it possible to make the paper size 1/3 of the page, then print three
reports on three thirds of a page?

Maybe there is function to reset the record number?

Again I haven't tried any of this.

Russ Dover

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Wednesday, August 23, 2006 2:51 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports - Checks Design

Hello,

We are using Crystal Reports XI to design our check layout.

The checks that we use have two check stubs. One that we keep for our
records and one we send to the customer.

We can get the first stub to print correctly but the second one only
prints the last record. I can visualize why this is but my question is
how can we get the check stub information to reprint on the second stub?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@tnco- <mailto:jrojas%40tnco-inc.com> inc.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
I don't know your Crystal skill levels so this may be a stupid question
you've already addressed:



Did you check to see if the fields were setup in Crystal to print only
once? Isn't there a suppress option available for duplicate information?



There is in version 8.5 - just checking.





Sue



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Olender
Sent: Wednesday, August 23, 2006 4:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports - Checks Design



Mr. Joe: We looked at this a while back and the short answer is
that you cannot do it. I submitted a suppor request for this
ability some time ago, however it has never been addressed.

What we do now is copy the entire check and then send the entire
page to the vendor.

Sorry, not the answer you were looking for, but I thought there may
be some comfort knowing you are not the first to ask.

DaveO

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Joe
Rojas" <jrojas@...> wrote:
>
> Hello,
>
>
>
> We are using Crystal Reports XI to design our check layout.
>
> The checks that we use have two check stubs. One that we keep for
our
> records and one we send to the customer.
>
>
>
> We can get the first stub to print correctly but the second one
only
> prints the last record. I can visualize why this is but my
question is
> how can we get the check stub information to reprint on the second
stub?
>
>
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@...
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
I am not a Crystal Guru, which is probably why I haven't figured it out
yet! Somebody on the groups sent some instructions once on how to get it
to print correctly. I tried, but it didn't work for me. Our AP clerk was
just happy that she didn't have to manually provide the invoice numbers
we were paying. If anyone gets it right, please let me know.



Karen Brodniak

Accounting Manager

karen.brodniak@...

425-742-7011 X44

Fax 425-353-8945



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Susan Iverson
Sent: Thursday, August 24, 2006 8:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Reports - Checks Design



I don't know your Crystal skill levels so this may be a stupid question
you've already addressed:

Did you check to see if the fields were setup in Crystal to print only
once? Isn't there a suppress option available for duplicate information?

There is in version 8.5 - just checking.

Sue

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Dave Olender
Sent: Wednesday, August 23, 2006 4:24 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Crystal Reports - Checks Design

Mr. Joe: We looked at this a while back and the short answer is
that you cannot do it. I submitted a suppor request for this
ability some time ago, however it has never been addressed.

What we do now is copy the entire check and then send the entire
page to the vendor.

Sorry, not the answer you were looking for, but I thought there may
be some comfort knowing you are not the first to ask.

DaveO

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> , "Joe
Rojas" <jrojas@...> wrote:
>
> Hello,
>
>
>
> We are using Crystal Reports XI to design our check layout.
>
> The checks that we use have two check stubs. One that we keep for
our
> records and one we send to the customer.
>
>
>
> We can get the first stub to print correctly but the second one
only
> prints the last record. I can visualize why this is but my
question is
> how can we get the check stub information to reprint on the second
stub?
>
>
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@...
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]