Crystal Report or any other query tool?

Thanks Adams,
I will try your tool after I find out about the ODBC of Crystal
report. As of now, I don't see it anywhere. Could you show me how
and what to add into the ODBC Admin? Thanks.

-------------------
--- In vantage@yahoogroups.com, Adam Ellis <AELinuxGuy@n...> wrote:
> You might want to give my scheduler tool a shot. I think a couple
of
> people on the list here are using it with good luck. I have been
> sitting on a new release of the utility hoping to achieve a few more
> design goals and declare a stable version, but everybody has been
> waiting long enough. To begin with, here is a short description of
the
> utility for those unfamiliar with it:
>
> The SaberLogic RPT Tool (formerly called RPT Scheduler) is a free
> utility to automate the delivery of Crystal Reports to e-mail,
printer,
> or file system. As of 10/29/03, the utility can also be used as a
> Crystal Reports viewer (this will be much more significant in
Crystal 9
> where the Report Distribution Expert is *officially* phased out).
My VB
> source code is released under the GNU Public License
> (http://www.gnu.org/licenses/gpl.txt), however there are proprietary
> ActiveX controls (from Crystal Decisions) included with the
project.
> The distribution of these controls, I have learned, requires that I
> maintain a list of users - so please e-mail me your contact info if
you
> use my utility.
>
> The theory of operation is simple. You will have various ini files
that
> contain a list of reports to run and how to run them. These ini
files
> will be passed to an executable that does whatever the ini file
tells it
> to do. The executions is scheduled through Windows Task
Scheduler. So,
> for example, you may create a daily.ini file that says to print off
all
> your employee time cards, e-mail a PDF shipping schedule to your
> shipping department, and save material status reports for each of
your
> customers onto your web server. Then, inside Windows Task
Scheduler,
> you set up a job to run "rptscheduler.exe daily.ini" every day at
5:00
> AM. And that's it - you don't worry about it again.
>
> There have been a lot of changes since my last release. As I've
> mentioned, there is now a ViewReport command that acts as a
replacement
> for the Crystal runtime viewer. I've also added parameters to
> automatically pass the database username and database password.
Error
> handling is a bit better. There are also commands to specify the
> printer, driver, & orientation. Most significantly, I've done away
with
> the old setup where each report run has it's own binary. As
illustrated
> above, the ini file is passed to the rptscheduler binary - so now
you
> can have as many ini files as you like running in whatever
complicated
> manner you like. See the readme for all of the juicy details.
>
> Anyway, here is the download link:
>
> http://24.123.247.30/~aellis/downloads/
>
> Let me know if you have any questions,
> AE
>
> P.S. I believe your ODBC drivers are installed with the Vantage 4.0
> client. Go to the ODBC Administrator and add a new dsn - I believe
> there is a Progress driver already there.
>
> On Fri, 2003-10-31 at 14:09, quangthuy wrote:
>
> > Mike,
> >
> > Thanks for your help. I don't have the ODBC for Crystal 7 to run
> > with Vantage 4. Do you have it? And window scheduler won't work
> > because window can just call the application. Then, in Crystal
> > Report needs to run and then print. I never use winbatch so can
you
> > be more specific about how to use it?
> >
> > Thanks.
>
>
>
>
> [Non-text portions of this message have been removed]
Hi,

I need to design a report that can run and print by itself daily.
Report Builder and Export Utility don't have this feature. Crystal
report has the function "Set print Date/Time" just for 1 time. This
is acceptable if I don't have any other option.

Do you know any 3rd party software that can run with Vantage 4.00.9
and can be set to run and print to a router "SigmaTrak" version
1.0.1D? Or

Do you have the ODBC that I can install in WinXP Home version to run
with Vantage?

Any help or suggestion would be very appreciated.

Please forward any mail to qle@...
If your report requires no parameters then you can create a Crystal
distribution and schedule the .exe in windows scheduler. If the report does
require input parameters, then you can use a scripting environment like
winbatch to call a routine from the windows scheduler that calls the report.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

-----Original Message-----
From: quangthuy [mailto:quangthuy@...]
Sent: Friday, October 31, 2003 8:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report or any other query tool???

Hi,

I need to design a report that can run and print by itself daily.
Report Builder and Export Utility don't have this feature. Crystal report
has the function "Set print Date/Time" just for 1 time. This is acceptable
if I don't have any other option.

Do you know any 3rd party software that can run with Vantage 4.00.9 and can
be set to run and print to a router "SigmaTrak" version 1.0.1D? Or

Do you have the ODBC that I can install in WinXP Home version to run with
Vantage?

Any help or suggestion would be very appreciated.

Please forward any mail to qle@...



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

Thanks for your help. I don't have the ODBC for Crystal 7 to run
with Vantage 4. Do you have it? And window scheduler won't work
because window can just call the application. Then, in Crystal
Report needs to run and then print. I never use winbatch so can you
be more specific about how to use it?

Thanks.


--- In vantage@yahoogroups.com, "Michael Barry" <mbarry@b...> wrote:
> If your report requires no parameters then you can create a Crystal
> distribution and schedule the .exe in windows scheduler. If the
report does
> require input parameters, then you can use a scripting environment
like
> winbatch to call a routine from the windows scheduler that calls
the report.
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> -----Original Message-----
> From: quangthuy [mailto:quangthuy@y...]
> Sent: Friday, October 31, 2003 8:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report or any other query tool???
>
> Hi,
>
> I need to design a report that can run and print by itself daily.
> Report Builder and Export Utility don't have this feature. Crystal
report
> has the function "Set print Date/Time" just for 1 time. This is
acceptable
> if I don't have any other option.
>
> Do you know any 3rd party software that can run with Vantage 4.00.9
and can
> be set to run and print to a router "SigmaTrak" version 1.0.1D? Or
>
> Do you have the ODBC that I can install in WinXP Home version to
run with
> Vantage?
>
> Any help or suggestion would be very appreciated.
>
> Please forward any mail to qle@h...
>
>
>
> 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/
You might want to give my scheduler tool a shot. I think a couple of
people on the list here are using it with good luck. I have been
sitting on a new release of the utility hoping to achieve a few more
design goals and declare a stable version, but everybody has been
waiting long enough. To begin with, here is a short description of the
utility for those unfamiliar with it:

The SaberLogic RPT Tool (formerly called RPT Scheduler) is a free
utility to automate the delivery of Crystal Reports to e-mail, printer,
or file system. As of 10/29/03, the utility can also be used as a
Crystal Reports viewer (this will be much more significant in Crystal 9
where the Report Distribution Expert is *officially* phased out). My VB
source code is released under the GNU Public License
(http://www.gnu.org/licenses/gpl.txt), however there are proprietary
ActiveX controls (from Crystal Decisions) included with the project.
The distribution of these controls, I have learned, requires that I
maintain a list of users - so please e-mail me your contact info if you
use my utility.

The theory of operation is simple. You will have various ini files that
contain a list of reports to run and how to run them. These ini files
will be passed to an executable that does whatever the ini file tells it
to do. The executions is scheduled through Windows Task Scheduler. So,
for example, you may create a daily.ini file that says to print off all
your employee time cards, e-mail a PDF shipping schedule to your
shipping department, and save material status reports for each of your
customers onto your web server. Then, inside Windows Task Scheduler,
you set up a job to run "rptscheduler.exe daily.ini" every day at 5:00
AM. And that's it - you don't worry about it again.

There have been a lot of changes since my last release. As I've
mentioned, there is now a ViewReport command that acts as a replacement
for the Crystal runtime viewer. I've also added parameters to
automatically pass the database username and database password. Error
handling is a bit better. There are also commands to specify the
printer, driver, & orientation. Most significantly, I've done away with
the old setup where each report run has it's own binary. As illustrated
above, the ini file is passed to the rptscheduler binary - so now you
can have as many ini files as you like running in whatever complicated
manner you like. See the readme for all of the juicy details.

Anyway, here is the download link:

http://24.123.247.30/~aellis/downloads/

Let me know if you have any questions,
AE

P.S. I believe your ODBC drivers are installed with the Vantage 4.0
client. Go to the ODBC Administrator and add a new dsn - I believe
there is a Progress driver already there.

On Fri, 2003-10-31 at 14:09, quangthuy wrote:

> Mike,
>
> Thanks for your help. I don't have the ODBC for Crystal 7 to run
> with Vantage 4. Do you have it? And window scheduler won't work
> because window can just call the application. Then, in Crystal
> Report needs to run and then print. I never use winbatch so can you
> be more specific about how to use it?
>
> Thanks.




[Non-text portions of this message have been removed]
I have been using Adam's scheduler for a year now, and it works simply
GREAT.

I'm looking forward to using this new version now.
Thanks Adam for sharing your skills and making them available to the
'community'.

Troy Funte
Liberty Electronics

-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Saturday, November 01, 2003 1:03 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal Report or any other query tool???


You might want to give my scheduler tool a shot. I think a couple of
people on the list here are using it with good luck. I have been
sitting on a new release of the utility hoping to achieve a few more
design goals and declare a stable version, but everybody has been
waiting long enough. To begin with, here is a short description of the
utility for those unfamiliar with it:

The SaberLogic RPT Tool (formerly called RPT Scheduler) is a free
utility to automate the delivery of Crystal Reports to e-mail, printer,
or file system. As of 10/29/03, the utility can also be used as a
Crystal Reports viewer (this will be much more significant in Crystal 9
where the Report Distribution Expert is *officially* phased out). My VB
source code is released under the GNU Public License
(http://www.gnu.org/licenses/gpl.txt), however there are proprietary
ActiveX controls (from Crystal Decisions) included with the project.
The distribution of these controls, I have learned, requires that I
maintain a list of users - so please e-mail me your contact info if you
use my utility.

The theory of operation is simple. You will have various ini files that
contain a list of reports to run and how to run them. These ini files
will be passed to an executable that does whatever the ini file tells it
to do. The executions is scheduled through Windows Task Scheduler. So,
for example, you may create a daily.ini file that says to print off all
your employee time cards, e-mail a PDF shipping schedule to your
shipping department, and save material status reports for each of your
customers onto your web server. Then, inside Windows Task Scheduler,
you set up a job to run "rptscheduler.exe daily.ini" every day at 5:00
AM. And that's it - you don't worry about it again.

There have been a lot of changes since my last release. As I've
mentioned, there is now a ViewReport command that acts as a replacement
for the Crystal runtime viewer. I've also added parameters to
automatically pass the database username and database password. Error
handling is a bit better. There are also commands to specify the
printer, driver, & orientation. Most significantly, I've done away with
the old setup where each report run has it's own binary. As illustrated
above, the ini file is passed to the rptscheduler binary - so now you
can have as many ini files as you like running in whatever complicated
manner you like. See the readme for all of the juicy details.

Anyway, here is the download link:

http://24.123.247.30/~aellis/downloads/

Let me know if you have any questions,
AE

P.S. I believe your ODBC drivers are installed with the Vantage 4.0
client. Go to the ODBC Administrator and add a new dsn - I believe
there is a Progress driver already there.

On Fri, 2003-10-31 at 14:09, quangthuy wrote:

> Mike,
>
> Thanks for your help. I don't have the ODBC for Crystal 7 to run
> with Vantage 4. Do you have it? And window scheduler won't work
> because window can just call the application. Then, in Crystal
> Report needs to run and then print. I never use winbatch so can you
> be more specific about how to use it?
>
> Thanks.




[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]