Crystal reports

Yahoo Archive
1
A question for those of you using a number of custom crystal reports. I
would like to be able to "auto run" Crystal reports at given times and send
output to selected managers via e-mail. An example would be an accounts
receivable aging that would be routed to sales, shipping and other
appropriate areas. Has anyone experimented with doing this?

Mike Daniel
2
Mike,

I didn't see any other responses to your question, so here goes ...

If you compile your Crystal reports to an EXE you can then choose Excel as
your output type, and MAPI as the destination. Then when you run the EXE it
will prompt for the email details and attach the file. Once you get to this
stage you then just need to automate the running of the EXE and the entry of
keystrokes. Ground Control seems popular with people here, but I use
ScriptIT. The scheduling software that is included with Windows should be
fine to kick off your script.

Here is the sort of thing that you would put in an INI file for ScriptIT.

[SCRIPT]
Rem Run EXE
run="V:\EPIC50\ud\Crystal\Order Book.exe"

Rem Select Export Options
Rem Added wait on 9/1/01 because dialog wasn't ready for input on next
command (I think)
Order Book+The report will be exported=!o#~wait#~wait#~wait#~wait

Rem Should remember Excel 8 and MAPI
Export={ENTER}

Rem Set options to TABULAR
Format Options={TAB}{TAB}{TAB}{DOWN}{TAB}{ENTER}

Rem Enter MAPI details
Send Mail=!tReportOrderBook@...{TAB}{TAB}Report - Order
Book{TAB}Attached is the Order Book Report.!s

Rem Print report (set to Export)
Order Book={TAB}!p

PS With V5 I gave away this idea and now use Report Builder exporting to a
text file and include the text file into the body of the mail message.

Regards
Michael Miles
-----Original Message-----
From: Mike Daniel [mailto:m_daniel@...]
Sent: Thursday, 21 February 2002 11:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports


A question for those of you using a number of custom crystal reports. I
would like to be able to "auto run" Crystal reports at given times and send
output to selected managers via e-mail. An example would be an accounts
receivable aging that would be routed to sales, shipping and other
appropriate areas. Has anyone experimented with doing this?

Mike Daniel
3
We are new to crystal and Vantage and we are trying to print our drawing on
the top of the job traveler. We know the drawing number, it's already on
the report, and we know the location of the shared directory for the
drawing. We can import a drawing and make it print on the report, but we
can't figure out how or where to put the code to make the drawing a "smart"
picture. I thought a concatenated string would be the solution, but again,
we don't know how to get this done. I thought the string could be something
like; "W:\vantage\PartDrawings\" & jobasmbl.DRAWING & ".bmp"
Is anyone doing something like this already?

Thanks,
Mark S. LaRosa
MIS Manager
R&R Manufacturing Co., Inc.




[Non-text portions of this message have been removed]
4
I do something similar, but I use VB to control the picture objects.
I don't know how you can do this with just crystal. Every search I
have done on Crystal's site has always returned a VB solution. If
you are interested in the VB solution let me know I can post some
sample code.

--- In vantage@y..., "Mark S. LaRosa" <mark@r...> wrote:
> We are new to crystal and Vantage and we are trying to print our
drawing on
> the top of the job traveler. We know the drawing number, it's
already on
> the report, and we know the location of the shared directory for the
> drawing. We can import a drawing and make it print on the report,
but we
> can't figure out how or where to put the code to make the drawing
a "smart"
> picture. I thought a concatenated string would be the solution,
but again,
> we don't know how to get this done. I thought the string could be
something
> like; "W:\vantage\PartDrawings\" & jobasmbl.DRAWING & ".bmp"
> Is anyone doing something like this already?
>
> Thanks,
> Mark S. LaRosa
> MIS Manager
> R&R Manufacturing Co., Inc.
>
>
>
>
> [Non-text portions of this message have been removed]
5
Peter,
When you say a VB solution do you mean incorporated into the crystal report
itself attached to the object? Either way, if it will work without user
intervention, yes I am interested.
Thanks,
Mark S. LaRosa
MIS Manager
R&R Manufacturing Co., Inc.

