# Crystal Reports
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-07-27 10:07 UTC
**Views:** 3757
**Replies:** 119
**URL:** https://www.epiusers.help/t/crystal-reports/597
---
## Post #1 by @system
Does Vantage 4.0 support Crystal Reports version 8 since it is becoming
difficult to find version 7?
Greg Taylor
MIS Coordinator
Eldim Applied Technologies
---
## Post #2 by @system
If you plan on changing any reports in your \Vantage\Userform directory, you
will need Version 7 of Crystal Reports for Vantage 4.0.
If you are going to create reports from your Vantage database using any
flavor of ODBC then any version of Crystal will work for that.
Ted Kitch
tedkitch@...
On Wed, 11 Oct 2000 12:50:35 -0500, vantage@egroups.com wrote:
> Can anyone tell me what version of Crystal Reports we need to make
reports for Vantage 4.0 ? Currently we are using version 6 of Crystal
Reports.
>
> Thanks in advance
> Paul L
>
> [Non-text portions of this message have been removed]
>
Ted Kitch
tedkitch@...
_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html
Hi group-
I'm new to Vantage and to Crystal Reports and I'm having trouble with an
invoice report in Crystal. The initial problem was that when we had a part
that had several misc charges to it the quantity would accumulate for each
misc charge. The actual ship quantity would be 10 but would show as thirty
on the invoice because it accumulates for the part itself, the expedite
charge, and the freight charge. I fixed this by creating a running total
that resets on change of POLineNum. This fixed that problem but created
another problem which I can't seem to solve.
In this invoice we have multiple lots that are grouped so that they will
display as a single line item(The customer wants to see quantity 100 not
27,56, and 17). But, since this is in the group header I'm getting only the
first line item added to my running total and displayed. Changing this to a
group footer band fixes the problem but my misc charges are in the details
so they print before the line item instead of after it where I need them.
I am open to any suggestions!!! I have been trying to figure out how to
either display the running total after it has totalled the whole group and
leave the group in the header OR move the group to the footer and get the
misc charges to display after it.
I hope this makes since...after looking at it for several hours I'm not sure
that I even understand it anymore. If I need to clarify anything let me
know. I appreciate any suggestions.
Mark Kohring
Delta Centrifugal Corp.
MKohring@...Mark,
Sounds like a job for SUBREPORTS. I've run into similar problems designing reports that gather pieces from several different areas. If you could make a subreport, link it to the Part number, and just return the Misc Charges, and place the subreport in the Group Footer. That will probably slow the report down considerably, but could solve your problem.
Troy Funte
Liberty Electronics
----- Original Message -----
From: mkohring@...
To: vantage@egroups.com
Sent: Wednesday, November 01, 2000 10:40 PM
Subject: [Vantage] Crystal Reports
Hi group-
I'm new to Vantage and to Crystal Reports and I'm having trouble with an
invoice report in Crystal. The initial problem was that when we had a part
that had several misc charges to it the quantity would accumulate for each
misc charge. The actual ship quantity would be 10 but would show as thirty
on the invoice because it accumulates for the part itself, the expedite
charge, and the freight charge. I fixed this by creating a running total
that resets on change of POLineNum. This fixed that problem but created
another problem which I can't seem to solve.
In this invoice we have multiple lots that are grouped so that they will
display as a single line item(The customer wants to see quantity 100 not
27,56, and 17). But, since this is in the group header I'm getting only the
first line item added to my running total and displayed. Changing this to a
group footer band fixes the problem but my misc charges are in the details
so they print before the line item instead of after it where I need them.
I am open to any suggestions!!! I have been trying to figure out how to
either display the running total after it has totalled the whole group and
leave the group in the header OR move the group to the footer and get the
misc charges to display after it.
I hope this makes since...after looking at it for several hours I'm not sure
that I even understand it anymore. If I need to clarify anything let me
know. I appreciate any suggestions.
Mark Kohring
Delta Centrifugal Corp.
MKohring@...
eGroups Sponsor
We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
[Non-text portions of this message have been removed]
Couldn't get to the Yahoo archive again, so I am posting my question here;
How do I connect with Crystal Reports to my Vantage DB? I am selecting Log
on to Server, but which server type do I pick, or how do I get Progress in
the options?
TIA,
Paul Siebers
[Non-text portions of this message have been removed]
---
## Post #6 by @system
Paul,
First you have to set up the ODBC driver. Assuming you've done that
you need to choose the ODBC data source that you set up. I don't
know what version of Crystal your using, but in Version 8 you'd click
on the Database button, then open the ODBC folder and choose the data
source. I remember it is quite different in Version 7 but I don't
remember enough to tell you what the screens were like. Hope this
helps.
Brian Stenglein
Clow Stamping Company
--- In vantage@y..., Paul Siebers <paul.siebers@b...> wrote:
> Couldn't get to the Yahoo archive again, so I am posting my
question here;
> How do I connect with Crystal Reports to my Vantage DB? I am
selecting Log
> on to Server, but which server type do I pick, or how do I get
Progress in
> the options?
>
> TIA,
>
> Paul Siebers
>
>
> [Non-text portions of this message have been removed]
Here's a question for you Crystal report guru's.
We are trying to create a report in Crystal Ver.7 with a subreport. The
reports run correctly as individual reports, but when we try to do them as
subreports it is causing the merant ODBC driver on the server to crash in
turn shutting down the Progress server.
Can anyone tell me why it does this?
Kathy Hambleton
Electron Energy Corporation
717-898-2294
kbh@...Do you have ODBC installed on the Vantage Server? And you are running the
report from the Vantage server? OR is the report being run from a client
via ODBC on the client, with the report residing on the client computer?
Troy Funte
Liberty Electronics
----- Original Message -----
From: "Kathy Hambleton" <kbh@...>
To: <vantage@yahoogroups.com>
Sent: Friday, March 23, 2001 2:15 PM
Subject: [Vantage] Crystal Reports
> Here's a question for you Crystal report guru's.
>
> We are trying to create a report in Crystal Ver.7 with a subreport. The
> reports run correctly as individual reports, but when we try to do them as
> subreports it is causing the merant ODBC driver on the server to crash in
> turn shutting down the Progress server.
>
> Can anyone tell me why it does this?
>
> Kathy Hambleton
> Electron Energy Corporation
> 717-898-2294
> kbh@...
>
>
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
What are the error messages that you are getting? Just a reminder, but
whenever anyone posts a question about error messages, it always helps to
put the error message in your post.
Ted Kitch
ted@...
-----Original Message-----
From: Kathy Hambleton [mailto:
kbh@...]
Sent: Friday, March 23, 2001 1:15 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
Here's a question for you Crystal report guru's.
We are trying to create a report in Crystal Ver.7 with a subreport. The
reports run correctly as individual reports, but when we try to do them as
subreports it is causing the merant ODBC driver on the server to crash in
turn shutting down the Progress server.
Can anyone tell me why it does this?
Kathy Hambleton
Electron Energy Corporation
717-898-2294
kbh@...
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/We have two packing slips...one with our logo and one without, that we'd
like shipping to have the ability to access when they're making a shipment.
The same applies to our Bills of Ladings.
If the capability of accessing two different packing slip documents is
relatively easy to explain, please let me hear from you. If we have to we
can wait for our consultant, but if it's something I can do myself I'd like
to try.
Sincerely,
Judy H. : )
Plitek, L.L.C.
Phone: 847-827-6680, Ext. 223
Fax: 847-827-6733
E-mail:
judy.havlik@...
Website: www.plitek.com
[Non-text portions of this message have been removed]
One option - (perhaps a bit complicated on the Crystal side without having seen your Packing slip forms), would be to merge the two reports into one, and have the user enter a parameter when the report runs. Then uses the Section Formater to Suppress sections depending on which parameter the user chooses.
This method might save you from having to hire a consultant or do some fance progress programming (which I have no idea how to do).
Troy Funte
Liberty Electronics
----- Original Message -----
From: Judy Havlik
To: vantage@yahoogroups.com
Sent: Friday, March 30, 2001 9:10 AM
Subject: [Vantage] Crystal Reports
We have two packing slips...one with our logo and one without, that we'd
like shipping to have the ability to access when they're making a shipment.
The same applies to our Bills of Ladings.
If the capability of accessing two different packing slip documents is
relatively easy to explain, please let me hear from you. If we have to we
can wait for our consultant, but if it's something I can do myself I'd like
to try.
Sincerely,
Judy H. : )
Plitek, L.L.C.
Phone: 847-827-6680, Ext. 223
Fax: 847-827-6733
E-mail: judy.havlik@...
Website: www.plitek.com
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Click Here to Find Software Faster
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Judy,
There is a utility you can purchase from Caesar Developments which gives you
this very thing. It is called the Multi Form Print Utilty. We purchased it
here because it allows emailing of forms from Vantage, but since we also
began using the multi-form option. The way it works is that when someone
presses the print button on a form, a drop-down list comes up which lets
them choose which form they want. Works great! Check out their web-site...
http://www.caesardev.com
-Sarah
If you have a version of Crystal with report distribution or download the
distribution facility for Crystal 8.0 or 8.5 you can create a second version
of the Packing Slips with no logo and distribute it to the PCs that need it.
They would have to run the logoless version from a favorites item after
print previewing the regular one (to create the .dbf files). Modifying the
form to remove the logo would be very easy. Setting up the distributed
report is pretty easy if you run the distribution files from a server to get
the .dlls etc.. loaded on the PC. Pluses - its free and fast. Minuses -
ongoing admin issues and an extra step to run (the preview step).
-Todd C.
Harvey Vogel Mfg. Co.
-----Original Message-----
From: Judy Havlik [mailto:
judy.havlik@...]
Sent: Friday, March 30, 2001 8:10 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
We have two packing slips...one with our logo and one without, that we'd
like shipping to have the ability to access when they're making a shipment.
The same applies to our Bills of Ladings.
If the capability of accessing two different packing slip documents is
relatively easy to explain, please let me hear from you. If we have to we
can wait for our consultant, but if it's something I can do myself I'd like
to try.
Sincerely,
Judy H. : )
Plitek, L.L.C.
Phone: 847-827-6680, Ext. 223
Fax: 847-827-6733
E-mail:
judy.havlik@...
Website: www.plitek.com
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=162801.1342103.2934627.1280005/D=egroupmail/S=1700007
183:N/A=599089/*
http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLer
t_ComputersInternet_Software_WhiteGridOptions&t=ad> Click Here to Find
Software Faster
Click Here to Find Software Faster
<
http://us.adserver.yahoo.com/l?M=162801.1342103.2934627.1280005/D=egroupmai
l/S=1700007183:N/A=599089/rand=945798687>
To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<
http://groups.yahoo.com/group/vantage/files/.> Note: You must have
already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<
http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Judy
You could use a VB variable to control whether the logo prints.
Shipping could check or uncheck a box on the packing slip and a
formula in the Crystal report would conditionally supress the logo
or section.
On 30 Mar 2001, at 8:10, Judy Havlik wrote:
We have two packing slips...one with our logo and one
without, that we'd
like shipping to have the ability to access when
they're making a shipment.
The same applies to our Bills of Ladings.
If the capability of accessing two different packing
slip documents is
relatively easy to explain, please let me hear from
you. If we have to we
can wait for our consultant, but if it's something I
can do myself I'd like
to try.
Sincerely,
Judy H. : )
Plitek, L.L.C.
Phone: 847-827-6680, Ext. 223
Fax: 847-827-6733
E-mail: judy.havlik@...
Website: www.plitek.com
[Non-text portions of this message have been removed]
Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
Does anyone have a Crystal Report that is used to print travelers. I
would like it to mimic the Traveler done in Progress that came with
Vantage. I need to to print in portrait. Any help would be
appreciated.
Chuck
---
## Post #16 by @system
The standard package comes with a crystal job traveler....
Mine is heavily modified, which you may have a copy of, but I'm not sure
what you want with regard to a progress version.
Please advise.
Rick Gors
MR/MMIS
Osco
chuck_metcalf@... wrote:
> Does anyone have a Crystal Report that is used to print travelers. I
> would like it to mimic the Traveler done in Progress that came with
> Vantage. I need to to print in portrait. Any help would be
> appreciated.
> Chuck
>
>
> Yahoo! Groups Sponsor
[Image]
>
> 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]
Morning all:
Scenario example:
2 tables linked in a Crystal Report, a header table with a detail
table (this is a one-to-many scenario.......many detail records).
Question:
Does anyone know how to make Crystal Reports select only the
FIRST detail record off of the Header record ?
Thanks in advance.
Gary L. Kacher
Database Manager
Giddens Industries
glk@...Gary,
If your goal is to simply get the first record in the list, you could do the following.
Enter the fields in the details section of Crystal.
Sort the fields so that the one you want to see is last on the list in the details section.
Now place the same fields in the report footer (or Group footer if you are grouping by PO or Order).
Now HIDE the details section.
The result will be that the last record will show up in the Footer.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Gary Kacher
To: 'vantage@yahoogroups.com'
Sent: Friday, October 05, 2001 10:36 AM
Subject: [Vantage] Crystal Reports
Morning all:
Scenario example:
2 tables linked in a Crystal Report, a header table with a detail
table (this is a one-to-many scenario.......many detail records).
Question:
Does anyone know how to make Crystal Reports select only the
FIRST detail record off of the Header record ?
Thanks in advance.
Gary L. Kacher
Database Manager
Giddens Industries
glk@...
Yahoo! Groups Sponsor
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]
When I want to do this in Report Builder, I just make sure the details are
sorted so that the record I want will always be first, I then drag the
detail fields into the header group band line and suppress all details. It
works for me in RB, I would guess it would be the same in Crystal, but
haven't tried it.
---
## Post #20 by @system
That won't work in my case. The QuoteQty record has a one-to-many relationship
with the QuoteDtl record and the quantity amount can vary so there wouldn't be
any way to sort them logically in order to have the first records (with different
quantities) turn out to be the last read. Thanks.
Gary L. Kacher
Database Manager
Giddens Industries
glk@...
----------
From: Troy Funte
Reply To:
vantage@yahoogroups.com
Sent: Friday, October 05, 2001 11:47 AM
To:
vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports
Gary,
If your goal is to simply get the first record in the list, you could do the following.
Enter the fields in the details section of Crystal.
Sort the fields so that the one you want to see is last on the list in the details section.
Now place the same fields in the report footer (or Group footer if you are grouping by PO or Order).
Now HIDE the details section.
The result will be that the last record will show up in the Footer.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Gary Kacher
To: 'vantage@yahoogroups.com'
Sent: Friday, October 05, 2001 10:36 AM
Subject: [Vantage] Crystal Reports
Morning all:
Scenario example:
2 tables linked in a Crystal Report, a header table with a detail
table (this is a one-to-many scenario.......many detail records).
Question:
Does anyone know how to make Crystal Reports select only the
FIRST detail record off of the Header record ?
Thanks in advance.
Gary L. Kacher
Database Manager
Giddens Industries
glk@...
Yahoo! Groups Sponsor
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:
[Non-text portions of this message have been removed]
We are trying to get the customer contact name and phone number to appear on
the Sales Acknowledgement. The name is no problem, but the phone number is
not anywhere to be found in the default table set-up. Does anyone in our
group have any insight on how to accomplish this??
Best Regards,
Pablo Garza
Dix Metals, Inc.
pgarza@...I am trying to add CR reports to the Vantage Mainmenu. Does anyone
know how this is done?
---
## Post #23 by @system
---
## Post #24 by @system
HI,
Is anyone using Cystal Reports "BY EPICOR" to generate reports
from Vantage?
---
## Post #25 by @system
Yes.
David Gartner
EPG Companies Inc.
Vantage 5.20.205, Progress 9.1c
-----Original Message-----
From: tryadd2 [mailto:
dgergen@...]
Sent: Wednesday, July 31, 2002 10:01 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
HI,
Is anyone using Cystal Reports "BY EPICOR" to generate reports
from Vantage?
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]
Hey Dave,
I see your on 5.2. How do you like it? Anything we should watch out for?
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: David M Gartner [mailto:
dgartner@...]
Sent: Wednesday, July 31, 2002 10:38 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Yes.
David Gartner
EPG Companies Inc.
Vantage 5.20.205, Progress 9.1c
-----Original Message-----
From: tryadd2 [mailto:
dgergen@...]
Sent: Wednesday, July 31, 2002 10:01 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
HI,
Is anyone using Cystal Reports "BY EPICOR" to generate reports
from Vantage?
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]
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
http://docs.yahoo.com/info/terms/Let's just say things have been better... I really can't comment as I await
a patch yet released. Plus, we are not fully utilizing most modules of
Vantage. The CRM does look promising and is what we thought we were buying
originally. The patch (hot fix?) I imagine will save you the trouble I had.
Gosh, I really think I am starting to get bitter. Thanks everyone for all
the insight you provide.
David Gartner
EPG Companies Inc.
Vantage 5.20.205, Progress 9.1c
-----Original Message-----
From: Leonard, Jeremy [mailto:
jleonard@...]
Sent: Wednesday, July 31, 2002 10:49 AM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
Hey Dave,
I see your on 5.2. How do you like it? Anything we should watch out for?
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: David M Gartner [mailto:
dgartner@...]
Sent: Wednesday, July 31, 2002 10:38 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Yes.
David Gartner
EPG Companies Inc.
Vantage 5.20.205, Progress 9.1c
-----Original Message-----
From: tryadd2 [mailto:
dgergen@...]
Sent: Wednesday, July 31, 2002 10:01 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
HI,
Is anyone using Cystal Reports "BY EPICOR" to generate reports
from Vantage?
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]
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
http://docs.yahoo.com/info/terms/
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]
Sorry to hear about your troubles. If it helps, I know how you feel. I
used to be a SQL Customer.
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: David M Gartner [mailto:
dgartner@...]
Sent: Wednesday, July 31, 2002 11:02 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Let's just say things have been better... I really can't comment as I await
a patch yet released. Plus, we are not fully utilizing most modules of
Vantage. The CRM does look promising and is what we thought we were buying
originally. The patch (hot fix?) I imagine will save you the trouble I had.
Gosh, I really think I am starting to get bitter. Thanks everyone for all
the insight you provide.
David Gartner
EPG Companies Inc.
Vantage 5.20.205, Progress 9.1c
-----Original Message-----
From: Leonard, Jeremy [mailto:
jleonard@...]
Sent: Wednesday, July 31, 2002 10:49 AM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
Hey Dave,
I see your on 5.2. How do you like it? Anything we should watch out for?
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: David M Gartner [mailto:
dgartner@...]
Sent: Wednesday, July 31, 2002 10:38 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Yes.
David Gartner
EPG Companies Inc.
Vantage 5.20.205, Progress 9.1c
-----Original Message-----
From: tryadd2 [mailto:
dgergen@...]
Sent: Wednesday, July 31, 2002 10:01 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
HI,
Is anyone using Cystal Reports "BY EPICOR" to generate reports
from Vantage?
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]
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
http://docs.yahoo.com/info/terms/
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]
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
http://docs.yahoo.com/info/terms/We've just recently started using Report Builder and have already found some
bottlenecks. I know Crystal Reports is more powerful and I also know we have
it but right now we are just using it to modify our forms. Can someone
e-mail me offline to give me step-by-step instructions on how to connect
Crystal with the Vantage tables?
Thanks in advance
Fredy Venczel
dhX
*
fvenczel@... <mailto:
fvenczel@...>
*
http://www.xebecinc.com <
http://www.xebecinc.com/>
I would like to learn that too! Plus what's the best way to learn Crystal reports, does Epicor have classes for that?
Jim Horton
Mol-Son, Inc.
-----Original Message-----
From: Fredy Venczel [mailto:
fvenczel@...]
Sent: Thursday, October 10, 2002 8:22 AM
To: '
vantage@yahoogroups.com'
Subject: [Vantage] Crystal Reports
We've just recently started using Report Builder and have already found some
bottlenecks. I know Crystal Reports is more powerful and I also know we have
it but right now we are just using it to modify our forms. Can someone
e-mail me offline to give me step-by-step instructions on how to connect
Crystal with the Vantage tables?
Thanks in advance
Fredy Venczel
Fredy and Jim,
I have a document for Vantage 5.1 to set up ODBC. However I would suggest contacting Epicor for this document to get the latest/greatest. Things may have changed that I don't know about in 5.2. Let me know if you need what I have, though.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Fredy Venczel
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 8:21 AM
Subject: [Vantage] Crystal Reports
We've just recently started using Report Builder and have already found some
bottlenecks. I know Crystal Reports is more powerful and I also know we have
it but right now we are just using it to modify our forms. Can someone
e-mail me offline to give me step-by-step instructions on how to connect
Crystal with the Vantage tables?
Thanks in advance
Fredy Venczel
dhX
* fvenczel@... <mailto:fvenczel@...>
* http://www.xebecinc.com <http://www.xebecinc.com/>
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]
Does anyone have an example of progress code that prints a Crystal
Report? I would like to create some reports the same way the Crystals that
come with Vantage are created(Using Progress to export to a dbf and then
call up a report based on the dbf's).
Bart Sgroi
[Non-text portions of this message have been removed]
---
## Post #35 by @system
I am trying to print out labels for each line item on a packing
slip. I have accomplished this task and now I must print labels
based on the quantity on that line item. In other words, if we ship
four of something it should print four labels.
This is my first experience with Crystal and I sure could use some
help!
Thanks,
Doug Oswald
MIS
Fleetwood Fixtures
---
## Post #36 by @system
Are you modifying the canned crystal report for shipping labels?
Do you work with large or small shipment quantities?
[Non-text portions of this message have been removed]
---
## Post #37 by @system
Have you tried changing the # of packages field on the Shipping detail line
item to the # of parts you are shipping (i.e. the # of labels you want)?
[Non-text portions of this message have been removed]
---
## Post #38 by @system
I am using an all new Crystal Report to print on an Avery 5163
label. They are 2" x 4".
--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> Have you tried changing the # of packages field on the Shipping
detail line
> item to the # of parts you are shipping (i.e. the # of labels you
want)?
>
>
>
> [Non-text portions of this message have been removed]
If you use the Std vantage report and change the # of packages field on the
line item to the qty of labels you want, it works correctly.
I don't use this feature of vantage, but if I were you I'd try modifying the
vantage report, or try to figure out how it's using that # of packages field
(Shipdtl.Packages), and instruct your users to modify that field to match
the qty.
[Non-text portions of this message have been removed]
---
## Post #40 by @system
I believe what you are looking for here:
http://support.crystaldecisions.com/library/kbase/articles/c2001548.asp
It is not ideal, but has works well after you set it up.
Good Luck,
Adam Ellis
Senior Consultant - SaberLogic, LLC
661-B Weber Dr.
Wadsworth, OH 44281
Phone: (330) 335-6442 x 104
Cell Phone: (330) 697-3883
Doug Oswald wrote:
>I am using an all new Crystal Report to print on an Avery 5163
>label. They are 2" x 4".
>
>
>
>
>
>--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
>
>
>>Have you tried changing the # of packages field on the Shipping
>>
>>
>detail line
>
>
>>item to the # of parts you are shipping (i.e. the # of labels you
>>
>>
>want)?
>
>
>>
>>[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
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
That way works, but what label is that formatted for?
--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> If you use the Std vantage report and change the # of packages
field on the
> line item to the qty of labels you want, it works correctly.
>
> I don't use this feature of vantage, but if I were you I'd try
modifying the
> vantage report, or try to figure out how it's using that # of
packages field
> (Shipdtl.Packages), and instruct your users to modify that field
to match
> the qty.
>
>
>
> [Non-text portions of this message have been removed]
Last week we had an AR Credit Memo that was transferred from one group to
another. This group with only the Credit Memo was posted. The clerk did
not review the Edit List before confirming the posting. The Edit List shows
one line item for -2 with a unit price of 146.19. The report then shows a
Subtotal of -292.38 but a Total of -584.76. When the group posted there is
a credit to AR for 584.76 and a debit to Sales Returns for 292.38. Has
anyone else had a problem with out of balance postings? Also, is there a
quick way to correct this?
Thanks,
Michael Benedict
IS Manager
Crestview Aerospace Corp.
---
## Post #43 by @system
Have you run a g/l report? Is the G/L out of balance?
If not, you just need to locate the other account that the entry was posted
to and just do a journal entry to correct the problem.
If your G/L is out of balance, then you need to post a one sided journal
entry.
In the company configuration under g/l you can allow out of balance entries.
I urge you to not allow this to be checked, but if you do need to re-balance
the g/l you can use it then uncheck it.
Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com
-----Original Message-----
From: Michael Benedict [mailto:
mbenedict@...]
Sent: Monday, March 03, 2003 10:52 AM
To:
vantage@yahoogroups.com
Subject: [Vantage] Out of Balance AR Posting
Last week we had an AR Credit Memo that was transferred from one group to
another. This group with only the Credit Memo was posted. The clerk did
not review the Edit List before confirming the posting. The Edit List shows
one line item for -2 with a unit price of 146.19. The report then shows a
Subtotal of -292.38 but a Total of -584.76. When the group posted there is
a credit to AR for 584.76 and a debit to Sales Returns for 292.38. Has
anyone else had a problem with out of balance postings? Also, is there a
quick way to correct this?
Thanks,
Michael Benedict
IS Manager
Crestview Aerospace Corp.
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
http://docs.yahoo.com/info/terms/Is there a way to insert Crystal Reports into the vantage menu like
you can with Report Builder Reports?
Thanks in advance for your help!
---
## Post #45 by @system
---
## Post #46 by @system
---
## Post #47 by @system
---
## Post #48 by @system
Better if I dig up the URL I had for it. I know I had emailed it to someone else once. Don't want angry lawyers. ;) I'll post the link as soon as I find it.
-Todd C.
-----Original Message-----
From: Cheryl Rigsbee [mailto:
Cherylr@...]
Sent: Wednesday, September 17, 2003 9:18 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Todd,
I am not finding the distribution wizard on the web. Can you send it to me?
C
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Friday, September 12, 2003 4:08 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I use the reports distirbution wizard downloaded from Seagate/Crystal Decisions (free) and then add a link on the favorites bar for the person needing it. But the distribution wizard is going away in favor of web reports which is another way of doing it if you have a web server.
-Todd C.
-----Original Message-----
From: crigsbee1 [mailto:
Cherylr@...]
Sent: Friday, September 12, 2003 1:56 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
Is there a way to insert Crystal Reports into the vantage menu like
you can with Report Builder Reports?
Thanks in advance for your help!
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=334411211>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323&partid=3856299> &partid=3856299> click here
<
http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmail/S=:HM/A=1754451/rand=619957661>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1732161/rand=408210454>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
thanks for your help!
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Wednesday, September 17, 2003 10:25 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Better if I dig up the URL I had for it. I know I had emailed it to someone else once. Don't want angry lawyers. ;) I'll post the link as soon as I find it.
-Todd C.
-----Original Message-----
From: Cheryl Rigsbee [mailto:
Cherylr@...]
Sent: Wednesday, September 17, 2003 9:18 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Todd,
I am not finding the distribution wizard on the web. Can you send it to me?
C
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Friday, September 12, 2003 4:08 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I use the reports distirbution wizard downloaded from Seagate/Crystal Decisions (free) and then add a link on the favorites bar for the person needing it. But the distribution wizard is going away in favor of web reports which is another way of doing it if you have a web server.
-Todd C.
-----Original Message-----
From: crigsbee1 [mailto:
Cherylr@...]
Sent: Friday, September 12, 2003 1:56 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
Is there a way to insert Crystal Reports into the vantage menu like
you can with Report Builder Reports?
Thanks in advance for your help!
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=334411211>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323&partid=3856299> &partid=3856299> &partid=3856299> click here
<
http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmail/S=:HM/A=1754451/rand=619957661>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509 <
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> &media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1732161/rand=408210454>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1732161/rand=697919463>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Here is the link I used:
http://support.crystaldecisions.com/communityCS/FilesAndUpdates/scr8_distr_expert.exe.asp
-Todd C.
-----Original Message-----
From: Cheryl Rigsbee [mailto:
Cherylr@...]
Sent: Wednesday, September 17, 2003 9:28 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
thanks for your help!
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Wednesday, September 17, 2003 10:25 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Better if I dig up the URL I had for it. I know I had emailed it to someone else once. Don't want angry lawyers. ;) I'll post the link as soon as I find it.
-Todd C.
-----Original Message-----
From: Cheryl Rigsbee [mailto:
Cherylr@...]
Sent: Wednesday, September 17, 2003 9:18 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Todd,
I am not finding the distribution wizard on the web. Can you send it to me?
C
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Friday, September 12, 2003 4:08 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I use the reports distirbution wizard downloaded from Seagate/Crystal Decisions (free) and then add a link on the favorites bar for the person needing it. But the distribution wizard is going away in favor of web reports which is another way of doing it if you have a web server.
-Todd C.
-----Original Message-----
From: crigsbee1 [mailto:
Cherylr@...]
Sent: Friday, September 12, 2003 1:56 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
Is there a way to insert Crystal Reports into the vantage menu like
you can with Report Builder Reports?
Thanks in advance for your help!
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=334411211>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323&partid=3856299> &partid=3856299> &partid=3856299> &partid=3856299> click here
<
http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmail/S=:HM/A=1754451/rand=619957661>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509 <
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509 <
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> &media=atkins> &media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1732161/rand=408210454>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509 <
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> &media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1732161/rand=697919463>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1732161/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1732161/rand=106133519>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
No, unless the report you are distributing uses ODBC. None of our reports use ODBC so this has never been an issue. I use the distribution wizard for reports that use the DBF files. In particular I have separated all shipping info from the Job Traveler and made a new 'Shipping Advisor". Order releases change so much it was a extra work to re-print all the shop operation pages so I made two reports. When they need a new ship advisor they print preview the traveler, bail out and run the distributed ship advisor from the favorites bar. I use the same method for printing a sheet of WIP bin labels they stick on bin cards - all driven from traveler DBFs. Probably as much work for the user as logging in to ODBC but at the time it was less costly than adding ODBC seats.
-Todd C.
-----Original Message-----
From: Cheryl Rigsbee [mailto:
Cherylr@...]
Sent: Thursday, September 18, 2003 3:10 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Todd,
Does each user have to have a login for ODBC to get the report to run from the favorites menu? Isn't that kind of a pain to the users?
C
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Friday, September 12, 2003 4:08 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I use the reports distirbution wizard downloaded from Seagate/Crystal Decisions (free) and then add a link on the favorites bar for the person needing it. But the distribution wizard is going away in favor of web reports which is another way of doing it if you have a web server.
-Todd C.
-----Original Message-----
From: crigsbee1 [mailto:
Cherylr@...]
Sent: Friday, September 12, 2003 1:56 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
Is there a way to insert Crystal Reports into the vantage menu like
you can with Report Builder Reports?
Thanks in advance for your help!
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=334411211>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323&partid=3856299> &partid=3856299> click here
<
http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmail/S=:HM/A=1754451/rand=619957661>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1754016/R=0/SIG=11pv1u2ju/*http://www.ediets.com/start.cfm?code=30529&media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1754016/rand=810036902>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Thanks for the info! It was very helpful!
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Friday, September 19, 2003 8:50 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
No, unless the report you are distributing uses ODBC. None of our reports use ODBC so this has never been an issue. I use the distribution wizard for reports that use the DBF files. In particular I have separated all shipping info from the Job Traveler and made a new 'Shipping Advisor". Order releases change so much it was a extra work to re-print all the shop operation pages so I made two reports. When they need a new ship advisor they print preview the traveler, bail out and run the distributed ship advisor from the favorites bar. I use the same method for printing a sheet of WIP bin labels they stick on bin cards - all driven from traveler DBFs. Probably as much work for the user as logging in to ODBC but at the time it was less costly than adding ODBC seats.
-Todd C.
-----Original Message-----
From: Cheryl Rigsbee [mailto:
Cherylr@...]
Sent: Thursday, September 18, 2003 3:10 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Todd,
Does each user have to have a login for ODBC to get the report to run from the favorites menu? Isn't that kind of a pain to the users?
C
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Friday, September 12, 2003 4:08 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I use the reports distirbution wizard downloaded from Seagate/Crystal Decisions (free) and then add a link on the favorites bar for the person needing it. But the distribution wizard is going away in favor of web reports which is another way of doing it if you have a web server.
-Todd C.
-----Original Message-----
From: crigsbee1 [mailto:
Cherylr@...]
Sent: Friday, September 12, 2003 1:56 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports
Is there a way to insert Crystal Reports into the vantage menu like
you can with Report Builder Reports?
Thanks in advance for your help!
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556 <
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM> &lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=334411211>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323 <
http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mqso=60178323&partid=3856299> &partid=3856299> &partid=3856299> click here
<
http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egroupmail/S=:HM/A=1754451/rand=619957661>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1754016/R=0/SIG=11pv1u2ju/*http://www.ediets.com/start.cfm?code=30529 <
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1754016/R=0/SIG=11pv1u2ju/*http://www.ediets.com/start.cfm?code=30529&media=atkins> &media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1754016/rand=810036902>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705007183:HM/A=1706996/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=30509&media=atkins> click here
<
http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egroupmail/S=:HM/A=1706996/rand=617488453>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Hello Everyone!
I finally have my ODBC connection and I have been working on a
report, but I keep getting the following error.....
---------------------------
Crystal Reports: Database Error
---------------------------
ODBC error: [MERANT][ODBC PROGRESS driver][PROGRESS]Unable to
allocate disk block for temp table use [MM - No data block] (7631)
---------------------------
OK
---------------------------
Any ideas?
Thanks in advance for any help that you can provide!
Cheryl
---
## Post #56 by @system
BlankWe are going to upgrade to version 6 from Version 4 of vantage soon and
I need to check into getting an upgrade to my 8.0 Crystal. What version
will I need for Vantage 6.0?
Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone 309-752-1381
Fax: 309-752-1382
Email:
cnunn@...
[Non-text portions of this message have been removed]
Good Morning:
I am trying to run a crystal report against one of my companies in
Crystal and I am getting the following two errors. ODBC Error:
[Merant][ODBC Progress driver][Progress]Accessed Denied(Authorization
Failed)(7512). I then click 'OK' and get another error message
stating Error Detected by Database DLL. There is one doc on the
Eportal, but it references the second error and I checked to make
sure my local client has up to date dll's. I have successfully ran
the same crystal report against three other databases, but can't seem
to run it against this one. Any help would be greatly appreciated.
Thanks,
Mark
---
## Post #60 by @system
---
## Post #61 by @system
The Part.SearchWord field is populated with the first eight characters of
the part description when you add an item, by default. Unless you are using
SearchWord for some other purpose and the entry person changes the contents,
it may already contain the keyword you need.
Jim Stetter
IT Manager
Snow Filtration, a division of Reemay, Inc.
<mailto:
jstetter@...>
jstetter@...
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Friday, November 14, 2003 12:15 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Crystal Reports
In Progress I had a report filtered - part description begins with
'accumulator*'.
I am trying to create this report in Crystal (actually all reports in
crystal as preparation for the loss of progress) and you can't sort or
filter on a memo field which is what part description is.
Does anyone have any suggestions for a workaround? I considered a vb
field with the word accumulator but I would hate to have to go back and
type in all the entries.
Thank you
Patty
EFS Aerospace
Please note: This message may contain information which is privileged and confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
[Non-text portions of this message have been removed]
Thank you all!
-----Original Message-----
From:
jstetter@... [mailto:
jstetter@...]
Sent: Friday, November 14, 2003 10:21 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Crystal Reports
The Part.SearchWord field is populated with the first eight characters
of
the part description when you add an item, by default. Unless you are
using
SearchWord for some other purpose and the entry person changes the
contents,
it may already contain the keyword you need.
Jim Stetter
IT Manager
Snow Filtration, a division of Reemay, Inc.
<mailto:
jstetter@...>
jstetter@...
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Friday, November 14, 2003 12:15 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Crystal Reports
In Progress I had a report filtered - part description begins with
'accumulator*'.
I am trying to create this report in Crystal (actually all reports in
crystal as preparation for the loss of progress) and you can't sort or
filter on a memo field which is what part description is.
Does anyone have any suggestions for a workaround? I considered a vb
field with the word accumulator but I would hate to have to go back and
type in all the entries.
Thank you
Patty
EFS Aerospace
Please note: This message may contain information which is privileged
and confidential. If you are not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12ca3eav9/M=267637.4116719.5338353.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1068920478/A=1853619/R=0/*http:/www.netflix.
com/Default?mqso=60178356&partid=4116719> click here
<
http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egrou
pmail/S=:HM/A=1853619/rand=548221976>
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/.
<
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!
<
http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Well I now have my report all nice and pretty (thank you all for the
tips). Is there a way to print the report from the Vantage Menu? Tech
said I need to purchase a ProVision Utility from my sales rep. Any idea
how much this costs? Or if there is another way?
Thank you again
Patty
EFS Aerospace, Inc.
[Non-text portions of this message have been removed]
---
## Post #64 by @system
---
## Post #65 by @system
---
## Post #66 by @system
I believe that is Crystal Enterprise which ships with a limited license with Crystal Report 8.5. Something like allowing 5 concurrent users which in a small company is adequate. Otherewise I think it was really expensive beyond that. See chapter 7 in CR 8.5 User's Guide. We are not doing this yet but I think there were several others on this list using it.
-Todd C.
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Monday, November 17, 2003 7:46 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
What is the new option instead of report distribution.
Jasper
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Monday, November 17, 2003 8:39 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
It's a step backward but you can still use report distribution with Crystal 8.5. You have to download the free distribution wizard from the Crystal web site. When run it packages a report and all the required DLLs with a setup routine so it can be installed on the user's PC. Then it can then be run from their favorites bar. Although I think it could be added to the menus as well (I've done this for Acrobat Reader PDF document access) it might not be wise because only users who have had the report distributed to them could run it anyway - might as well put in favorites for just those people.
Report distribution goes away with Crystal 9.0 but on the other hand with the .Net user interface in Sonoma it may become a lot easier to link to Crystal web distributed reports.
-Todd C.
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Friday, November 14, 2003 2:03 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
Well I now have my report all nice and pretty (thank you all for the
tips). Is there a way to print the report from the Vantage Menu? Tech
said I need to purchase a ProVision Utility from my sales rep. Any idea
how much this costs? Or if there is another way?
Thank you again
Patty
EFS Aerospace, Inc.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c4vvfvp/M=243273.4156324.5364586.1261774/D=egroupweb/S=1705007183:HM/EXP=1068926646/A=1750744/R=0/*http://servedby.advertising.com/click/site=552006/bnum=1068840246466960> Click to learn more...
<
http://us.adserver.yahoo.com/l?M=243273.4156324.5364586.1261774/D=egroupmail/S=:HM/A=1750744/rand=934881700>
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 <
http://docs.yahoo.com/info/terms/> .
[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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c0g2kvs/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705007183:HM/EXP=1069163190/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116730> click here
<
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1853619/rand=592075499>
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 <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
It is a very simple exercise to compile the report using the Crystal Viewer
VB 6 component or the VS .NET viewer. In either case all you are left with
is a single executable that doesn't require the distribution of runtime
.dll's.
Michael
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Monday, November 17, 2003 5:53 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
I believe that is Crystal Enterprise which ships with a limited license with
Crystal Report 8.5. Something like allowing 5 concurrent users which in a
small company is adequate. Otherewise I think it was really expensive
beyond that. See chapter 7 in CR 8.5 User's Guide. We are not doing this
yet but I think there were several others on this list using it.
-Todd C.
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Monday, November 17, 2003 7:46 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
What is the new option instead of report distribution.
Jasper
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Monday, November 17, 2003 8:39 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
It's a step backward but you can still use report distribution with Crystal
8.5. You have to download the free distribution wizard from the Crystal web
site. When run it packages a report and all the required DLLs with a setup
routine so it can be installed on the user's PC. Then it can then be run
from their favorites bar. Although I think it could be added to the menus
as well (I've done this for Acrobat Reader PDF document access) it might not
be wise because only users who have had the report distributed to them could
run it anyway - might as well put in favorites for just those people.
Report distribution goes away with Crystal 9.0 but on the other hand with
the .Net user interface in Sonoma it may become a lot easier to link to
Crystal web distributed reports.
-Todd C.
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Friday, November 14, 2003 2:03 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
Well I now have my report all nice and pretty (thank you all for the tips).
Is there a way to print the report from the Vantage Menu? Tech said I need
to purchase a ProVision Utility from my sales rep. Any idea how much this
costs? Or if there is another way?
Thank you again
Patty
EFS Aerospace, Inc.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c4vvfvp/M=243273.4156324.5364586.1261774/D=egroupw
eb/S=1705007183:HM/EXP=1068926646/A=1750744/R=0/*
http://servedby.advertising
.com/click/site=552006/bnum=1068840246466960> Click to learn more...
<
http://us.adserver.yahoo.com/l?M=243273.4156324.5364586.1261774/D=egroupmail
/S=:HM/A=1750744/rand=934881700>
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 <
http://docs.yahoo.com/info/terms/> .
[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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c0g2kvs/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1069163190/A=1853619/R=0/*
http://www.netflix.com/Def
ault?mqso=60178356&partid=4116730> click here
<
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1853619/rand=592075499>
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
<
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
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
http://docs.yahoo.com/info/terms/A couple of issues have made me reluctant/hesitant to switch from
Report Builder to Crystal Reports: attaching a Crystal Report to
Vantage menu and running from a Progress program.
I think I had a breakthrough Friday.
I'm currently TRYING to write a Progress program that will prompt
user and create a compiled Progress procedure, say CRReportName.r,
that CAN BE ATTACHED TO THE VANTAGE MENU. When selected, it should
preview the report with real-time data.
Has anyone tried this and what problems can I expect?
Lonnie
--- In vantage@yahoogroups.com, "Michael Barry" <mbarry@b...> wrote:
> It is a very simple exercise to compile the report using the
Crystal Viewer
> VB 6 component or the VS .NET viewer. In either case all you are
left with
> is a single executable that doesn't require the distribution of
runtime
> .dll's.
>
> Michael
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Monday, November 17, 2003 5:53 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
>
> I believe that is Crystal Enterprise which ships with a limited
license with
> Crystal Report 8.5. Something like allowing 5 concurrent users
which in a
> small company is adequate. Otherewise I think it was really
expensive
> beyond that. See chapter 7 in CR 8.5 User's Guide. We are not
doing this
> yet but I think there were several others on this list using it.
> -Todd C.
>
> -----Original Message-----
> From: Jasper Recto [mailto:jrecto@l...]
> Sent: Monday, November 17, 2003 7:46 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
>
>
> What is the new option instead of report distribution.
> Jasper
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Monday, November 17, 2003 8:39 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
>
>
> It's a step backward but you can still use report distribution with
Crystal
> 8.5. You have to download the free distribution wizard from the
Crystal web
> site. When run it packages a report and all the required DLLs with
a setup
> routine so it can be installed on the user's PC. Then it can then
be run
> from their favorites bar. Although I think it could be added to
the menus
> as well (I've done this for Acrobat Reader PDF document access) it
might not
> be wise because only users who have had the report distributed to
them could
> run it anyway - might as well put in favorites for just those
people.
>
> Report distribution goes away with Crystal 9.0 but on the other
hand with
> the .Net user interface in Sonoma it may become a lot easier to
link to
> Crystal web distributed reports.
>
> -Todd C.
>
> -----Original Message-----
> From: patty.cioffi [mailto:patty.cioffi@e...]
> Sent: Friday, November 14, 2003 2:03 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] RE: Printing Crystal Reports from Vantage
>
>
>
> Well I now have my report all nice and pretty (thank you all for
the tips).
> Is there a way to print the report from the Vantage Menu? Tech said
I need
> to purchase a ProVision Utility from my sales rep. Any idea how
much this
> costs? Or if there is another way?
>
> Thank you again
> Patty
> EFS Aerospace, Inc.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
> <
>
http://rd.yahoo.com/SIG=12c4vvfvp/M=243273.4156324.5364586.1261774/D=e
groupw
>
eb/S=1705007183:HM/EXP=1068926646/A=1750744/R=0/*http://servedby.adver
tising
> .com/click/site=552006/bnum=1068840246466960> Click to learn
more...
> <
> http://us.adserver.yahoo.com/l?
M=243273.4156324.5364586.1261774/D=egroupmail
> /S=:HM/A=1750744/rand=934881700>
>
> 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
<
> http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [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
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/SIG=12c0g2kvs/M=267637.4116730.5333196.1261774/D=
egroup
>
web/S=1705007183:HM/EXP=1069163190/A=1853619/R=0/*http://www.netflix.c
om/Def
> ault?mqso=60178356&partid=4116730> click here
>
> <http://us.adserver.yahoo.com/l?
M=267637.4116730.5333196.1261774/D=egroupmai
> l/S=:HM/A=1853619/rand=592075499>
>
> 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
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor ---------------------
~--> Buy
> Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer
> at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
> http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
> --------------------------------------------------------------------
-~->
>
> 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
http://docs.yahoo.com/info/terms/
Lonnie,
I was sent this information the other day on setting up crystal reports in a Vantage menu. Hope it helps!
--------------------------------------------------------------------------
How to add a compiled Crystal Report as a Vantage menu option.
The following procedure will allow you to call a compiled Crystal Report
(.EXE) from a Vantage menu option. This will allow you to use Vantage menu
security to control user access to these reports.
Step #1: Create a Progress program (.W) file to call the Crystal Report
.EXE.
This program (.W) file would contain the following code:
============================================================
DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
DEFINE INPUT PARAMETER VisualStyle AS LONG.
DEFINE RETURN PARAMETER StatusCode AS LONG.
END PROCEDURE.
/***********************************************************************
Set the ProgNamePath variable value to the location\Crystal Report's .EXE
***********************************************************************/
ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
=====================================================================
The example above shows how a "Scrap By Reason Detail.Exe" would be called.
Include the full path to the compile report .exe.
Save this file as UD<Compile ReportName>.W and eliminate the spaces.
For example: Scrap By Reason Detail.exe "save as" UDScrapByReasonDetail.w
Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD folder.
Step #3: Use Vantage Menu Structure Maintenance to add a new menu option to
call the UD<Compile ReportName>.W
Note: Menu ID must start with UD. Any naming convention for the remaining
characters can be used.
Program must always include UD/UD<Compile Report Name>.W
---------------------------------------------------------------------------------
---
## Post #70 by @system
Jasper,
What I'm trying to do is create a compiled PROGRESS program that can
be attached to Vantage, that runs the Crystal report without
compiling the report.
This might even replace the Crystal compiler, which will disappear in
the future.
I don't know how far I'll get, but it looks promising. I just
created a R-Code file on-the-fly that previews a .RPT.
There may also be other applications - like a home-spun Crystal
Report scheduler, and Viewer, who knows.
Lonnie
--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> Lonnie,
>
> I was sent this information the other day on setting up crystal
reports in a Vantage menu. Hope it helps!
>
> --------------------------------------------------------------------
------
> How to add a compiled Crystal Report as a Vantage menu option.
>
> The following procedure will allow you to call a compiled Crystal
Report
> (.EXE) from a Vantage menu option. This will allow you to use
Vantage menu
> security to control user access to these reports.
>
> Step #1: Create a Progress program (.W) file to call the Crystal
Report
> .EXE.
>
> This program (.W) file would contain the following code:
> ============================================================
>
> DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
> DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
>
> PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
> DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
> DEFINE INPUT PARAMETER VisualStyle AS LONG.
> DEFINE RETURN PARAMETER StatusCode AS LONG.
> END PROCEDURE.
>
> /*******************************************************************
****
> Set the ProgNamePath variable value to the location\Crystal
Report's .EXE
>
**********************************************************************
*/
>
> ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
>
> RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
>
>
>
=====================================================================
> The example above shows how a "Scrap By Reason Detail.Exe" would be
called.
> Include the full path to the compile report .exe.
>
> Save this file as UD<Compile ReportName>.W and eliminate the spaces.
>
> For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w
>
>
>
> Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD
folder.
>
> Step #3: Use Vantage Menu Structure Maintenance to add a new menu
option to
> call the UD<Compile ReportName>.W
>
> Note: Menu ID must start with UD. Any naming convention for the
remaining
> characters can be used.
>
> Program must always include UD/UD<Compile Report Name>.W
> --------------------------------------------------------------------
-------------
I'd be very interested in that!
Jasper
-----Original Message-----
From: Lonnie Drew [mailto:
lonniedrew@...]
Sent: Monday, November 17, 2003 2:16 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Printing Crystal Reports from Vantage
Jasper,
What I'm trying to do is create a compiled PROGRESS program that can
be attached to Vantage, that runs the Crystal report without
compiling the report.
This might even replace the Crystal compiler, which will disappear in
the future.
I don't know how far I'll get, but it looks promising. I just
created a R-Code file on-the-fly that previews a .RPT.
There may also be other applications - like a home-spun Crystal
Report scheduler, and Viewer, who knows.
Lonnie
--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> Lonnie,
>
> I was sent this information the other day on setting up crystal
reports in a Vantage menu. Hope it helps!
>
> --------------------------------------------------------------------
------
> How to add a compiled Crystal Report as a Vantage menu option.
>
> The following procedure will allow you to call a compiled Crystal
Report
> (.EXE) from a Vantage menu option. This will allow you to use
Vantage menu
> security to control user access to these reports.
>
> Step #1: Create a Progress program (.W) file to call the Crystal
Report
> .EXE.
>
> This program (.W) file would contain the following code:
> ============================================================
>
> DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
> DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
>
> PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
> DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
> DEFINE INPUT PARAMETER VisualStyle AS LONG.
> DEFINE RETURN PARAMETER StatusCode AS LONG.
> END PROCEDURE.
>
> /*******************************************************************
****
> Set the ProgNamePath variable value to the location\Crystal
Report's .EXE
>
**********************************************************************
*/
>
> ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
>
> RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
>
>
>
=====================================================================
> The example above shows how a "Scrap By Reason Detail.Exe" would be
called.
> Include the full path to the compile report .exe.
>
> Save this file as UD<Compile ReportName>.W and eliminate the spaces.
>
> For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w
>
>
>
> Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD
folder.
>
> Step #3: Use Vantage Menu Structure Maintenance to add a new menu
option to
> call the UD<Compile ReportName>.W
>
> Note: Menu ID must start with UD. Any naming convention for the
remaining
> characters can be used.
>
> Program must always include UD/UD<Compile Report Name>.W
> --------------------------------------------------------------------
-------------
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 http://docs.yahoo.com/info/terms/
We've been using the Crystal Web Server that came with Crystal 8.0
for a couple of years and its working quite well. I'm able to create
a URL icon for each report, save it on our network and make a Vantage
favorite from that icon. One problem I did run into though, was that
I have a problem making that Vantage Favorite with Win2K or WinXP,
for some reason it only works with Win98. Tech support doesn't know
why and apparently doesn't care, because I'm doing an "unsupported
activity", but it works really nice, we just have to keep a 98
machine around to add/modify report favorites. We'll be going to
Vantage 6 during the Thanksgiving Holiday weekend and that means
we'll be upgrading to Crystal 8.5 which includes Crystal Enterprise,
the new version of the Crystal Web Server.
Brian Stenglein
Clow Stamping Co.
--- In
vantage@yahoogroups.com, "patty.cioffi" <patty.cioffi@e...>
wrote:
>
> Well I now have my report all nice and pretty (thank you all for the
> tips). Is there a way to print the report from the Vantage Menu?
Tech
> said I need to purchase a ProVision Utility from my sales rep. Any
idea
> how much this costs? Or if there is another way?
>
> Thank you again
> Patty
> EFS Aerospace, Inc.
>
>
>
> [Non-text portions of this message have been removed]
Well okay, here is a new twist on this thread. One of the reports that I
would like to have on the Vantage menu needs to be able to change the
selection criteria. Is there a way to make a report where the user can
change the date range each time they print without going into the
design?
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
-----Original Message-----
From: Brian Stenglein [mailto:
bstenglein@...]
Sent: Monday, November 17, 2003 12:46 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Printing Crystal Reports from Vantage
We've been using the Crystal Web Server that came with Crystal 8.0
for a couple of years and its working quite well. I'm able to create
a URL icon for each report, save it on our network and make a Vantage
favorite from that icon. One problem I did run into though, was that
I have a problem making that Vantage Favorite with Win2K or WinXP,
for some reason it only works with Win98. Tech support doesn't know
why and apparently doesn't care, because I'm doing an "unsupported
activity", but it works really nice, we just have to keep a 98
machine around to add/modify report favorites. We'll be going to
Vantage 6 during the Thanksgiving Holiday weekend and that means
we'll be upgrading to Crystal 8.5 which includes Crystal Enterprise,
the new version of the Crystal Web Server.
Brian Stenglein
Clow Stamping Co.
--- In
vantage@yahoogroups.com, "patty.cioffi" <patty.cioffi@e...>
wrote:
>
> Well I now have my report all nice and pretty (thank you all for the
> tips). Is there a way to print the report from the Vantage Menu?
Tech
> said I need to purchase a ProVision Utility from my sales rep. Any
idea
> how much this costs? Or if there is another way?
>
> Thank you again
> Patty
> EFS Aerospace, Inc.
>
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12ca15tje/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069188340/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116730> click here
<
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=126514205>
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/.
<
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!
<
http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Hello Patty,
Look in the Crystal help files for parameter fields. You might also look at
the Crystal decisions website for additional info.
http://support.crystaldecisions.com/ <
http://support.crystaldecisions.com/>
Dan Shallbetter
States Electric
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Monday, November 17, 2003 3:43 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Printing Crystal Reports from Vantage New Twist
Well okay, here is a new twist on this thread. One of the reports that I
would like to have on the Vantage menu needs to be able to change the
selection criteria. Is there a way to make a report where the user can
change the date range each time they print without going into the
design?
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
-----Original Message-----
From: Brian Stenglein [mailto:
bstenglein@...]
Sent: Monday, November 17, 2003 12:46 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Printing Crystal Reports from Vantage
We've been using the Crystal Web Server that came with Crystal 8.0
for a couple of years and its working quite well. I'm able to create
a URL icon for each report, save it on our network and make a Vantage
favorite from that icon. One problem I did run into though, was that
I have a problem making that Vantage Favorite with Win2K or WinXP,
for some reason it only works with Win98. Tech support doesn't know
why and apparently doesn't care, because I'm doing an "unsupported
activity", but it works really nice, we just have to keep a 98
machine around to add/modify report favorites. We'll be going to
Vantage 6 during the Thanksgiving Holiday weekend and that means
we'll be upgrading to Crystal 8.5 which includes Crystal Enterprise,
the new version of the Crystal Web Server.
Brian Stenglein
Clow Stamping Co.
--- In
vantage@yahoogroups.com, "patty.cioffi" <patty.cioffi@e...>
wrote:
>
> Well I now have my report all nice and pretty (thank you all for the
> tips). Is there a way to print the report from the Vantage Menu?
Tech
> said I need to purchase a ProVision Utility from my sales rep. Any
idea
> how much this costs? Or if there is another way?
>
> Thank you again
> Patty
> EFS Aerospace, Inc.
>
>
>
> [Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Parameters, knew it had to be in there somewhere!
Thank you!
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
-----Original Message-----
From: Dan Shallbetter [mailto:
dans@...]
Sent: Monday, November 17, 2003 2:31 PM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Printing Crystal Reports from Vantage New
Twist
Hello Patty,
Look in the Crystal help files for parameter fields. You might also look
at
the Crystal decisions website for additional info.
http://support.crystaldecisions.com/
<
http://support.crystaldecisions.com/>
Dan Shallbetter
States Electric
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Monday, November 17, 2003 3:43 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Printing Crystal Reports from Vantage New
Twist
Well okay, here is a new twist on this thread. One of the reports that I
would like to have on the Vantage menu needs to be able to change the
selection criteria. Is there a way to make a report where the user can
change the date range each time they print without going into the
design?
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
-----Original Message-----
From: Brian Stenglein [mailto:
bstenglein@...]
Sent: Monday, November 17, 2003 12:46 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Printing Crystal Reports from Vantage
We've been using the Crystal Web Server that came with Crystal 8.0
for a couple of years and its working quite well. I'm able to create
a URL icon for each report, save it on our network and make a Vantage
favorite from that icon. One problem I did run into though, was that
I have a problem making that Vantage Favorite with Win2K or WinXP,
for some reason it only works with Win98. Tech support doesn't know
why and apparently doesn't care, because I'm doing an "unsupported
activity", but it works really nice, we just have to keep a 98
machine around to add/modify report favorites. We'll be going to
Vantage 6 during the Thanksgiving Holiday weekend and that means
we'll be upgrading to Crystal 8.5 which includes Crystal Enterprise,
the new version of the Crystal Web Server.
Brian Stenglein
Clow Stamping Co.
--- In
vantage@yahoogroups.com, "patty.cioffi" <patty.cioffi@e...>
wrote:
>
> Well I now have my report all nice and pretty (thank you all for the
> tips). Is there a way to print the report from the Vantage Menu?
Tech
> said I need to purchase a ProVision Utility from my sales rep. Any
idea
> how much this costs? Or if there is another way?
>
> Thank you again
> Patty
> EFS Aerospace, Inc.
>
>
>
> [Non-text portions of this message have been removed]
[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/.
<
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!
<
http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Lonnie,
Is your intention to use API calls to the Crystal print engine, crpe32.dll?
I am also trying to do this and don't know enough Progress 4GL to know where
to start. I did find the following docs on CrystalDecision:
http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_powerbu
ilder.pdf.asp
<
http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_powerb
uilder.pdf.asp> -- PowerBuilder sample
http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibegin.pdf
.asp
<
http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibegin.pd
f.asp> -- Microsoft Visual Basic sample
If you can translate the methodology to Progress code, I bet you can make it
work.
Jim Stetter
IT Manager
Snow Filtration, a division of Reemay, Inc.
(513) 777-6200 ext 268
<mailto:
jstetter@...>
jstetter@...
<
http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_powerb
uilder.pdf.asp>
-----Original Message-----
From: Lonnie Drew [mailto:
lonniedrew@...]
Sent: Monday, November 17, 2003 2:16 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Printing Crystal Reports from Vantage
Jasper,
What I'm trying to do is create a compiled PROGRESS program that can
be attached to Vantage, that runs the Crystal report without
compiling the report.
This might even replace the Crystal compiler, which will disappear in
the future.
I don't know how far I'll get, but it looks promising. I just
created a R-Code file on-the-fly that previews a .RPT.
There may also be other applications - like a home-spun Crystal
Report scheduler, and Viewer, who knows.
Lonnie
--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> Lonnie,
>
> I was sent this information the other day on setting up crystal
reports in a Vantage menu. Hope it helps!
>
> --------------------------------------------------------------------
------
> How to add a compiled Crystal Report as a Vantage menu option.
>
> The following procedure will allow you to call a compiled Crystal
Report
> (.EXE) from a Vantage menu option. This will allow you to use
Vantage menu
> security to control user access to these reports.
>
> Step #1: Create a Progress program (.W) file to call the Crystal
Report
> .EXE.
>
> This program (.W) file would contain the following code:
> ============================================================
>
> DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
> DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
>
> PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
> DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
> DEFINE INPUT PARAMETER VisualStyle AS LONG.
> DEFINE RETURN PARAMETER StatusCode AS LONG.
> END PROCEDURE.
>
> /*******************************************************************
****
> Set the ProgNamePath variable value to the location\Crystal
Report's .EXE
>
**********************************************************************
*/
>
> ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
>
> RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
>
>
>
=====================================================================
> The example above shows how a "Scrap By Reason Detail.Exe" would be
called.
> Include the full path to the compile report .exe.
>
> Save this file as UD<Compile ReportName>.W and eliminate the spaces.
>
> For example: Scrap By Reason Detail.exe "save as"
UDScrapByReasonDetail.w
>
>
>
> Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD
folder.
>
> Step #3: Use Vantage Menu Structure Maintenance to add a new menu
option to
> call the UD<Compile ReportName>.W
>
> Note: Menu ID must start with UD. Any naming convention for the
remaining
> characters can be used.
>
> Program must always include UD/UD<Compile Report Name>.W
> --------------------------------------------------------------------
-------------
Please note: This message may contain information which is privileged and confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
[Non-text portions of this message have been removed]
If you are looking for some sample code that uses this API, check out:
http://24.123.247.30/~aellis/downloads/saberlogic_rpt_tool.zip
This program used to just be for scheduling reports, but can now be used
as a viewer also. It supports all of the native parameter prompting and
such. All of the Visual Basic source code is included. Then you can
take a look at:
LaunchFile.i
udcrystal.w
For how to stick those into the Vantage menu.
--
Adam Ellis - SaberLogic
On Tue, 2003-11-18 at 10:42, jstetter@... wrote:
> Lonnie,
>
> Is your intention to use API calls to the Crystal print engine, crpe32.dll?
> I am also trying to do this and don't know enough Progress 4GL to know where
> to start. I did find the following docs on CrystalDecision:
>
> http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_powerbu
> ilder.pdf.asp
> <http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_powerb
> uilder.pdf.asp> -- PowerBuilder sample
> http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibegin.pdf
> .asp
> <http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibegin.pd
> f.asp> -- Microsoft Visual Basic sample
>
> If you can translate the methodology to Progress code, I bet you can make it
> work.
>
> Jim Stetter
> IT Manager
> Snow Filtration, a division of Reemay, Inc.
> (513) 777-6200 ext 268
> <mailto:jstetter@...> jstetter@...
>
>
> <http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_powerb
> uilder.pdf.asp>
>
>
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@...]
> Sent: Monday, November 17, 2003 2:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Printing Crystal Reports from Vantage
>
>
> Jasper,
>
> What I'm trying to do is create a compiled PROGRESS program that can
> be attached to Vantage, that runs the Crystal report without
> compiling the report.
>
> This might even replace the Crystal compiler, which will disappear in
> the future.
>
> I don't know how far I'll get, but it looks promising. I just
> created a R-Code file on-the-fly that previews a .RPT.
>
> There may also be other applications - like a home-spun Crystal
> Report scheduler, and Viewer, who knows.
>
> Lonnie
>
>
>
> --- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> > Lonnie,
> >
> > I was sent this information the other day on setting up crystal
> reports in a Vantage menu. Hope it helps!
> >
> > --------------------------------------------------------------------
> ------
> > How to add a compiled Crystal Report as a Vantage menu option.
> >
> > The following procedure will allow you to call a compiled Crystal
> Report
> > (.EXE) from a Vantage menu option. This will allow you to use
> Vantage menu
> > security to control user access to these reports.
> >
> > Step #1: Create a Progress program (.W) file to call the Crystal
> Report
> > .EXE.
> >
> > This program (.W) file would contain the following code:
> > ============================================================
> >
> > DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
> > DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
> >
> > PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
> > DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
> > DEFINE INPUT PARAMETER VisualStyle AS LONG.
> > DEFINE RETURN PARAMETER StatusCode AS LONG.
> > END PROCEDURE.
> >
> > /*******************************************************************
> ****
> > Set the ProgNamePath variable value to the location\Crystal
> Report's .EXE
> >
> **********************************************************************
> */
> >
> > ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
> >
> > RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
> >
> >
> >
> =====================================================================
> > The example above shows how a "Scrap By Reason Detail.Exe" would be
> called.
> > Include the full path to the compile report .exe.
> >
> > Save this file as UD<Compile ReportName>.W and eliminate the spaces.
> >
> > For example: Scrap By Reason Detail.exe "save as"
> UDScrapByReasonDetail.w
> >
> >
> >
> > Step #2: Copy the UD<Compile ReportName>.W file to the \Vantage\UD
> folder.
> >
> > Step #3: Use Vantage Menu Structure Maintenance to add a new menu
> option to
> > call the UD<Compile ReportName>.W
> >
> > Note: Menu ID must start with UD. Any naming convention for the
> remaining
> > characters can be used.
> >
> > Program must always include UD/UD<Compile Report Name>.W
> > --------------------------------------------------------------------
> -------------
>
>
>
>
>
> Please note: This message may contain information which is privileged and confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
[Non-text portions of this message have been removed]
Jim and all,
It's VERY promising. So far, I've written a program that takes user
input, and then generates compiled procedure(s) to preview or print
the report. These procedures can be attached to the menu.
Since you can print without preview, scheduling is possible. I plan
to dig up the source code for my Report Builder scheduler and hope to
make it work for CR also.
I'm starting to feel much better about CR, since I've found the CR
engine can be called from Progress, and there is a method of running
from Vantage.
What got me started? Someone pointed me to this code a while back
(the indention may not hold) ...
DEF VAR hCR AS COM-HANDLE NO-UNDO.
DEF VAR hReport AS COM-HANDLE NO-UNDO.
DEF VAR hDB AS COM-HANDLE NO-UNDO.
CREATE "Crystal.CRPE.Application" hCR.
MESSAGE "Crystal.CRPE.Application executed" VIEW-AS ALERT-BOX.
hreport = hCR:OpenReport("c:\CUSTLIST111403.rpt").
hReport:preview().
hDb = hReport:DATABASE.
hDb:verify().
RELEASE OBJECT hDB.
RELEASE OBJECT hReport.
RELEASE OBJECT hCr.
And then I found this in the Progress Knowledge Center, and it was
very useful....
/*This is the 4GL procedure that might be used to validate the data
stored in the report: */
/* ************************************************** */
DEF VAR hCR AS COM-HANDLE NO-UNDO.
DEF VAR hReport AS COM-HANDLE NO-UNDO.
DEF VAR hDB AS COM-HANDLE NO-UNDO.
DEF VAR chTables AS COM-HANDLE NO-UNDO.
DEF VAR chTable AS COM-HANDLE NO-UNDO.
DEF VAR iCount AS INTEGER NO-UNDO.
DEF VAR i AS INTEGER NO-UNDO.
DEF VAR lret AS LOGICAL NO-UNDO.
CREATE "Crystal.CRPE.Application" hCR.
/* Here you can change the path to your report */
hreport = hCR:openReport("Customer.rpt").
hDb = hReport:DATABASE.
chTables = hDb:Tables .
iCount = chTables:Count .
DO i = 1 TO iCount :
chTable = chTables:ITEM(i).
MESSAGE
"Table name: " chTable:Name SKIP(1)
"DescriptiveName: " chTable:DescriptiveName SKIP
"DllName: " chTable:DllName SKIP
"LogOnDatabaseName: " chTable:LogOnDatabaseName SKIP
"LogOnServerName: " chTable:LogOnServerName SKIP
"LogOnUserID: " chTable:LogOnUserID SKIP
"SessionUserID: " chTable:SessionUserID SKIP
VIEW-AS ALERT-BOX INFO BUTTONS OK.
RELEASE OBJECT chTable NO-ERROR.
END.
chTable = chTables:ITEM(1).
NO-RETURN-VALUE chTable:setLogOnInfo(
"S2k", /* change to your ODBC DataSource Name */
"s2k", /* Same as above */
"skraljev", /* change to your UserID */
""). /* change to your Password */
MESSAGE
"Table name: " chTable:Name SKIP(1)
"DescriptiveName: " chTable:DescriptiveName SKIP
"DllName: " chTable:DllName SKIP
"LogOnDatabaseName: " chTable:LogOnDatabaseName SKIP
"LogOnServerName: " chTable:LogOnServerName SKIP
"LogOnUserID: " chTable:LogOnUserID SKIP
"SessionUserID: " chTable:SessionUserID SKIP
VIEW-AS ALERT-BOX INFO BUTTONS OK.
lRet = chTable:TestConnectivity().
MESSAGE "Test Connectivity:" lRet
VIEW-AS ALERT-BOX INFO BUTTONS OK.
/* */
/* View the report */
/* */
hReport:preview().
/* If any change */
/* Update the report automatically */
/* */
hDb = hReport:DATABASE.
hDb:verify().
/*PAUSE .*/
RELEASE OBJECT chTables NO-ERROR.
RELEASE OBJECT chTable NO-ERROR.
RELEASE OBJECT hDB NO-ERROR.
RELEASE OBJECT hReport NO-ERROR.
RELEASE OBJECT hCr NO-ERROR.
--- In vantage@yahoogroups.com, jstetter@b... wrote:
> Lonnie,
>
> Is your intention to use API calls to the Crystal print engine,
crpe32.dll? I am also trying to do this and don't know enough
Progress 4GL to know where to start. I did find the following docs
on CrystalDecision:
>
http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_p
owerbuilder.pdf.asp
>
<http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_
powerbuilder.pdf.asp> -- PowerBuilder sample
>
http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibeg
in.pdf.asp
>
<http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibe
gin.pdf.asp> -- Microsoft Visual Basic sample
>
> If you can translate the methodology to Progress code, I bet you
can make it work.
>
> Jim Stetter
> IT Manager
> Snow Filtration, a division of Reemay, Inc.
> (513) 777-6200 ext 268
> <mailto:jstetter@b...> jstetter@b...
>
>
>
<http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_
powerb
> uilder.pdf.asp>
>
>
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Monday, November 17, 2003 2:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Printing Crystal Reports from Vantage
>
>
> Jasper,
>
> What I'm trying to do is create a compiled PROGRESS program that
can
> be attached to Vantage, that runs the Crystal report without
> compiling the report.
>
> This might even replace the Crystal compiler, which will disappear
in
> the future.
>
> I don't know how far I'll get, but it looks promising. I just
> created a R-Code file on-the-fly that previews a .RPT.
>
> There may also be other applications - like a home-spun Crystal
> Report scheduler, and Viewer, who knows.
>
> Lonnie
>
>
>
> --- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> > Lonnie,
> >
> > I was sent this information the other day on setting up crystal
> reports in a Vantage menu. Hope it helps!
> >
> > ------------------------------------------------------------------
--
> ------
> > How to add a compiled Crystal Report as a Vantage menu option.
> >
> > The following procedure will allow you to call a compiled Crystal
> Report
> > (.EXE) from a Vantage menu option. This will allow you to use
> Vantage menu
> > security to control user access to these reports.
> >
> > Step #1: Create a Progress program (.W) file to call the Crystal
> Report
> > .EXE.
> >
> > This program (.W) file would contain the following code:
> > ============================================================
> >
> > DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
> > DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
> >
> > PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
> > DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
> > DEFINE INPUT PARAMETER VisualStyle AS LONG.
> > DEFINE RETURN PARAMETER StatusCode AS LONG.
> > END PROCEDURE.
> >
>
> /*******************************************************************
> ****
> > Set the ProgNamePath variable value to the location\Crystal
> Report's .EXE
> >
>
**********************************************************************
> */
> >
> > ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
> >
> > RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
> >
> >
> >
>
=====================================================================
> > The example above shows how a "Scrap By Reason Detail.Exe" would
be
> called.
> > Include the full path to the compile report .exe.
> >
> > Save this file as UD<Compile ReportName>.W and eliminate the
spaces.
> >
> > For example: Scrap By Reason Detail.exe "save as"
> UDScrapByReasonDetail.w
> >
> >
> >
> > Step #2: Copy the UD<Compile ReportName>.W file to the
\Vantage\UD
> folder.
> >
> > Step #3: Use Vantage Menu Structure Maintenance to add a new
menu
> option to
> > call the UD<Compile ReportName>.W
> >
> > Note: Menu ID must start with UD. Any naming convention for the
> remaining
> > characters can be used.
> >
> > Program must always include UD/UD<Compile Report Name>.W
> > ------------------------------------------------------------------
--
> -------------
>
>
>
>
>
> Please note: This message may contain information which is
privileged and confidential. If you are not the intended recipient,
you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
replying to the message and deleting it from your computer.
>
> [Non-text portions of this message have been removed]
Dear groupmates,
I've found some calculation problem about MRP time frame in Vantage. When I
issued a new Sales Order with 2 release schedules in two companies, after MRP
run, I found there were two different results of the planned order suggestion
for the past due release (means date before current date) in each company.
In one company, MRP suggested a new Job Order for the past due release. For
example, assume today is Nov 19,03 and MRP still suggested to issue a Job
order for the release that is schedule Nov 15,03 (if the manufacturing time
is 5 days);
However, in another company, MRP just provided a warehouse suggestion for the
past due release and it did not suggest any new Job order for that release.
I feel quite confused about two different results. Is there any system
configuration defined for the MRP time frame in Vantage? Anyone help me to
solve the problem?
Thanks a lot!!
Best wishes,
Gina Au
---
## Post #80 by @system
Lonnie,
I have been struggling with this for many days. Fueled by your post of
Tuesday, I decided to devote as much energy as possible to expand on what
you have found. Below, you will find the code of your original post with
some additional stuff that I have learned.
If you want to gain more control over the print preview window, invoke calls
to the "WindowPrintOptions" object as demonstrated here. You can also set
the size, position, and other behavior of the preview window in the
"preview" call.
Jim
/*This is the 4GL procedure that might be used to set option in the preview
report window */
/* ************************************************** */
DEF VAR TurnOn AS INTEGER INITIAL 1 NO-UNDO.
DEF VAR TurnOff AS INTEGER INITIAL 0 NO-UNDO.
DEF VAR wTop AS INTEGER INITIAL 0 NO-UNDO.
DEF VAR wLeft AS INTEGER INITIAL 0 NO-UNDO.
DEF VAR wWidth AS INTEGER INITIAL 600 NO-UNDO.
DEF VAR wHeight AS INTEGER INITIAL 600 NO-UNDO.
DEF VAR wTitle AS CHARACTER INITIAL "This is the Report Title" NO-UNDO.
DEF VAR wStyle AS INTEGER INITIAL 0 NO-UNDO. /* 0=Normal, 1=No Wincontrols
*/
DEF VAR wWindow AS INTEGER INITIAL 0 NO-UNDO. /* 0=new window, ?handle of
parentwindow */
DEF VAR hCR AS COM-HANDLE NO-UNDO.
DEF VAR hReport AS COM-HANDLE NO-UNDO.
DEF VAR hPrintOptions AS COM-HANDLE NO-UNDO.
CREATE "Crystal.CRPE.Application" hCR.
hreport = hCR:openReport("s:\vantage\userform\soformsf.rpt").
/*========================================================
this is what I have added
=========================================================*/
hPrintOptions=hReport:PrintWindowOptions.
/*** set WindowPrintOptions: 1 to turn on, 0 to turn off ***/
/*
OptionName Default Setting
-----------------------------
hasgrouptree off
canDrillDown on
hasNavigationControls on
hasCancelButton off
hasPrintButton on
hasExportButton on
hasZoomControl on
hasCloseButton off
hasProgressControl off
hasSearchButton off
hasPrintSetupButton off
hasReFreshButton off
ShowDocumentTips off
ShowToolbarTips off
Turn on some of the options that are off by default */
hPrintOptions:hasPrintSetupButton()=TurnOn.
hPrintOptions:hasReFreshButton()=TurnOn.
hPrintOptions:hasCloseButton()=TurnOn.
hPrintOptions:hasSearchButton()=TurnOn.
hPrintOptions:hasCancelButton()=TurnOn.
/*** open the report preview window ***/
hreport:preview(wTitle, wTop, wLeft, wWidth, wHeight, wStyle ,wWindow).
RELEASE OBJECT hPrintOptions NO-ERROR.
RELEASE OBJECT hReport NO-ERROR.
RELEASE OBJECT hCr NO-ERROR.
============================================================================
==========
-----Original Message-----
From: Lonnie Drew [mailto:
lonniedrew@...]
Sent: Tuesday, November 18, 2003 6:20 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Re: Printing Crystal Reports from Vantage
Jim and all,
It's VERY promising. So far, I've written a program that takes user
input, and then generates compiled procedure(s) to preview or print
the report. These procedures can be attached to the menu.
Since you can print without preview, scheduling is possible. I plan
to dig up the source code for my Report Builder scheduler and hope to
make it work for CR also.
I'm starting to feel much better about CR, since I've found the CR
engine can be called from Progress, and there is a method of running
from Vantage.
What got me started? Someone pointed me to this code a while back
(the indention may not hold) ...
DEF VAR hCR AS COM-HANDLE NO-UNDO.
DEF VAR hReport AS COM-HANDLE NO-UNDO.
DEF VAR hDB AS COM-HANDLE NO-UNDO.
CREATE "Crystal.CRPE.Application" hCR.
MESSAGE "Crystal.CRPE.Application executed" VIEW-AS ALERT-BOX.
hreport = hCR:OpenReport("c:\CUSTLIST111403.rpt").
hReport:preview().
hDb = hReport:DATABASE.
hDb:verify().
RELEASE OBJECT hDB.
RELEASE OBJECT hReport.
RELEASE OBJECT hCr.
And then I found this in the Progress Knowledge Center, and it was
very useful....
/*This is the 4GL procedure that might be used to validate the data
stored in the report: */
/* ************************************************** */
DEF VAR hCR AS COM-HANDLE NO-UNDO.
DEF VAR hReport AS COM-HANDLE NO-UNDO.
DEF VAR hDB AS COM-HANDLE NO-UNDO.
DEF VAR chTables AS COM-HANDLE NO-UNDO.
DEF VAR chTable AS COM-HANDLE NO-UNDO.
DEF VAR iCount AS INTEGER NO-UNDO.
DEF VAR i AS INTEGER NO-UNDO.
DEF VAR lret AS LOGICAL NO-UNDO.
CREATE "Crystal.CRPE.Application" hCR.
/* Here you can change the path to your report */
hreport = hCR:openReport("Customer.rpt").
hDb = hReport:DATABASE.
chTables = hDb:Tables .
iCount = chTables:Count .
DO i = 1 TO iCount :
chTable = chTables:ITEM(i).
MESSAGE
"Table name: " chTable:Name SKIP(1)
"DescriptiveName: " chTable:DescriptiveName SKIP
"DllName: " chTable:DllName SKIP
"LogOnDatabaseName: " chTable:LogOnDatabaseName SKIP
"LogOnServerName: " chTable:LogOnServerName SKIP
"LogOnUserID: " chTable:LogOnUserID SKIP
"SessionUserID: " chTable:SessionUserID SKIP
VIEW-AS ALERT-BOX INFO BUTTONS OK.
RELEASE OBJECT chTable NO-ERROR.
END.
chTable = chTables:ITEM(1).
NO-RETURN-VALUE chTable:setLogOnInfo(
"S2k", /* change to your ODBC DataSource Name */
"s2k", /* Same as above */
"skraljev", /* change to your UserID */
""). /* change to your Password */
MESSAGE
"Table name: " chTable:Name SKIP(1)
"DescriptiveName: " chTable:DescriptiveName SKIP
"DllName: " chTable:DllName SKIP
"LogOnDatabaseName: " chTable:LogOnDatabaseName SKIP
"LogOnServerName: " chTable:LogOnServerName SKIP
"LogOnUserID: " chTable:LogOnUserID SKIP
"SessionUserID: " chTable:SessionUserID SKIP
VIEW-AS ALERT-BOX INFO BUTTONS OK.
lRet = chTable:TestConnectivity().
MESSAGE "Test Connectivity:" lRet
VIEW-AS ALERT-BOX INFO BUTTONS OK.
/* */
/* View the report */
/* */
hReport:preview().
/* If any change */
/* Update the report automatically */
/* */
hDb = hReport:DATABASE.
hDb:verify().
/*PAUSE .*/
RELEASE OBJECT chTables NO-ERROR.
RELEASE OBJECT chTable NO-ERROR.
RELEASE OBJECT hDB NO-ERROR.
RELEASE OBJECT hReport NO-ERROR.
RELEASE OBJECT hCr NO-ERROR.
--- In vantage@yahoogroups.com, jstetter@b... wrote:
> Lonnie,
>
> Is your intention to use API calls to the Crystal print engine,
crpe32.dll? I am also trying to do this and don't know enough
Progress 4GL to know where to start. I did find the following docs
on CrystalDecision:
>
http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_p
owerbuilder.pdf.asp
>
<http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_
powerbuilder.pdf.asp> -- PowerBuilder sample
>
http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibeg
in.pdf.asp
>
<http://support.crystaldecisions.com/communityCS/TechnicalPapers/apibe
gin.pdf.asp> -- Microsoft Visual Basic sample
>
> If you can translate the methodology to Progress code, I bet you
can make it work.
>
> Jim Stetter
> IT Manager
> Snow Filtration, a division of Reemay, Inc.
> (513) 777-6200 ext 268
> <mailto:jstetter@b...> jstetter@b...
>
>
>
<http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr7_
powerb
> uilder.pdf.asp>
>
>
>
> -----Original Message-----
> From: Lonnie Drew [mailto:lonniedrew@c...]
> Sent: Monday, November 17, 2003 2:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Printing Crystal Reports from Vantage
>
>
> Jasper,
>
> What I'm trying to do is create a compiled PROGRESS program that
can
> be attached to Vantage, that runs the Crystal report without
> compiling the report.
>
> This might even replace the Crystal compiler, which will disappear
in
> the future.
>
> I don't know how far I'll get, but it looks promising. I just
> created a R-Code file on-the-fly that previews a .RPT.
>
> There may also be other applications - like a home-spun Crystal
> Report scheduler, and Viewer, who knows.
>
> Lonnie
>
>
>
> --- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@l...> wrote:
> > Lonnie,
> >
> > I was sent this information the other day on setting up crystal
> reports in a Vantage menu. Hope it helps!
> >
> > ------------------------------------------------------------------
Please note: This message may contain information which is privileged and confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
--
> ------
> > How to add a compiled Crystal Report as a Vantage menu option.
> >
> > The following procedure will allow you to call a compiled Crystal
> Report
> > (.EXE) from a Vantage menu option. This will allow you to use
> Vantage menu
> > security to control user access to these reports.
> >
> > Step #1: Create a Progress program (.W) file to call the Crystal
> Report
> > .EXE.
> >
> > This program (.W) file would contain the following code:
> > ============================================================
> >
> > DEFINE VARIABLE ProgNamePath as CHARACTER NO-UNDO.
> > DEFINE VARIABLE ReturnCode AS INTEGER NO-UNDO.
> >
> > PROCEDURE WinExec EXTERNAL "KERNEL32.DLL":
> > DEFINE INPUT PARAMETER ProgramName AS CHARACTER.
> > DEFINE INPUT PARAMETER VisualStyle AS LONG.
> > DEFINE RETURN PARAMETER StatusCode AS LONG.
> > END PROCEDURE.
> >
>
> /*******************************************************************
> ****
> > Set the ProgNamePath variable value to the location\Crystal
> Report's .EXE
> >
>
**********************************************************************
> */
> >
> > ProgNamePath = "W:\Vantage\UD\Scrap By Reason Detail.exe".
> >
> > RUN WinExec (INPUT ProgNamePath, INPUT 1, OUTPUT ReturnCode).
> >
> >
> >
>
=====================================================================
> > The example above shows how a "Scrap By Reason Detail.Exe" would
be
> called.
> > Include the full path to the compile report .exe.
> >
> > Save this file as UD<Compile ReportName>.W and eliminate the
spaces.
> >
> > For example: Scrap By Reason Detail.exe "save as"
> UDScrapByReasonDetail.w
> >
> >
> >
> > Step #2: Copy the UD<Compile ReportName>.W file to the
\Vantage\UD
> folder.
> >
> > Step #3: Use Vantage Menu Structure Maintenance to add a new
menu
> option to
> > call the UD<Compile ReportName>.W
> >
> > Note: Menu ID must start with UD. Any naming convention for the
> remaining
> > characters can be used.
> >
> > Program must always include UD/UD<Compile Report Name>.W
> > ------------------------------------------------------------------
--
> -------------
>
>
>
Anybody willing to help 'unstump the chump' ?
I modified the crystal ARFORM and named it arform3 and linked it
Vantage. Basically I suppressed some detail lines so they wouldn't print
so that each line does not print on a separate page. I also added some
text fields to the top of the form.
Now, when I add a misc charge to one invoice in a group, every invoice
prior and including that invoice prints with the charge on it, the $ do
not add into the invoice total, nor does the amount print on the group
edit list. But the invoices after it don't have the misc charge.
(The misc charges are on detail line j & k on the original form and on
my change)
Any suggestions as to where to look?
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
[Non-text portions of this message have been removed]
Good morning all
To the fellow bean counters out there, how do you handle your shippers
at the end of the month? The ones that didn't ship that is.
We are on 5.10.135 and we do not flag the shipper as ready until after
it ships, then we go back and add the tracking info, ship date, and flag
shipped and answer yes to the "is this ready" question.
We have lots of shippers open from previous months and I am wondering if
we need to go pull them and delete them for costing and inventory/wip
valuation purposes. The shippers do not show up on the sales order, but
they do show as shipped on the job. (We usually ship from the job), they
do not seem to affect inventory the same way as they do the job.
I did search the archives but didn't find this particular question, so
thank you for your help!
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
[Non-text portions of this message have been removed]
This begs the question, why are shippers (packing slips) created before
actually shipping?
We, too, ship from our jobs and do have that situation arise-occasionally.
Since we are still on 5.0, and costs move to COS at the time of shipping, it
requires a journal entry to move the costs back to WIP. Deleting the
packing slip for us would not be an option since the customer involved is
using the packing slip number as a reference, not our invoice number. In
fact, we have a few customers who don't use our invoice number as a
reference. Ah yes, cash application CAN get tricky!
Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0
-----Original Message-----
From: patty.cioffi [mailto:
patty.cioffi@...]
Sent: Thursday, December 04, 2003 2:08 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Packing Slips and Month End
Good morning all
To the fellow bean counters out there, how do you handle your shippers
at the end of the month? The ones that didn't ship that is.
We are on 5.10.135 and we do not flag the shipper as ready until after
it ships, then we go back and add the tracking info, ship date, and flag
shipped and answer yes to the "is this ready" question.
We have lots of shippers open from previous months and I am wondering if
we need to go pull them and delete them for costing and inventory/wip
valuation purposes. The shippers do not show up on the sales order, but
they do show as shipped on the job. (We usually ship from the job), they
do not seem to affect inventory the same way as they do the job.
I did search the archives but didn't find this particular question, so
thank you for your help!
Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:
patty.cioffi@...>
patty.cioffi@...
[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
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
We are still on v5.0. After reading that the future version of
Vantage (Progress) does not support Report Builder, I need to start
using Crystal for new reports being created, and eventually replace
200+ Report Builder reports. I've taken a Crystal class, then didn't
get time to practice what I learned.
Has anyone copied some Crystal Reports somewhere that others can
download? I am especially interested in Sub-reports.
Thank you for all of your help!
Ann
AMFAB
amfab@...Has anyone posted any Crystal Reports anywhere for others to copy/download?? If not, would anyone care to send some my way. I plan to eventually re-write 200+ Report Builder reports in Crystal and would like to see some different creativity. I am also interested in sub-reports.
Thank you!!
Ann Rohyans
AMFAB
[Non-text portions of this message have been removed]
---
## Post #86 by @system
Does anyone know if there's a tool to automatically run a crystal
report similar those used to run report builer reports?
Mark Smith
Director of Information Sytems
Innerpac, Inc
---
## Post #87 by @system
I'm trying to get acquainted with crystal reports so I can start moving some reports over to it. I need to make a simple 'if > then' statement. I have a field that is either true or false. Instead of it printing 'True or False', I would like it to print 'Complete' when True and 'Incomplete' when false. That was easy in Report Builder but how would you do that in Crystal Reports? I can't seem to write an 'If > then' statement because it wants number for the conditions and not words.
Thanks,
Jasper
[Non-text portions of this message have been removed]
---
## Post #88 by @system
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving some
reports over to it. I need to make a simple 'if > then' statement. I have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete' when
false. That was easy in Report Builder but how would you do that in Crystal
Reports? I can't seem to write an 'If > then' statement because it wants
number for the conditions and not words.
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
I doing this in the Format Editor under the Boolean tab. When I create that formula, it tells me "The formula result must be a number". Am I doing this in the wrong place?
THanks,
Jasper
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:22 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving some
reports over to it. I need to make a simple 'if > then' statement. I have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete' when
false. That was easy in Report Builder but how would you do that in Crystal
Reports? I can't seem to write an 'If > then' statement because it wants
number for the conditions and not words.
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
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
And even easier...
IIF([field], "Complete", "Incomplete").
Because it's a true false field, you don't need to compare it to
anything. It returns a true/false case on it's own.
Aaron
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:22 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving
some
reports over to it. I need to make a simple 'if > then' statement. I
have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete'
when
false. That was easy in Report Builder but how would you do that in
Crystal
Reports? I can't seem to write an 'If > then' statement because it
wants
number for the conditions and not words.
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/.
<
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
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/.
<
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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<
http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
It is in the formula editor, but I've never used the Boolean tab. The way I
do this is just create a new formula field and when the formula editor opens
I just type in my formula. I have a very similar "if then" statement on a
checkbox field and it works fine.
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:19 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I doing this in the Format Editor under the Boolean tab. When I create that
formula, it tells me "The formula result must be a number". Am I doing this
in the wrong place?
THanks,
Jasper
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:22 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving some
reports over to it. I need to make a simple 'if > then' statement. I have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete' when
false. That was easy in Report Builder but how would you do that in Crystal
Reports? I can't seem to write an 'If > then' statement because it wants
number for the conditions and not words.
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
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
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
THANKS!!
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:30 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It is in the formula editor, but I've never used the Boolean tab. The way I
do this is just create a new formula field and when the formula editor opens
I just type in my formula. I have a very similar "if then" statement on a
checkbox field and it works fine.
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:19 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I doing this in the Format Editor under the Boolean tab. When I create that
formula, it tells me "The formula result must be a number". Am I doing this
in the wrong place?
THanks,
Jasper
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:22 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving some
reports over to it. I need to make a simple 'if > then' statement. I have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete' when
false. That was easy in Report Builder but how would you do that in Crystal
Reports? I can't seem to write an 'If > then' statement because it wants
number for the conditions and not words.
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
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
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
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
Yup.
Make life easy. Bring up the field explorer (Insert field). Expand the
formula section. Click "new" on it's tool bar. Give it a name. Insert
the formula. Save and close. Drag it into the report.
Aaron
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:19 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I doing this in the Format Editor under the Boolean tab. When I create
that formula, it tells me "The formula result must be a number". Am I
doing this in the wrong place?
THanks,
Jasper
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:22 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving
some
reports over to it. I need to make a simple 'if > then' statement. I
have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete'
when
false. That was easy in Report Builder but how would you do that in
Crystal
Reports? I can't seem to write an 'If > then' statement because it
wants
number for the conditions and not words.
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/.
<
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
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/.
<
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
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/.
<
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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<
http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Jasper
Try: if {table.boolean} then "Complete" else "Incomplete"
an If statement has to evaluate to True or False, so if you're using
boolean field you don't need to compare it to anything because it's true
or false by it's value.
Becky
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving
some reports over to it. I need to make a simple 'if > then' statement.
I have a field that is either true or false. Instead of it printing
'True or False', I would like it to print 'Complete' when True and
'Incomplete' when false. That was easy in Report Builder but how would
you do that in Crystal Reports? I can't seem to write an 'If > then'
statement because it wants number for the conditions and not words.
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
Sarah,
From the speed of your answers...you must not be operating on the same
(Janet Jackson) 30 second delay that I am. :-)
Aaron
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:30 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It is in the formula editor, but I've never used the Boolean tab. The
way I
do this is just create a new formula field and when the formula editor
opens
I just type in my formula. I have a very similar "if then" statement on
a
checkbox field and it works fine.
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:19 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
I doing this in the Format Editor under the Boolean tab. When I create
that
formula, it tells me "The formula result must be a number". Am I doing
this
in the wrong place?
THanks,
Jasper
-----Original Message-----
From:
sarah.vareschi@... [mailto:
sarah.vareschi@...]
Sent: Wednesday, March 31, 2004 10:22 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
It's easy in crystal, too.
If [field] = yes then "Complete" else "Incomplete"
-----Original Message-----
From: Jasper Recto [mailto:
jrecto@...]
Sent: Wednesday, March 31, 2004 10:10 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Crystal Reports
I'm trying to get acquainted with crystal reports so I can start moving
some
reports over to it. I need to make a simple 'if > then' statement. I
have
a field that is either true or false. Instead of it printing 'True or
False', I would like it to print 'Complete' when True and 'Incomplete'
when
false. That was easy in Report Builder but how would you do that in
Crystal
Reports? I can't seem to write an 'If > then' statement because it
wants
number for the conditions and not words.
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/.
<
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
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/.
<
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
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/.
<
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
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/.
<
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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<
http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Does anyone from the group know if it is possible to add a page or a
field to a crystal form, for example the job card, and supress the
page or field if there's no data behind page and or field? Your
input is appreciated.
Thanks,
Mark Smith
Innerpac, Inc.
---
## Post #97 by @system
Yes, Crystal has great suppression options for suppressing fields and
sections of the reports. They can be suppressed if blank or if any
boolean condition is met, very flexible. For dealing with sections,
go into the format section menu. You can suppress a section or
suppress a blank section by checking a box on that screen, or you can
click on the formula button next to those choices and set up a
condition. For dealing with field suppression, choose format field,
on the common tab there is a box for suppres, and suppress if
duplicated. You can also set up formulas for conditionally
suppressing.
Brian Stenglein
Clow Stamping Co.
--- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@i...> wrote:
> Does anyone from the group know if it is possible to add a page or
a
> field to a crystal form, for example the job card, and supress the
> page or field if there's no data behind page and or field? Your
> input is appreciated.
>
> Thanks,
>
> Mark Smith
> Innerpac, Inc.
What version on Crystal Reports does Vantage 6.x support at this time? I
went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
---
## Post #99 by @system
---
## Post #100 by @system
Can you purchase newer versions and save them in 8.5 Crystal format??? I've
checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time? I
went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.netfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
## Post #101 by @system
Darren,
Think about purchase from Epicor. They still have it, and "upgrade
rights" for a price.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Monday, June 07, 2004 11:51 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Reports - Email found in subject
Can you purchase newer versions and save them in 8.5 Crystal format???
I've checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time?
I went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=gr
oups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.n
etfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
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
********************************************************************************************************************
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.
********************************************************************************************************************
---
## Post #102 by @system
You need to buy the current version and downgrade for a fee to a lower
version. This works because I use 8.0 in 5.1 and when I upgrade to 6.1, I
started to use the 8.5 that I already had. Good luck!
Mario Aguirre
Lakin General
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Monday, June 07, 2004 10:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Can you purchase newer versions and save them in 8.5 Crystal format??? I've
checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time? I
went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.netfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
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
---
## Post #103 by @system
Vantage is certified with 8.5 but works quite well with 9.0 and 10.0.
Crystal 9 has an issue with regard to retaining login parameters for ODBC
reports but it is simple to overcome with a VB6 or .NET compile prior to
distribution. Crystal 10 works wonderfully with Vantage 5/6X including
storing connection string information in the Crystal Repository for reuse
across reports.
With the purchase of any version, Business Objects allows you to contact
support and obtain earlier versions for the cost of the media. All you have
to do is provide your license and registration information and they will
ship you the prior version(s).
Michael
Michael Barry
Aspacia Systems Inc
Authorized Crystal Reports Reseller
866.566.9600
312.803.0730 fax
http://www.aspacia.com/
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Monday, June 07, 2004 9:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Darren,
Think about purchase from Epicor. They still have it, and "upgrade rights"
for a price.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Monday, June 07, 2004 11:51 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Reports - Email found in subject
Can you purchase newer versions and save them in 8.5 Crystal format???
I've checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time?
I went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=gr
oups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.n
etfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
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
****************************************************************************
****************************************
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.
****************************************************************************
****************************************
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
---
## Post #104 by @system
I have copy of 8.2 standard, new in box. If you would like to purchase it.
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Monday, June 07, 2004 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Can you purchase newer versions and save them in 8.5 Crystal format??? I've
checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time? I
went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.netfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
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
---
## Post #105 by @system
Is there anyone else out there who is using 5.2 and and Crystal 10?
Paul
-----Original Message-----
From: Michael Barry [mailto:mbarry@...]
Sent: Monday, June 07, 2004 1:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Vantage is certified with 8.5 but works quite well with 9.0 and 10.0.
Crystal 9 has an issue with regard to retaining login parameters for ODBC
reports but it is simple to overcome with a VB6 or .NET compile prior to
distribution. Crystal 10 works wonderfully with Vantage 5/6X including
storing connection string information in the Crystal Repository for reuse
across reports.
With the purchase of any version, Business Objects allows you to contact
support and obtain earlier versions for the cost of the media. All you have
to do is provide your license and registration information and they will
ship you the prior version(s).
Michael
Michael Barry
Aspacia Systems Inc
Authorized Crystal Reports Reseller
866.566.9600
312.803.0730 fax
http://www.aspacia.com/
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Monday, June 07, 2004 9:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Darren,
Think about purchase from Epicor. They still have it, and "upgrade rights"
for a price.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Monday, June 07, 2004 11:51 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Reports - Email found in subject
Can you purchase newer versions and save them in 8.5 Crystal format???
I've checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time?
I went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=gr
oups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.n
etfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
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
****************************************************************************
****************************************
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.
****************************************************************************
****************************************
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
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
---
## Post #106 by @system
no, we use 6.1 and 8.5 and 9
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Paul Siebers [mailto:paul.siebers@...]
Sent: Tuesday, June 08, 2004 9:05 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
Is there anyone else out there who is using 5.2 and and Crystal 10?
Paul
-----Original Message-----
From: Michael Barry [mailto:mbarry@...]
Sent: Monday, June 07, 2004 1:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Vantage is certified with 8.5 but works quite well with 9.0 and 10.0.
Crystal 9 has an issue with regard to retaining login parameters for ODBC
reports but it is simple to overcome with a VB6 or .NET compile prior to
distribution. Crystal 10 works wonderfully with Vantage 5/6X including
storing connection string information in the Crystal Repository for reuse
across reports.
With the purchase of any version, Business Objects allows you to contact
support and obtain earlier versions for the cost of the media. All you have
to do is provide your license and registration information and they will
ship you the prior version(s).
Michael
Michael Barry
Aspacia Systems Inc
Authorized Crystal Reports Reseller
866.566.9600
312.803.0730 fax
http://www.aspacia.com/
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Monday, June 07, 2004 9:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports
Darren,
Think about purchase from Epicor. They still have it, and "upgrade rights"
for a price.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Monday, June 07, 2004 11:51 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Reports - Email found in subject
Can you purchase newer versions and save them in 8.5 Crystal format???
I've checked on availability of 8.5 and it's tough to find...
-----Original Message-----
From: Shearer, Judd [mailto:judds@...]
Sent: Monday, June 07, 2004 10:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports
8.5 at this time (we are on 6.1)
Judd
Custom Hoists, Inc.
-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Monday, June 07, 2004 11:27 AM
To: Vantage (E-mail)
Subject: [Vantage] Crystal Reports
What version on Crystal Reports does Vantage 6.x support at this time?
I went to Epicor's website, but could not get my answer quickly.
Thanks,
Jim Dodd
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129nmcu2s/M=298184.5022502.6152625.3001176/D=gr
oups
/S=1705007183:HM/EXP=1086708378/A=2164331/R=0/SIG=11eaelai9/*http:/www.n
etfl
ix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164331/rand=524745387>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[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
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004
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
****************************************************************************
****************************************
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.
****************************************************************************
****************************************
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
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
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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129lgop76/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086786608/A=2164338/R=0/SIG=11ed4vqbv/*http://www.netf
lix.com/Default?mqso=60183349> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164338/rand=994159508>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
<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).
[Non-text portions of this message have been removed]
---
## Post #107 by @system
I am trying to link Vantage 5.2 files using Crystal Reports and can't
get the links to work. I am able to write reports on individual files,
but when I try to link subreports or files it doesn't work.
For example: I should be able to link the JobHead; JobOper & JobMtl
files for a report that should list all Open Jobs with the Open
Operations and Material not received. But when I try to link the
JobHead & JobOper I only have one Job show on the report.
I had this working on Pervasive (btrieve) and SQL databases, but I can't
get it to work on Progress.
Any ideas?
John (sitting at Kathy's desk)
---
## Post #108 by @system
Jsut off the bat do you have your Progress explorer configured to
allow ODBC Connections
AND
Do you have a ODBC Connection on the system into the Vantage Server?
---
## Post #109 by @system
Happy Easter all;
Am working with a company in central Wisconsin area that is looking
for someone versed in Crystal Reports that is able to train an
individual in CR or make the reports themselves as needed. We've
recently implemented Vantage and now that things are moving along
everyone wants to see certain things and of course they want it
yesterday. Presently running Vantage 6.1. You can contact me off list.
Thanks and Happy Easter
---
## Post #110 by @system
Please Help, I am new with crystal8.5 and V6.1. I am trying to add a
price to the canned packing slip report. I have created a subreport
with the orderdtl ODBC link but how do I share the lineqtyship field
from the main report to the sub report. I also am getting a 534 error
when I try to use another computer to print the packing slip. We are
using termserve to connect to our server with Vantge. Tech support
keeps telling me I need a separate temp file for all our users but
that seems excessive with over 500users I would need a huge storage
device just for all the DBF files created. Please any thoughts and
advice would be greatly appreciated.
Sam
Sam.Chapman@...Does crystal allow you to perform conditional printing in the same
fashion as Report Builder?
Thanks,
Mark Smith
Innerpac, Inc.
---
## Post #112 by @system
Yes, down to the field level. Go into the "FORMAT" sections of the related
component and work with the SUPPRESS area. To completely suppress the field
or line click the suppress check box. To conditionally suppress click the
formula field on the right and enter your conditional requirements.
Shirley Graver
Rubber Associates Inc
Tracking #: 9223222B6FABE24E841ECC2DCB4FC2E5A880F01A
[Non-text portions of this message have been removed]
---
## Post #113 by @system
We added our purchasing terms and conditions onto the Vantage crystal PO report, the problem is in that when you preview it the terms and conditions go to 4 pages, but we would like to have it on 2 pages. When you print it out there is plenty of room on the bottom of the 1st and 3rd page for the remaining text to fit on but I am not sure how to adjust the margins or whatever to get it all to print on the 2 pages.
Any assistance would be greatly appreciated.
Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
Email:
paul.pachniak@...
Phone: 1-262-252-4003 (ext 1114)
NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.
I have a pick list report and depending on what is returned in the
detail i would like to suppress the Group Heading. For example i only
want to show items that come from warehouse 1, if not suppress the
record. The problem occurs when there is more than one warehouse for a
particular item, if the item comes from warehouse 1 OR 2 i want it to
only suppress the warehouse 2 'Detail' section. If the item comes ONLY
from warehouse 2 i want to suppress the headings and the details
sections. any help would be appreciated
Brendan
---
## Post #115 by @system
We are on 6.1.533 and using Crystal 8.5.
I need to add a field (Part.TrackLots) to an existing Crystal Report (Job Traveler) that is not included in the .dbf's that Vantage provides. I believe I need to add a Subreport and get the Part Table, but I am having trouble with how I only get the info for the part that is on the specific job traveler that I am trying to print. I still have been relying on Report Builder so my Crystal skills are probably not as good as they should be.
Does anyone have a procedure using Crystal 8.5 to add tables/fields that don't exist in the .dbf's?
I would appreciate any assistance offered in this regard.
Paul E. Pachniak
Accounting Manager
Ace Precision Machining Corporation
W146 N5714 Enterprise Avenue
Menomonee Falls, WI 53051
Phone: 262-252-4003 Ext. 1114
Fax: 262-252-4974
Email:
paul.pachniak@...
Web:
http://www.aceprecision.com/
NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.
You get the info for the correct part when you link the subreport to
the main report by PN. I think it is the last step of creating a
subreport.
HTH,
Brian Stenglein
Clow Stamping Co.
--- In
vantage@yahoogroups.com, "Paul Pachniak" <paul.pachniak@...>
wrote:
>
> We are on 6.1.533 and using Crystal 8.5.
>
> I need to add a field (Part.TrackLots) to an existing Crystal
Report (Job Traveler) that is not included in the .dbf's that Vantage
provides. I believe I need to add a Subreport and get the Part
Table, but I am having trouble with how I only get the info for the
part that is on the specific job traveler that I am trying to print.
I still have been relying on Report Builder so my Crystal skills are
probably not as good as they should be.
>
> Does anyone have a procedure using Crystal 8.5 to add
tables/fields that don't exist in the .dbf's?
>
> I would appreciate any assistance offered in this regard.
>
> Paul E. Pachniak
> Accounting Manager
> Ace Precision Machining Corporation
> W146 N5714 Enterprise Avenue
> Menomonee Falls, WI 53051
> Phone: 262-252-4003 Ext. 1114
> Fax: 262-252-4974
> Email: paul.pachniak@...
> Web: http://www.aceprecision.com/
>
>
>
>
>
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
unintended recipient, immediately (1) delete all copies of this
message and any attachments, and (2) contact the sender. If you are
an intended recipient, you are prohibited from deleting or
obstructing this or any other Ace Precision Machining Corp.
proprietary or confidentiality designation that appears on this
message or any attachments. All recipients are prohibited from
reproducing, publishing or disclosing the contents of this message
and any attachments to others, unless you first request and receive
written permission from Ace Precision Machining Corp.
>
You can also get to this menu once the report has been added by right
clicking on the subreport, edit subreport links. As Brian correctly said you
can pass through the part number to the sub report. For some examples try
the Crystal website HYPERLINK
"http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_subreport
s_samples.zip.asp"http://support.businessobjects.com/communityCS/FilesAndUpd
ates/cr_subreports_samples.zip.asp
Regards,
Stephen Edginton
_____
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Friday, August 11, 2006 7:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports
You get the info for the correct part when you link the subreport to
the main report by PN. I think it is the last step of creating a
subreport.
HTH,
Brian Stenglein
Clow Stamping Co.
--- In HYPERLINK "mailto:vantage%40yahoogroups.com"vantage@...,
"Paul Pachniak" <paul.pachniak@-...>
wrote:
>
> We are on 6.1.533 and using Crystal 8.5.
>
> I need to add a field (Part.TrackLots) to an existing Crystal
Report (Job Traveler) that is not included in the .dbf's that Vantage
provides. I believe I need to add a Subreport and get the Part
Table, but I am having trouble with how I only get the info for the
part that is on the specific job traveler that I am trying to print.
I still have been relying on Report Builder so my Crystal skills are
probably not as good as they should be.
>
> Does anyone have a procedure using Crystal 8.5 to add
tables/fields that don't exist in the .dbf's?
>
> I would appreciate any assistance offered in this regard.
>
> Paul E. Pachniak
> Accounting Manager
> Ace Precision Machining Corporation
> W146 N5714 Enterprise Avenue
> Menomonee Falls, WI 53051
> Phone: 262-252-4003 Ext. 1114
> Fax: 262-252-4974
> Email: paul.pachniak@-...
> Web: HYPERLINK "http://www.aceprecision.com/"http://www.acepreci-sion.com/
>
>
>
>
>
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
unintended recipient, immediately (1) delete all copies of this
message and any attachments, and (2) contact the sender. If you are
an intended recipient, you are prohibited from deleting or
obstructing this or any other Ace Precision Machining Corp.
proprietary or confidentiality designation that appears on this
message or any attachments. All recipients are prohibited from
reproducing, publishing or disclosing the contents of this message
and any attachments to others, unless you first request and receive
written permission from Ace Precision Machining Corp.
>
--
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.9/416 - Release Date: 10/08/2006
--
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.9/416 - Release Date: 10/08/2006
[Non-text portions of this message have been removed]
I just went through a procedure today where I had to add fields to
the report data definition so that I could see them in crystal 10
and then add the previously excluded field to the report.
The properties of the canned report in Vantage (OpenPO in this case)
are defined in the Report Data Definition under System Mgmt. Do a
search and find the report you want to alter.
If it is a system report, you are not allowed to alter it so you
have to Actions>Duplicate it and rename it, exit out and then go
back into the recently duplicated report. You can alter this one.
Go to Report Table>Excluded Fields and view the included vs.
excluded fields, find the field you need in the list of excluded
fields and move it over to the included fields. Save.
Next, go to the Report Style Maintenance, define a new style, then
go to Styles>Detail and change the Data Definition to the new
duplicate.
Find the report in Vantage, select the new style and run the
report. You have to do this so that a file is created that you can
then point set the crystal datesource to.
Now go to crystal and Database> Set Datasource Location...
Create New Connection>ADO.NET, then find the report file by browsing
to the server>MFGSYSDATA>Reports>{Your USERID} and select the most
recently created file. Finish, then Close.
Back to Crystal - Database>Verify Database, go through the
resetting process by clicking ok a few times.
Now, you can go to the tables, see the newly included field and add
the field to the report.
I really hope this is what you were talking about.
---
## Post #119 by @system
I'm trying to create a crystal report and I'm really not great at
doing these formula, Can anybody help?
I need to create a report for List of Material, so have connected a
ODBC connection and pulled out fields required.
But i seem to get all the records when i only need the Assembly top
(JobHead.JobNum )line part plus the list of martial's(JobMtl.PartNum)
below.
Any help would be much appreciated.
---
## Post #120 by @system
You have to create joins and write sort formula.
kirsty2179 <
dobby01@...> wrote: I'm trying to create a crystal report and I'm really not great at
doing these formula, Can anybody help?
I need to create a report for List of Material, so have connected a
ODBC connection and pulled out fields required.
But i seem to get all the records when i only need the Assembly top
(JobHead.JobNum )line part plus the list of martial's(JobMtl.PartNum)
below.
Any help would be much appreciated.
---------------------------------
Check out the hottest 2008 models today at Yahoo! Autos.
[Non-text portions of this message have been removed]