RE: Crystal Help

Yahoo Archive
1
If you are set up to build your own reports on Crystal Reports, then this is not a problem. Utilizing the Merant ODBC driver, what you need to do is re-create the report. Open it up in Crystal, AND SAVE IT UNDER ANOTHER NAME in order to work on a backed up copy, then add the data tables you are wanting to use- including those that are already in the report. These tables will all link without a problem.

The greatest challenge in doing it this way is to make certain you replace each field from the previous tables with the same field in the tables you added. You'll need to do this with formulas, so check not only the formulas section of the report, but also the select expert, grouping, sorting, and page formatting to make certain all fields are replaced. When you believe you have replaced all fields, go to "Database" and "Remove Database from report." If it allows you to remove the original databases, then you have replaced all the fields. If not, keep looking because you have fields remaining. Once that is complete, the report should have no problem running. You can later replace the existing file on Vantage with your updated report and run it from that.

Tony Leninger
TLeninger@...
2
Thanks guys for the words of wisdom. I actually need this to automate the
printing of a Certificate of Compliance required by about 20 of our
Customers. I was able to create the Certificate nicely using a combination
of a Subreport and Supressed Sections and fields from the Packing Slip
report. My goal was to have this triggered by a VB check box in the Customer
Master, which would save me from having to change report formulas every time
a new Customer needed Certificates. The Customer number is available from
the Shipping tables, but we have a Custom program that relies on our
Customer Numbers. Therefore, I can't mess with them. I didn't think that
this was going to be such a hassle. I have noted that the stock Crystal
report, Job Traveler, somehow managed to get the Customer Name field in the
JobHead Table. How did they manage that? I will attempt to add this field
using subreports. Again, I do appreciate your help.

Thanks,
Les

What Rick said is very true! I have spent a great deal of time
working on modifying the Vantage Crystal Reports to include
additional data not supplied in the DBF files created by the Vantage
application. The problem here is that the DBF's use a different
database driver than ODBC does and Crystal will only allow the use of
one driver at a time. The ONLY STABLE WAY that I found to include
additional data was to use a subreport in the modified Vantage
Crystal report to display the additional data from the Progress
tables. Using this method you can print the report without any
additional steps so it is invisible to the end user. You can make
this subreport as small as you want in the main report so it displays
just one field and it just looks like any other field in the report.
The subreport will allow you to use a different driver (ODBC driver)
than the one used in the main report (XBASE Driver). Two things that
you should know:
1. It will take slightly longer to print a report that contains a
subreport.
2. ODBC must be installed on every workstation that will print the
report.
Our shop travelers actually have 3 subreports within the main report
that allow us to include the primary bin for the part, the bin
locations and bin quantities of the raw material components and any
salvage parts and their bin locations. I have several reports that I
have modified this way and it works great. I hope this wasn't too
confusing. We are using Vantage 3.00.632 and Crystal 7. Any
questions feel free to contact me directly.

-----Original Message-----
Date: Wed, 16 Aug 2000 10:25:59 -0400
From: Rick Lane <rickl@...>
Subject: RE: Crystal Help

I assume that you are trying to link these tables to the customer
master
table via ODBC? If you are you may want to give up now. Linking the
standard Vantage reports to the actual Progress tables via ODBC is
extremely
flaky at best, and I have never been able to link it to more than one
table.

Two other solutions to consider:

1) Re-write the packing slip in complete ODBC (creates some of it's
own
problems).

2) Better yet, create a VBForm field in the packing slip header that
contains fields you need printed on the packing slip. Create a
button on
the VBForm that calls a simply Progress procedure to copy the VBForm
fields
from the customer master table into the VBForm in the packing slip
header.
These fields are then readily available for printing on the standard
packing
slip.


-----Original Message-----
Date: Wed, 16 Aug 2000 12:47:02 -0000
From: "Les Tingley" <ltingley@...>
Subject: Crystal Help

I need to add a Vantage basic field from my Customer Table to my
Crystal Reports Packing Slip. The Ship head Table contains the CUSTID
as well as the CUSTNUM. Linking these fields does not work, however.
I'm assuming because of the join type. When I go into Visual Linking,
the Join types are grayed out. Can anybody tell why this is and or
how to correct this?

