Progress Code To Create DBFs

Yahoo Archive
1
We use ODBC to Access a lot and don't have problems with speed, but
I'm not querying the linked tables when I run a report either, that
IS painfully slow. I use Make Table Queries to dump the info I need
from the Linked tables to Access tables. Once that is done Access
kicks butt on the reports. If you can refresh the data each night it
works really well, we use a product called Total Visual Agent to
schedule our nightly updates. If you need real time info its not as
fast because the Make Table Queries can take a little time, depending
on the tables your dealing with and what you can filter out. Only
use the fields you need, don't dump the whole table. You can use
Access reports or Crystal reports from the Access table, we do both
depending on what is needed. Access will actually be a lot faster
than web-reporting, especially if you can update the info nightly,
the users will like that. Just another option.

Brian Stenglein
Clow Stamping Co.



--- In vantage@yahoogroups.com, Adam Ellis <AELinuxGuy@n...> wrote:
> For all the Progress hackers out there:
>
> With a stock install of Vantage (no 4GL or anything like that), does
> anybody know if it is possible to script Progress to create local
DBFs
> like Vantage does for reporting purposes (creating new reports...not
> pre-existing ones)? We currently use ODBC, but it is dog slow for
> complex reports and makes Vantage upgrades a tedious process.
>
> Thanks,
> AE
>
>
> [Non-text portions of this message have been removed]
2
For all the Progress hackers out there:

With a stock install of Vantage (no 4GL or anything like that), does
anybody know if it is possible to script Progress to create local DBFs
like Vantage does for reporting purposes (creating new reports...not
pre-existing ones)? We currently use ODBC, but it is dog slow for
complex reports and makes Vantage upgrades a tedious process.

Thanks,
AE


[Non-text portions of this message have been removed]
3
Isn't a DBF file basically the same as a CSV file? When you open a DBF in Excel it works just like a CSV file. Couldn't you run an export (or two or more) to spreadsheet format and use them with Crystal?
-Todd C.

-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Monday, October 13, 2003 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Code To Create DBFs


For all the Progress hackers out there:

With a stock install of Vantage (no 4GL or anything like that), does
anybody know if it is possible to script Progress to create local DBFs
like Vantage does for reporting purposes (creating new reports...not
pre-existing ones)? We currently use ODBC, but it is dog slow for
complex reports and makes Vantage upgrades a tedious process.

Thanks,
AE


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



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=523550772>

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

We've used 4GL to export data to Access MDB files. Then use Crystal
against the mdb. Also with Vantage upgrades, you don't need to set a
location or verify the database. The Crystal report points to the mdb
file. Works faster than ODBC for complex report exports. Install
Access on the server and only the FREE client component from MS on
each pc that will use it.

The progress knowledge base has many code samples to create an mdb
file as well as progress code for exporting data.

HTH,
Misha 1, Ltd.
Calvin Dekker






-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, October 13, 2003 11:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Code To Create DBFs


Isn't a DBF file basically the same as a CSV file? When you open a DBF in
Excel it works just like a CSV file. Couldn't you run an export (or two or
more) to spreadsheet format and use them with Crystal?
-Todd C.

-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Monday, October 13, 2003 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Code To Create DBFs


For all the Progress hackers out there:

With a stock install of Vantage (no 4GL or anything like that), does
anybody know if it is possible to script Progress to create local DBFs
like Vantage does for reporting purposes (creating new reports...not
pre-existing ones)? We currently use ODBC, but it is dog slow for
complex reports and makes Vantage upgrades a tedious process.

Thanks,
AE


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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=523550772>

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]



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/
5
On Mon, 2003-10-13 at 12:34, Todd Caughey wrote:

> Isn't a DBF file basically the same as a CSV file? When you open a DBF in Excel it works just like a CSV file. Couldn't you run an export (or two or more) to spreadsheet format and use them with Crystal?
> -Todd C.

Todd,

Absolutely...I am not married to the DBF at this point for the project,
so any format that Crystal can report off of is valid. I am looking to
write a new Crystal Reports runtime to work around this process (i.e.
you select my uber-complicated stock status report from inside Vantage,
fill in the report parameters, Visual Basic calls this Progress routine
to grab the needed data, and the report is returned to the screen).
I'll see what I can make of the examples on the Progress web site.

AE


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

Where is this progress knowledge base located?

Thanks,
Jasper

-----Original Message-----
From: Calvin Dekker [mailto:calvin@...]
Sent: Monday, October 13, 2003 12:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Code To Create DBFs


Adam -

We've used 4GL to export data to Access MDB files. Then use Crystal
against the mdb. Also with Vantage upgrades, you don't need to set a
location or verify the database. The Crystal report points to the mdb
file. Works faster than ODBC for complex report exports. Install
Access on the server and only the FREE client component from MS on
each pc that will use it.

The progress knowledge base has many code samples to create an mdb
file as well as progress code for exporting data.

HTH,
Misha 1, Ltd.
Calvin Dekker






-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, October 13, 2003 11:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Code To Create DBFs


Isn't a DBF file basically the same as a CSV file? When you open a DBF in
Excel it works just like a CSV file. Couldn't you run an export (or two or
more) to spreadsheet format and use them with Crystal?
-Todd C.

-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Monday, October 13, 2003 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Code To Create DBFs


For all the Progress hackers out there:

With a stock install of Vantage (no 4GL or anything like that), does
anybody know if it is possible to script Progress to create local DBFs
like Vantage does for reporting purposes (creating new reports...not
pre-existing ones)? We currently use ODBC, but it is dog slow for
complex reports and makes Vantage upgrades a tedious process.

Thanks,
AE


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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=523550772>

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]



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/



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/
7
Jasper,

The website is:
http://www.progress.com/tech_support/knowledge_center/index.ssp

HTH,
Misha 1, Ltd.
Calvin Dekker

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, October 13, 2003 1:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Code To Create DBFs


Calvin,

Where is this progress knowledge base located?

Thanks,
Jasper

-----Original Message-----
From: Calvin Dekker [mailto:calvin@...]
Sent: Monday, October 13, 2003 12:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Code To Create DBFs


Adam -

We've used 4GL to export data to Access MDB files. Then use Crystal
against the mdb. Also with Vantage upgrades, you don't need to set a
location or verify the database. The Crystal report points to the mdb
file. Works faster than ODBC for complex report exports. Install
Access on the server and only the FREE client component from MS on
each pc that will use it.

The progress knowledge base has many code samples to create an mdb
file as well as progress code for exporting data.

HTH,
Misha 1, Ltd.
Calvin Dekker






-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, October 13, 2003 11:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Code To Create DBFs


Isn't a DBF file basically the same as a CSV file? When you open a DBF in
Excel it works just like a CSV file. Couldn't you run an export (or two or
more) to spreadsheet format and use them with Crystal?
-Todd C.

-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Monday, October 13, 2003 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Code To Create DBFs


For all the Progress hackers out there:

With a stock install of Vantage (no 4GL or anything like that), does
anybody know if it is possible to script Progress to create local DBFs
like Vantage does for reporting purposes (creating new reports...not
pre-existing ones)? We currently use ODBC, but it is dog slow for
complex reports and makes Vantage upgrades a tedious process.

Thanks,
AE


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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=523550772>

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]



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/



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/




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/