-----Original Message-----
From: Peter [mailto:peter.paasch@...]
Sent: Monday, November 04, 2002 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal reports


I do something similar, but I use VB to control the picture objects.
I don't know how you can do this with just crystal. Every search I
have done on Crystal's site has always returned a VB solution. If
you are interested in the VB solution let me know I can post some
sample code.

--- In vantage@y..., "Mark S. LaRosa" <mark@r...> wrote:
> We are new to crystal and Vantage and we are trying to print our
drawing on
> the top of the job traveler. We know the drawing number, it's
already on
> the report, and we know the location of the shared directory for the
> drawing. We can import a drawing and make it print on the report,
but we
> can't figure out how or where to put the code to make the drawing
a "smart"
> picture. I thought a concatenated string would be the solution,
but again,
> we don't know how to get this done. I thought the string could be
something
> like; "W:\vantage\PartDrawings\" & jobasmbl.DRAWING & ".bmp"
> Is anyone doing something like this already?
>
> Thanks,
> Mark S. LaRosa
> MIS Manager
> R&R Manufacturing Co., Inc.
>
>
>
>
> [Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
6
Mark,
I've wanted to do something similar to this in Crystal, but it does not seem to have the capability. This is one case where RB does have the capability.

Troy
----- Original Message -----
From: Mark S. LaRosa
To: vantage@yahoogroups.com
Sent: Monday, November 04, 2002 1:55 PM
Subject: RE: [Vantage] Re: Crystal reports


Peter,
When you say a VB solution do you mean incorporated into the crystal report
itself attached to the object? Either way, if it will work without user
intervention, yes I am interested.
Thanks,
Mark S. LaRosa
MIS Manager
R&R Manufacturing Co., Inc.

-----Original Message-----
From: Peter [mailto:peter.paasch@...]
Sent: Monday, November 04, 2002 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal reports


I do something similar, but I use VB to control the picture objects.
I don't know how you can do this with just crystal. Every search I
have done on Crystal's site has always returned a VB solution. If
you are interested in the VB solution let me know I can post some
sample code.

--- In vantage@y..., "Mark S. LaRosa" <mark@r...> wrote:
> We are new to crystal and Vantage and we are trying to print our
drawing on
> the top of the job traveler. We know the drawing number, it's
already on
> the report, and we know the location of the shared directory for the
> drawing. We can import a drawing and make it print on the report,
but we
> can't figure out how or where to put the code to make the drawing
a "smart"
> picture. I thought a concatenated string would be the solution,
but again,
> we don't know how to get this done. I thought the string could be
something
> like; "W:\vantage\PartDrawings\" & jobasmbl.DRAWING & ".bmp"
> Is anyone doing something like this already?
>
> Thanks,
> Mark S. LaRosa
> MIS Manager
> R&R Manufacturing Co., Inc.
>
>
>
>
> [Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
7
We are printing a digital photo of the part at the top of each
traveler. I went about it by creating a simple Access table
containing PartNum and an OLE field for PartPic. This table can then
be added as a subreport linked to the JobAsmbl Table in the Traveler.

Since we have thousands of part photos and Access has a limited
storage capacity, 1GB in Access 97, we did have to manually add and
remove pictures for the Jobs that were being released that day.
However I've recently automated that task to happen overnight and it
works very well. Let me know if you'd like more details.

Brian Stenglein
Clow Stamping Company

--- In vantage@y..., "Mark S. LaRosa" <mark@r...> wrote:
> We are new to crystal and Vantage and we are trying to print our
drawing on
> the top of the job traveler. We know the drawing number, it's
already on
> the report, and we know the location of the shared directory for the
> drawing. We can import a drawing and make it print on the report,
but we
> can't figure out how or where to put the code to make the drawing
a "smart"
> picture. I thought a concatenated string would be the solution,
but again,
> we don't know how to get this done. I thought the string could be
something
> like; "W:\vantage\PartDrawings\" & jobasmbl.DRAWING & ".bmp"
> Is anyone doing something like this already?
>
> Thanks,
> Mark S. LaRosa
> MIS Manager
> R&R Manufacturing Co., Inc.
>
>
>
>
> [Non-text portions of this message have been removed]
8
We are implementing in 5.2 and will be looking at our traveller soon. I
would appreciate seeing the VB solution.

Regards,


John Walter
Systems Administrator
Hufcor Pty Ltd

-----Original Message-----
From: Peter [mailto:peter.paasch@...]
Sent: Tuesday, 5 November 2002 5:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal reports


I do something similar, but I use VB to control the picture objects.
I don't know how you can do this with just crystal. Every search I
have done on Crystal's site has always returned a VB solution. If
you are interested in the VB solution let me know I can post some
sample code.

--- In vantage@y..., "Mark S. LaRosa" <mark@r...> wrote:
> We are new to crystal and Vantage and we are trying to print our
drawing on
> the top of the job traveler. We know the drawing number, it's
already on
> the report, and we know the location of the shared directory for the
> drawing. We can import a drawing and make it print on the report,
but we
> can't figure out how or where to put the code to make the drawing
a "smart"
> picture. I thought a concatenated string would be the solution,
but again,
> we don't know how to get this done. I thought the string could be
something
> like; "W:\vantage\PartDrawings\" & jobasmbl.DRAWING & ".bmp"
> Is anyone doing something like this already?
>
> Thanks,
> Mark S. LaRosa
> MIS Manager
> R&R Manufacturing Co., Inc.
>
>
>
>
> [Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
9
We just upgraded our servers to 2003 and now we have a problem with
the Crystal Reports AR invoice. From Vantage, the invoices preview
fine but when I print them, I get a grey shadow and lines on about
half the invoice. If I go into Crystal Reports the invoices print
fine with no shadows or lines. We are on Vantage 5.10 135. Any help
or ideas would be appreciated.
10
Hi all,

Does anyone know how to convert the memo fields that get brought into cystal
by epicor to a string so functions can be done on them?

Thanks
Todd
TECT Proprietary & Confidential. This message, along with any attachments,
is intended only for the exclusive use of the individual or entity to which
it is addressed and may contain information that is privileged, confidential
and exempt from disclosure. If you are not the intended recipient, you are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along with
any attachments, from your computer.


[Non-text portions of this message have been removed]
11
You have to change the database using the database administrator

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Mesick, Todd [mailto:tmesick@...]
Sent: Monday, April 18, 2005 10:11 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Crystal reports



Hi all,

Does anyone know how to convert the memo fields that get brought into cystal
by epicor to a string so functions can be done on them?

Thanks
Todd
TECT Proprietary & Confidential. This message, along with any attachments,
is intended only for the exclusive use of the individual or entity to which
it is addressed and may contain information that is privileged, confidential
and exempt from disclosure. If you are not the intended recipient, you are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along with
any attachments, from your computer.


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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
12
Does anybody know how I could do this.

We need to have a separate sheet print with each PO we print. The separate sheet would have certain terms and conditions that would written on the crystal report itself. How would I make the Purchase Order report always print out a last page with this information and this information only?

Thanks,
Jasper


[Non-text portions of this message have been removed]
13
Can you put whatever you want in the report footer and then in the
options set it to new page before

--- In vantage@yahoogroups.com, Jasper Recto <jrecto@...> wrote:
>
> Does anybody know how I could do this.
>
> We need to have a separate sheet print with each PO we print. The
separate sheet would have certain terms and conditions that would
written on the crystal report itself. How would I make the Purchase
Order report always print out a last page with this information and
this information only?
>
> Thanks,
> Jasper
>
>
> [Non-text portions of this message have been removed]
>
14
You can define a subreport in crystal reports, only containing the page
you want.

Jasper Recto schreef:
> Does anybody know how I could do this.
>
> We need to have a separate sheet print with each PO we print. The separate sheet would have certain terms and conditions that would written on the crystal report itself. How would I make the Purchase Order report always print out a last page with this information and this information only?
>
> Thanks,
> Jasper
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
15
> You can define a subreport in crystal reports, only containing the page
> you want.

Or put the text in the Report Footer section. This prints at the end of the
report.

Mark W.