Shirley is right... when is she not? I linked the comments field on the RMA
exactly as described below. But I added this to the Vantage.ini to
automatically open a connection to the database.
VantageODBCServer=(connection name)
VantageODBCDbse=(DB Name)
VantageODBCUser=(ODBC username)
VantageODBCpasswd=(ODBC user password)
David Gartner
EPG Companies Inc.
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, December 17, 2003 7:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Linking in Crystal 8.5
When linking two different field types in crystal ie (numeric - alpha)
(alpha - numeric), create a calculated field to convert to the desired
data type. TOTEXT(NUMERIC FIELD) or TONUMBER(ALPHA FIELD). If I recall
correctly it seems to work best when you do your conversion in the
master report to the sub report. Sub report has numeric data in alpha
field. Corresponding field in master report is numeric. In master
report convert your numeric data to alpha using TOTEXT( NUMERIC MASTER
REPORT FIELD) then use the converted field in your link to the sub
report.
Shirley Graver
Systems administrator
Rubber Associates inc
-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Wednesday, December 17, 2003 8:33 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Linking in Crystal 8.5
Hello Richard,
I did this a few years ago trying to create my own traveler, but gave up
on
the project because I could figure out how to distribute the report
containing 2 different database. As I recall I created a subreport
containing the ODBC table (use a a DSN that does not require a password,
search on e-portal for ODBC). I link the subreport using a parameter
field.
You may need to change a field type i.e Totext(). It was a while back,
and
as I recalled it required a fair amount of trail and swear.
Good Luck!
Dan Shallbetter
States Electric
-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Wednesday, December 17, 2003 5:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Linking in Crystal 8.5
Can any Crystal expert help here.......
I want to amend our version of the Crystal RMA form because (as usual)
the
data included in the available .dbf files is lacking.
Using ODBC I want to link to the actual Vantage database RMADtl line to
pick
up the Notes field and print it on the document.
I add the database table to the report giving it an alias of
RMADtl_Database.
So far so good.
I link to the database file using the RMANO from the rmahead.dbf and the
RMALINE from the rmadtl.dbf.
I get a warning that the link may not be successful due to different
field
types on the link fields, i.e. the .dbf fields are 'string' whilst the
database fields are 'number'
The warning is correct, the link isn't successful! No data is retrieved
when
I run the form.
Question is, how can I get this to work?
All/any advice gratefully received
We're running 6.0 and Crystal 8.5
Regards,
Richard
Richard Bailey
IT Systems Co-Ordinator & Czar Of All The Russias
Dudley Industries
Mailto rbailey@...
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/>
<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 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
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/.
<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
<http://rd.yahoo.com/SIG=12c13rnnr/M=259395.3614674.4902533.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1071754415/A=1524963/R=0/*http:/hits.411web.
com/cgi-bin/autoredir?camp=556&lineid=3614674âˆ=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=657058725>
_____
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.
Tracking #: 8F06BE8268D1574C997EB560DFBAC698445D4CB8
[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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
exactly as described below. But I added this to the Vantage.ini to
automatically open a connection to the database.
VantageODBCServer=(connection name)
VantageODBCDbse=(DB Name)
VantageODBCUser=(ODBC username)
VantageODBCpasswd=(ODBC user password)
David Gartner
EPG Companies Inc.
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, December 17, 2003 7:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Linking in Crystal 8.5
When linking two different field types in crystal ie (numeric - alpha)
(alpha - numeric), create a calculated field to convert to the desired
data type. TOTEXT(NUMERIC FIELD) or TONUMBER(ALPHA FIELD). If I recall
correctly it seems to work best when you do your conversion in the
master report to the sub report. Sub report has numeric data in alpha
field. Corresponding field in master report is numeric. In master
report convert your numeric data to alpha using TOTEXT( NUMERIC MASTER
REPORT FIELD) then use the converted field in your link to the sub
report.
Shirley Graver
Systems administrator
Rubber Associates inc
-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Wednesday, December 17, 2003 8:33 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Linking in Crystal 8.5
Hello Richard,
I did this a few years ago trying to create my own traveler, but gave up
on
the project because I could figure out how to distribute the report
containing 2 different database. As I recall I created a subreport
containing the ODBC table (use a a DSN that does not require a password,
search on e-portal for ODBC). I link the subreport using a parameter
field.
You may need to change a field type i.e Totext(). It was a while back,
and
as I recalled it required a fair amount of trail and swear.
Good Luck!
Dan Shallbetter
States Electric
-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Wednesday, December 17, 2003 5:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Linking in Crystal 8.5
Can any Crystal expert help here.......
I want to amend our version of the Crystal RMA form because (as usual)
the
data included in the available .dbf files is lacking.
Using ODBC I want to link to the actual Vantage database RMADtl line to
pick
up the Notes field and print it on the document.
I add the database table to the report giving it an alias of
RMADtl_Database.
So far so good.
I link to the database file using the RMANO from the rmahead.dbf and the
RMALINE from the rmadtl.dbf.
I get a warning that the link may not be successful due to different
field
types on the link fields, i.e. the .dbf fields are 'string' whilst the
database fields are 'number'
The warning is correct, the link isn't successful! No data is retrieved
when
I run the form.
Question is, how can I get this to work?
All/any advice gratefully received
We're running 6.0 and Crystal 8.5
Regards,
Richard
Richard Bailey
IT Systems Co-Ordinator & Czar Of All The Russias
Dudley Industries
Mailto rbailey@...
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/>
<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 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
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/.
<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
<http://rd.yahoo.com/SIG=12c13rnnr/M=259395.3614674.4902533.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1071754415/A=1524963/R=0/*http:/hits.411web.
com/cgi-bin/autoredir?camp=556&lineid=3614674âˆ=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egrou
pmail/S=:HM/A=1524963/rand=657058725>
_____
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.
Tracking #: 8F06BE8268D1574C997EB560DFBAC698445D4CB8
[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
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]