Thanks,
Les





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.)
3
Along this line but on a slight tangent ... has anyone used Crystal's Dictionary module? It appears (as I read the documentation) that with it you can combine tables, links, etc into what Crystal Calls a Dictionary definition. Then this .dc5 file is saved and used to:

Dictionaries allow you to:

· design a single, dynamic view of all the data that is necessary to create organizational reports and queries,

· organize the data and rename tables and fields to make it easier for users to understand the content and purpose of the data, and

· create complex data-manipulation formulas that users can access without the need to understand formula concepts.

Has anyone used this? If so in what setting?

Troy Funte
Liberty Electronics
----- Original Message -----
From: Les Tingley
To: 'vantage@egroups.com'
Sent: Thursday, August 17, 2000 10:42 AM
Subject: RE: [Vantage] RE: Crystal Help


Thanks guys for the words of wisdom. I actually need this to automate the
printing of a Certificate of Compliance required by about 20 of our
Customers. I was able to create the Certificate nicely using a combination
of a Subreport and Supressed Sections and fields from the Packing Slip
report. My goal was to have this triggered by a VB check box in the Customer
Master, which would save me from having to change report formulas every time
a new Customer needed Certificates. The Customer number is available from
the Shipping tables, but we have a Custom program that relies on our
Customer Numbers. Therefore, I can't mess with them. I didn't think that
this was going to be such a hassle. I have noted that the stock Crystal
report, Job Traveler, somehow managed to get the Customer Name field in the
JobHead Table. How did they manage that? I will attempt to add this field
using subreports. Again, I do appreciate your help.

Thanks,
Les

What Rick said is very true! I have spent a great deal of time
working on modifying the Vantage Crystal Reports to include
additional data not supplied in the DBF files created by the Vantage
application. The problem here is that the DBF's use a different
database driver than ODBC does and Crystal will only allow the use of
one driver at a time. The ONLY STABLE WAY that I found to include
additional data was to use a subreport in the modified Vantage
Crystal report to display the additional data from the Progress
tables. Using this method you can print the report without any
additional steps so it is invisible to the end user. You can make
this subreport as small as you want in the main report so it displays
just one field and it just looks like any other field in the report.
The subreport will allow you to use a different driver (ODBC driver)
than the one used in the main report (XBASE Driver). Two things that
you should know:
1. It will take slightly longer to print a report that contains a
subreport.
2. ODBC must be installed on every workstation that will print the
report.
Our shop travelers actually have 3 subreports within the main report
that allow us to include the primary bin for the part, the bin
locations and bin quantities of the raw material components and any
salvage parts and their bin locations. I have several reports that I
have modified this way and it works great. I hope this wasn't too
confusing. We are using Vantage 3.00.632 and Crystal 7. Any
questions feel free to contact me directly.

-----Original Message-----
Date: Wed, 16 Aug 2000 10:25:59 -0400
From: Rick Lane <rickl@...>
Subject: RE: Crystal Help

I assume that you are trying to link these tables to the customer
master
table via ODBC? If you are you may want to give up now. Linking the
standard Vantage reports to the actual Progress tables via ODBC is
extremely
flaky at best, and I have never been able to link it to more than one
table.

Two other solutions to consider:

1) Re-write the packing slip in complete ODBC (creates some of it's
own
problems).

2) Better yet, create a VBForm field in the packing slip header that
contains fields you need printed on the packing slip. Create a
button on
the VBForm that calls a simply Progress procedure to copy the VBForm
fields
from the customer master table into the VBForm in the packing slip
header.
These fields are then readily available for printing on the standard
packing
slip.


-----Original Message-----
Date: Wed, 16 Aug 2000 12:47:02 -0000
From: "Les Tingley" <ltingley@...>
Subject: Crystal Help

I need to add a Vantage basic field from my Customer Table to my
Crystal Reports Packing Slip. The Ship head Table contains the CUSTID
as well as the CUSTNUM. Linking these fields does not work, however.
I'm assuming because of the join type. When I go into Visual Linking,
the Join types are grayed out. Can anybody tell why this is and or
how to correct this?

Thanks,
Les





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

------------------------------------------------------------------------------



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