Need help with Crystal Reports

Yahoo Archive
1
Mike,
Perhaps all you need to do (in Crystal) is to click menu, Database /
Verify Database. This will update any new fields (ie the UserChar01 field
from the VBForm) and Crystal will recognize it. The other thing to do is to
check to see if you gave the UserChar01 field an 'external' name in your
VBForm. If so, you will see the field in Crystal under that 'external name'
after you click the Verify Database command in Crystal.

Troy Funte
Liberty Electronics

-----Original Message-----
From: michael.j.moloney@...
[mailto:michael.j.moloney@...]
Sent: Wednesday, February 12, 2003 4:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Need help with Crystal Reports


I am trying to add the order header table to the Crystal Reports version
of
the Packing Slip so I can add the UserChar01 field from the Order Header
table in the report, but when I link it the data in that field doesn't
show
up. The set locations for the existing tables are set to C:\vntgwk52, but
my newly linked table is PUB.OrderHed through ODBC. How do I need to set
this up?

Thanks in advance for your help:
Mike Moloney

CONFIDENTIALITY : This e-mail and any attachments are confidential and may
be privileged. If you are not a named recipient, please notify the sender
immediately and do not open any attachments hereto, disclose the contents
of this e-mail or the attachments if any thereto, to another person, use
it
for any purpose or store or copy the information in any medium.


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]
2
I am trying to add the order header table to the Crystal Reports version of
the Packing Slip so I can add the UserChar01 field from the Order Header
table in the report, but when I link it the data in that field doesn't show
up. The set locations for the existing tables are set to C:\vntgwk52, but
my newly linked table is PUB.OrderHed through ODBC. How do I need to set
this up?

Thanks in advance for your help:
Mike Moloney

CONFIDENTIALITY : This e-mail and any attachments are confidential and may
be privileged. If you are not a named recipient, please notify the sender
immediately and do not open any attachments hereto, disclose the contents
of this e-mail or the attachments if any thereto, to another person, use it
for any purpose or store or copy the information in any medium.
3
Mike,

Linking DBFs to ODBC tables is funny like that sometimes. If you are
lucky, all of the field types you want to link in the DBF match the
field types carried over in the ODBC tables. For example, they will
*for some reason* set up the fields in the dbf as strings while the
fields pulled over via odbc are integers. In practice the field types
seem to match no more then 25% of the time. The remaining 75% of the
time the link is bad and results in no data. You can do something like
find some field that will link up and use the select expert to match the
records (using ToText or ToNumber), but that is not a very good report
design practice and is just asking for problems. In the end, I've
always ended up just re-writing the report completely with ODBC tables
when I need data not in the dbf where the field types don't match up...I
am sure that is not what you wanted to hear ;-)

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

michael.j.moloney@... wrote:

>I am trying to add the order header table to the Crystal Reports version of
>the Packing Slip so I can add the UserChar01 field from the Order Header
>table in the report, but when I link it the data in that field doesn't show
>up. The set locations for the existing tables are set to C:\vntgwk52, but
>my newly linked table is PUB.OrderHed through ODBC. How do I need to set
>this up?
>
>Thanks in advance for your help:
>Mike Moloney
>
>CONFIDENTIALITY : This e-mail and any attachments are confidential and may
>be privileged. If you are not a named recipient, please notify the sender
>immediately and do not open any attachments hereto, disclose the contents
>of this e-mail or the attachments if any thereto, to another person, use it
>for any purpose or store or copy the information in any medium.
>
>
>
>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/
>
>
>
>
>
4
I do have a work around for this problem, it is a bit involved, but
it does work. I've used it on a couple of different Crystal Forms
when I've wanted to insert data not included in the DBF's. I create
an Access DB with an ODBC link to the table I want to add. I use a
series of querys and macros to create an Access table with the fields
that I want to add along with the fields necessary to link the tables
to the existing DBF's. The query's also change the data types and
formats of the fields as necessary so they can be linked. Then I
have to create a System DSN in the ODBC setup pointing to the Access
DB. Next I add the Access Table to the Crystal Report, link it to
the appropriate table, and add the field(s) I want. If I remember
right, Crystal might give an error regarding the table link when you
initially set it up, but it will work. The System DSN would have to
be added to each machine printing that document. Once setup the
users would have to run the Access macro periodically to update the
information from Vantage into the Access Table, but you would be able
to continue printing from within Vantage using the icons provided.

I think Troy has another work around that involves a Crystal
Subreport and some formulas to change to data type. I will let him
explain.

HTH,

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, Adam Ellis <AELinuxGuy@n...> wrote:
> Mike,
>
> Linking DBFs to ODBC tables is funny like that sometimes. If you
are
> lucky, all of the field types you want to link in the DBF match the
> field types carried over in the ODBC tables. For example, they
will
> *for some reason* set up the fields in the dbf as strings while
the
> fields pulled over via odbc are integers. In practice the field
types
> seem to match no more then 25% of the time. The remaining 75% of
the
> time the link is bad and results in no data. You can do something
like
> find some field that will link up and use the select expert to
match the
> records (using ToText or ToNumber), but that is not a very good
report
> design practice and is just asking for problems. In the end, I've
> always ended up just re-writing the report completely with ODBC
tables
> when I need data not in the dbf where the field types don't match
up...I
> am sure that is not what you wanted to hear ;-)
>
> 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
>
> michael.j.moloney@p... wrote:
>
> >I am trying to add the order header table to the Crystal Reports
version of
> >the Packing Slip so I can add the UserChar01 field from the Order
Header
> >table in the report, but when I link it the data in that field
doesn't show
> >up. The set locations for the existing tables are set to
C:\vntgwk52, but
> >my newly linked table is PUB.OrderHed through ODBC. How do I need
to set
> >this up?
> >
> >Thanks in advance for your help:
> >Mike Moloney
> >
> >CONFIDENTIALITY : This e-mail and any attachments are confidential
and may
> >be privileged. If you are not a named recipient, please notify the
sender
> >immediately and do not open any attachments hereto, disclose the
contents
> >of this e-mail or the attachments if any thereto, to another
person, use it
> >for any purpose or store or copy the information in any medium.
> >
> >
> >
> >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/
> >
> >
> >
> >
> >