Crystal & User Defined Field

Yahoo Archive
1
Wendy,
in order for the user defined fields to show up in crystal, you have
to insure
that there is an alias define in the vb field (assuming the field makes it
to the dbf).
The alias goes in the external name field. After you fill that text box,
you should
see it as a selection in your crystal designer.
good luck,




>Hmmm........I do have ODBC set up but I didn't think I could mix ODBC with
a standard "Vantage-created" form........or can >I? Otherwise I still don't
see the field after I print preview and verify.
2
Hey everyone!

I saw that our user defined field labels are found in the XaSyst table. Well, at least I'm only seeing the LABELS for the user defined fields. Specifically, I'm looking for the QuoteUserDate1Field. It says in Vantage that it is called QuoteHed.UserDate1. Unfortunately I haven't found the field in either the QuoteHed or XaSyst table.

Does anyone know where the QuoteHed.UserDate1 is found in Crystal?

~Wendy

[Non-text portions of this message have been removed]
3
Print preview a quote in Vantage (to create DBF file). Then in Crystal "Verify Database" to have it find any new fields. It should then show up with a similar name near the bottom of the list of fields for QuoteHed table. On the other hand if it was a field not deemed important enough to get into the DBF file your out of luck without ODBC. You could open the DBF file with Excel (or similar) and see if the data got that far.
-Todd C.

-----Original Message-----
From: Wendy Bowen [mailto:wpursche@...]
Sent: Thursday, February 20, 2003 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal & User Defined Field


Hey everyone!

I saw that our user defined field labels are found in the XaSyst table. Well, at least I'm only seeing the LABELS for the user defined fields. Specifically, I'm looking for the QuoteUserDate1Field. It says in Vantage that it is called QuoteHed.UserDate1. Unfortunately I haven't found the field in either the QuoteHed or XaSyst table.

Does anyone know where the QuoteHed.UserDate1 is found in Crystal?

~Wendy

[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=1705007183:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
<http://us.adserver.yahoo.com/l?M=245454.2994396.4323964.2848452/D=egroupmail/S=:HM/A=1457554/rand=734997556>

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]
4
Hmmm........I do have ODBC set up but I didn't think I could mix ODBC with a standard "Vantage-created" form........or can I? Otherwise I still don't see the field after I print preview and verify.

~Wendy
----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com
Sent: Thursday, February 20, 2003 2:33 PM
Subject: RE: [Vantage] Crystal & User Defined Field


Print preview a quote in Vantage (to create DBF file). Then in Crystal "Verify Database" to have it find any new fields. It should then show up with a similar name near the bottom of the list of fields for QuoteHed table. On the other hand if it was a field not deemed important enough to get into the DBF file your out of luck without ODBC. You could open the DBF file with Excel (or similar) and see if the data got that far.
-Todd C.

-----Original Message-----
From: Wendy Bowen [mailto:wpursche@...]
Sent: Thursday, February 20, 2003 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal & User Defined Field


Hey everyone!

I saw that our user defined field labels are found in the XaSyst table. Well, at least I'm only seeing the LABELS for the user defined fields. Specifically, I'm looking for the QuoteUserDate1Field. It says in Vantage that it is called QuoteHed.UserDate1. Unfortunately I haven't found the field in either the QuoteHed or XaSyst table.

Does anyone know where the QuoteHed.UserDate1 is found in Crystal?

~Wendy

[Non-text portions of this message have been removed]
5
Wendy
You can mix odbc using a subreport. I try to avoid using any
sort of calculation in them as if you don't get it right they are a pain to
debug. I have a lot of reports where I mix an ODBC "single" field subreport
with the regular canned report. (Somebody ALWAYS wants to see something
that isn't there)

Shirley

-----Original Message-----
From: Wendy Bowen [mailto:wpursche@...]
Sent: Thursday, February 20, 2003 2:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal & User Defined Field

Hmmm........I do have ODBC set up but I didn't think I could mix ODBC with a
standard "Vantage-created" form........or can I? Otherwise I still don't see
the field after I print preview and verify.

~Wendy
----- Original Message -----
From: Todd Caughey
To: vantage@yahoogroups.com
Sent: Thursday, February 20, 2003 2:33 PM
Subject: RE: [Vantage] Crystal & User Defined Field


Print preview a quote in Vantage (to create DBF file). Then in Crystal
"Verify Database" to have it find any new fields. It should then show up
with a similar name near the bottom of the list of fields for QuoteHed
table. On the other hand if it was a field not deemed important enough to
get into the DBF file your out of luck without ODBC. You could open the DBF
file with Excel (or similar) and see if the data got that far.
-Todd C.

-----Original Message-----
From: Wendy Bowen [mailto:wpursche@...]
Sent: Thursday, February 20, 2003 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal & User Defined Field


Hey everyone!

I saw that our user defined field labels are found in the XaSyst table.
Well, at least I'm only seeing the LABELS for the user defined fields.
Specifically, I'm looking for the QuoteUserDate1Field. It says in Vantage
that it is called QuoteHed.UserDate1. Unfortunately I haven't found the
field in either the QuoteHed or XaSyst table.

Does anyone know where the QuoteHed.UserDate1 is found in Crystal?

~Wendy

[Non-text portions of this message have been removed]




Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=17050071
83:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>


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]