Crystal Reports

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
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]
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
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.
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]