Lori,
I just was doing this for the first time today myself. To get a VB Form field to show up on a Vantage Report you need to:
1. In the Forms Design screen, double-click on your new VB field, then enter a name in the "External Name" field. This 8 character name will be preceded by two more letters designating the table which contain the fields. Save the Form. This will be the field name used in Vantage reports.
2. Do a "Print Preview" of the form in Vantage that you are modifying.
3. In Crystal, do a "Database/Verify Database" and Crystal should recognize the change in one of the tables in your report. Now the field should be visible in the appropriate table and thus usable in your report.
Troy Funte
Liberty Electronics
I just was doing this for the first time today myself. To get a VB Form field to show up on a Vantage Report you need to:
1. In the Forms Design screen, double-click on your new VB field, then enter a name in the "External Name" field. This 8 character name will be preceded by two more letters designating the table which contain the fields. Save the Form. This will be the field name used in Vantage reports.
2. Do a "Print Preview" of the form in Vantage that you are modifying.
3. In Crystal, do a "Database/Verify Database" and Crystal should recognize the change in one of the tables in your report. Now the field should be visible in the appropriate table and thus usable in your report.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Lori Baker
To: 'Vantage Onelist'
Sent: Tuesday, April 30, 2002 4:38 PM
Subject: [Vantage] Crystal Reports - Sorting by VBA Form Fields
I have created a VBA form for some information regarding a part and I want
to sort a Crystal Report by the character fields. I do not see these fields
as choices to group by. Can I not do this? We are going to base our
structure off these fields but my reporting will require this grouping. Can
anyone give me any insight on this situation?
Thank you - Lori
Lori A. Baker
Accountant/Information Systems
CardioPak Inc.
406.259.6387
Fax: 406.256.9875
lori_baker@... <mailto:lori_baker@...>
www.cardiopak.com <http://www.cardiopak.com>
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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]