Report Writing in Version 8

Michael-

What installation guide is it that you have, that has the
instructions for installing ODBC? I would like to get a copy. Thanks!

--- In vantage@yahoogroups.com, "Michael Barry" <mbarry@...> wrote:
>
> Gentlemen,
>
>
>
> Let's not be too quick to buy the corporate line and celebrate the
demise of
> ODBC just yet. There remain several compelling reasons to retain
the direct
> connect to the DB despite Epicor's protests to the contrary. First
is the
> fact that they have a vested interest in users utilizing their XML
export
> capability for reporting - simply put, it requires a Vantage
license to
> operate whereas ODBC does not. Second is the performance issue
with large
> multi-company DB's. We've actually witnessed a canned Vantage
Stock Status
> report generate over a 500MB XML file, take over 30 hours to
complete, and
> bring a quad dual-core server to its knees. An identical rewrite
with an
> ODBC connection on the same server completed in under a minute.
> Additionally, non-trivial queries involving multi-table joins or
complex
> filtering or sub-selects have been demonstrated to return
inconsistent
> and/or inaccurate results.
>
>
>
> Besides, it speaks volumes that while Epicor staff continues to
tell scary
> stories about the death of ODBC in the current version, their
install guide
> devotes an entire section to installing the ODBC drivers and
configuring a
> connection.
>
>
>
> Regards,
>
>
>
> Michael
>
>
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> <http://www.aspacia.com/> http://www.aspacia.com/
>
> This email, and any attachments thereto, is intended only for use
by the
> addressee(s) named herein and may contain legally privileged and/or
> confidential information. If you are not the intended recipient of
this
> email, you are hereby notified that any dissemination, distribution
or
> copying of this email, and any attachments thereto, is strictly
prohibited.
> If you have received this email in error, please immediately notify
me by
> telephone and permanently delete the original and any copy of any
email and
> any printout thereof.
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Todd Caughey
> Sent: Thursday, February 28, 2008 10:53 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Report Writing in Version 8
>
>
>
> Jasper,
> My take, based on Perspectives presentations, is that whatever BAQs
and
> dashboards don't handle for reporting the creation of XML files
(like 6.x
> DBF files) by your own BAQ routines will feed Crystal. No
limitations to
> provided fields either on the canned Crystal reports as you can add
anything
> from the tables involved and, I think, from other tables as well.
There is
> still ODBC for more or less direct to the DB but several Epicor
people have
> told be ODBC is basically dead for 8.x.
>
> In short reporting will be (is) far more flexible in 8.x. It will
still be a
> PITA for us to convert 500 or so RB reports BUT most of these are
simple
> query or lookup reports that will not require Crystal. Then again
som are
> very very complicated even for RB so the Crystal conversion will be
a
> challenge. In some cases I may use other reporting tools against
export XML
> files and am pondering some SharePoint Services potential for online
> reporting. But first things first...getting 8.x running with our
data. The
> rest will ahve to wait.
>
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of Jasper Recto
> Sent: Thursday, February 28, 2008 12:04 PM
> To: Vantage Groups (E-mail)
> Subject: [Vantage] Report Writing in Version 8
>
> In version 6, Vantage uses both Crystal reports and report builder
for its
> reporting.
>
> Report builder would connect directly to the database tables to get
its
> information. The crystal reports would have to get its information
from
> tables that are created and stored on the working directory on the
users c:\
> drive.
>
> In version 8, how does it work now without report builder?
>
> Does their built in crystal forms and reports still use tables
generated by
> the application or does it connect directly to the database tables?
>
> The reason I ask is because in version 6, the tables that are
generation
> don't always include ALL fields in the table it uses. If you need
some
> information that was not brought over to the temp table, you out of
luck.
>
> I noticed in the last thread titled 'Crystal Invoices', the user
used ODBC
> in their form to add more data. Can you do this for all their forms?
>
> Thanks,
> Jasper
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
In version 6, Vantage uses both Crystal reports and report builder for its reporting.

Report builder would connect directly to the database tables to get its information. The crystal reports would have to get its information from tables that are created and stored on the working directory on the users c:\ drive.

In version 8, how does it work now without report builder?

Does their built in crystal forms and reports still use tables generated by the application or does it connect directly to the database tables?

The reason I ask is because in version 6, the tables that are generation don't always include ALL fields in the table it uses. If you need some information that was not brought over to the temp table, you out of luck.

I noticed in the last thread titled 'Crystal Invoices', the user used ODBC in their form to add more data. Can you do this for all their forms?

Thanks,
Jasper



[Non-text portions of this message have been removed]
Jasper,
My take, based on Perspectives presentations, is that whatever BAQs and dashboards don't handle for reporting the creation of XML files (like 6.x DBF files) by your own BAQ routines will feed Crystal. No limitations to provided fields either on the canned Crystal reports as you can add anything from the tables involved and, I think, from other tables as well. There is still ODBC for more or less direct to the DB but several Epicor people have told be ODBC is basically dead for 8.x.

In short reporting will be (is) far more flexible in 8.x. It will still be a PITA for us to convert 500 or so RB reports BUT most of these are simple query or lookup reports that will not require Crystal. Then again som are very very complicated even for RB so the Crystal conversion will be a challenge. In some cases I may use other reporting tools against export XML files and am pondering some SharePoint Services potential for online reporting. But first things first...getting 8.x running with our data. The rest will ahve to wait.

-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jasper Recto
Sent: Thursday, February 28, 2008 12:04 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Writing in Version 8


In version 6, Vantage uses both Crystal reports and report builder for its reporting.

Report builder would connect directly to the database tables to get its information. The crystal reports would have to get its information from tables that are created and stored on the working directory on the users c:\ drive.

In version 8, how does it work now without report builder?

Does their built in crystal forms and reports still use tables generated by the application or does it connect directly to the database tables?

The reason I ask is because in version 6, the tables that are generation don't always include ALL fields in the table it uses. If you need some information that was not brought over to the temp table, you out of luck.

I noticed in the last thread titled 'Crystal Invoices', the user used ODBC in their form to add more data. Can you do this for all their forms?

Thanks,
Jasper

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





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



Let's not be too quick to buy the corporate line and celebrate the demise of
ODBC just yet. There remain several compelling reasons to retain the direct
connect to the DB despite Epicor's protests to the contrary. First is the
fact that they have a vested interest in users utilizing their XML export
capability for reporting - simply put, it requires a Vantage license to
operate whereas ODBC does not. Second is the performance issue with large
multi-company DB's. We've actually witnessed a canned Vantage Stock Status
report generate over a 500MB XML file, take over 30 hours to complete, and
bring a quad dual-core server to its knees. An identical rewrite with an
ODBC connection on the same server completed in under a minute.
Additionally, non-trivial queries involving multi-table joins or complex
filtering or sub-selects have been demonstrated to return inconsistent
and/or inaccurate results.



Besides, it speaks volumes that while Epicor staff continues to tell scary
stories about the death of ODBC in the current version, their install guide
devotes an entire section to installing the ODBC drivers and configuring a
connection.



Regards,



Michael



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

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please immediately notify me by
telephone and permanently delete the original and any copy of any email and
any printout thereof.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Todd Caughey
Sent: Thursday, February 28, 2008 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Writing in Version 8



Jasper,
My take, based on Perspectives presentations, is that whatever BAQs and
dashboards don't handle for reporting the creation of XML files (like 6.x
DBF files) by your own BAQ routines will feed Crystal. No limitations to
provided fields either on the canned Crystal reports as you can add anything
from the tables involved and, I think, from other tables as well. There is
still ODBC for more or less direct to the DB but several Epicor people have
told be ODBC is basically dead for 8.x.

In short reporting will be (is) far more flexible in 8.x. It will still be a
PITA for us to convert 500 or so RB reports BUT most of these are simple
query or lookup reports that will not require Crystal. Then again som are
very very complicated even for RB so the Crystal conversion will be a
challenge. In some cases I may use other reporting tools against export XML
files and am pondering some SharePoint Services potential for online
reporting. But first things first...getting 8.x running with our data. The
rest will ahve to wait.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jasper Recto
Sent: Thursday, February 28, 2008 12:04 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Writing in Version 8

In version 6, Vantage uses both Crystal reports and report builder for its
reporting.

Report builder would connect directly to the database tables to get its
information. The crystal reports would have to get its information from
tables that are created and stored on the working directory on the users c:\
drive.

In version 8, how does it work now without report builder?

Does their built in crystal forms and reports still use tables generated by
the application or does it connect directly to the database tables?

The reason I ask is because in version 6, the tables that are generation
don't always include ALL fields in the table it uses. If you need some
information that was not brought over to the temp table, you out of luck.

I noticed in the last thread titled 'Crystal Invoices', the user used ODBC
in their form to add more data. Can you do this for all their forms?

Thanks,
Jasper

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

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





[Non-text portions of this message have been removed]
I do all of my custom reports with ODBC and I'm on 8.03.305. The BAQs
don't allow for the complexity that I need in most reports.


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation


Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Barry
Sent: Thursday, February 28, 2008 2:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Writing in Version 8



Gentlemen,

Let's not be too quick to buy the corporate line and celebrate the
demise of
ODBC just yet. There remain several compelling reasons to retain the
direct
connect to the DB despite Epicor's protests to the contrary. First is
the
fact that they have a vested interest in users utilizing their XML
export
capability for reporting - simply put, it requires a Vantage license to
operate whereas ODBC does not. Second is the performance issue with
large
multi-company DB's. We've actually witnessed a canned Vantage Stock
Status
report generate over a 500MB XML file, take over 30 hours to complete,
and
bring a quad dual-core server to its knees. An identical rewrite with an
ODBC connection on the same server completed in under a minute.
Additionally, non-trivial queries involving multi-table joins or complex
filtering or sub-selects have been demonstrated to return inconsistent
and/or inaccurate results.

Besides, it speaks volumes that while Epicor staff continues to tell
scary
stories about the death of ODBC in the current version, their install
guide
devotes an entire section to installing the ODBC drivers and configuring
a
connection.

Regards,

Michael

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

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited.
If you have received this email in error, please immediately notify me
by
telephone and permanently delete the original and any copy of any email
and
any printout thereof.


From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Todd Caughey
Sent: Thursday, February 28, 2008 10:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Report Writing in Version 8

Jasper,
My take, based on Perspectives presentations, is that whatever BAQs and
dashboards don't handle for reporting the creation of XML files (like
6.x
DBF files) by your own BAQ routines will feed Crystal. No limitations to
provided fields either on the canned Crystal reports as you can add
anything
from the tables involved and, I think, from other tables as well. There
is
still ODBC for more or less direct to the DB but several Epicor people
have
told be ODBC is basically dead for 8.x.

In short reporting will be (is) far more flexible in 8.x. It will still
be a
PITA for us to convert 500 or so RB reports BUT most of these are simple
query or lookup reports that will not require Crystal. Then again som
are
very very complicated even for RB so the Crystal conversion will be a
challenge. In some cases I may use other reporting tools against export
XML
files and am pondering some SharePoint Services potential for online
reporting. But first things first...getting 8.x running with our data.
The
rest will ahve to wait.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jasper Recto
Sent: Thursday, February 28, 2008 12:04 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Writing in Version 8

In version 6, Vantage uses both Crystal reports and report builder for
its
reporting.

Report builder would connect directly to the database tables to get its
information. The crystal reports would have to get its information from
tables that are created and stored on the working directory on the users
c:\
drive.

In version 8, how does it work now without report builder?

Does their built in crystal forms and reports still use tables generated
by
the application or does it connect directly to the database tables?

The reason I ask is because in version 6, the tables that are generation
don't always include ALL fields in the table it uses. If you need some
information that was not brought over to the temp table, you out of
luck.

I noticed in the last thread titled 'Crystal Invoices', the user used
ODBC
in their form to add more data. Can you do this for all their forms?

Thanks,
Jasper

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

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

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






[Non-text portions of this message have been removed]
This is certainly good to know. Thanks.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Michael Barry
Sent: Thursday, February 28, 2008 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Writing in Version 8


Gentlemen,

Let's not be too quick to buy the corporate line and celebrate the demise of
ODBC just yet. There remain several compelling reasons to retain the direct
connect to the DB despite Epicor's protests to the contrary. First is the
fact that they have a vested interest in users utilizing their XML export
capability for reporting - simply put, it requires a Vantage license to
operate whereas ODBC does not. Second is the performance issue with large
multi-company DB's. We've actually witnessed a canned Vantage Stock Status
report generate over a 500MB XML file, take over 30 hours to complete, and
bring a quad dual-core server to its knees. An identical rewrite with an
ODBC connection on the same server completed in under a minute.
Additionally, non-trivial queries involving multi-table joins or complex
filtering or sub-selects have been demonstrated to return inconsistent
and/or inaccurate results.

Besides, it speaks volumes that while Epicor staff continues to tell scary
stories about the death of ODBC in the current version, their install guide
devotes an entire section to installing the ODBC drivers and configuring a
connection.

Regards,

Michael

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

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please immediately notify me by
telephone and permanently delete the original and any copy of any email and
any printout thereof.


From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Todd Caughey
Sent: Thursday, February 28, 2008 10:53 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Report Writing in Version 8

Jasper,
My take, based on Perspectives presentations, is that whatever BAQs and
dashboards don't handle for reporting the creation of XML files (like 6.x
DBF files) by your own BAQ routines will feed Crystal. No limitations to
provided fields either on the canned Crystal reports as you can add anything
from the tables involved and, I think, from other tables as well. There is
still ODBC for more or less direct to the DB but several Epicor people have
told be ODBC is basically dead for 8.x.

In short reporting will be (is) far more flexible in 8.x. It will still be a
PITA for us to convert 500 or so RB reports BUT most of these are simple
query or lookup reports that will not require Crystal. Then again som are
very very complicated even for RB so the Crystal conversion will be a
challenge. In some cases I may use other reporting tools against export XML
files and am pondering some SharePoint Services potential for online
reporting. But first things first...getting 8.x running with our data. The
rest will ahve to wait.

-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jasper Recto
Sent: Thursday, February 28, 2008 12:04 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Writing in Version 8

In version 6, Vantage uses both Crystal reports and report builder for its
reporting.

Report builder would connect directly to the database tables to get its
information. The crystal reports would have to get its information from
tables that are created and stored on the working directory on the users c:\
drive.

In version 8, how does it work now without report builder?

Does their built in crystal forms and reports still use tables generated by
the application or does it connect directly to the database tables?

The reason I ask is because in version 6, the tables that are generation
don't always include ALL fields in the table it uses. If you need some
information that was not brought over to the temp table, you out of luck.

I noticed in the last thread titled 'Crystal Invoices', the user used ODBC
in their form to add more data. Can you do this for all their forms?

Thanks,
Jasper

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

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

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





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



How do you deliver and schedule your reports and email to outside
personnel such as sales people?



Don Kollmann

ACH Foam Technologies



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kersten MacLennan
Sent: Thursday, February 28, 2008 2:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Writing in Version 8



I do all of my custom reports with ODBC and I'm on 8.03.305. The BAQs
don't allow for the complexity that I need in most reports.


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@... <mailto:kmaclennan%40semrock.com>

The Standard in Optical Filters for Biotech & Analytical Instrumentation

Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Michael Barry
Sent: Thursday, February 28, 2008 2:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Report Writing in Version 8

Gentlemen,

Let's not be too quick to buy the corporate line and celebrate the
demise of
ODBC just yet. There remain several compelling reasons to retain the
direct
connect to the DB despite Epicor's protests to the contrary. First is
the
fact that they have a vested interest in users utilizing their XML
export
capability for reporting - simply put, it requires a Vantage license to
operate whereas ODBC does not. Second is the performance issue with
large
multi-company DB's. We've actually witnessed a canned Vantage Stock
Status
report generate over a 500MB XML file, take over 30 hours to complete,
and
bring a quad dual-core server to its knees. An identical rewrite with an
ODBC connection on the same server completed in under a minute.
Additionally, non-trivial queries involving multi-table joins or complex
filtering or sub-selects have been demonstrated to return inconsistent
and/or inaccurate results.

Besides, it speaks volumes that while Epicor staff continues to tell
scary
stories about the death of ODBC in the current version, their install
guide
devotes an entire section to installing the ODBC drivers and configuring
a
connection.

Regards,

Michael

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

This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any dissemination, distribution or
copying of this email, and any attachments thereto, is strictly
prohibited.
If you have received this email in error, please immediately notify me
by
telephone and permanently delete the original and any copy of any email
and
any printout thereof.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Todd Caughey
Sent: Thursday, February 28, 2008 10:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Report Writing in Version 8

Jasper,
My take, based on Perspectives presentations, is that whatever BAQs and
dashboards don't handle for reporting the creation of XML files (like
6.x
DBF files) by your own BAQ routines will feed Crystal. No limitations to
provided fields either on the canned Crystal reports as you can add
anything
from the tables involved and, I think, from other tables as well. There
is
still ODBC for more or less direct to the DB but several Epicor people
have
told be ODBC is basically dead for 8.x.

In short reporting will be (is) far more flexible in 8.x. It will still
be a
PITA for us to convert 500 or so RB reports BUT most of these are simple
query or lookup reports that will not require Crystal. Then again som
are
very very complicated even for RB so the Crystal conversion will be a
challenge. In some cases I may use other reporting tools against export
XML
files and am pondering some SharePoint Services potential for online
reporting. But first things first...getting 8.x running with our data.
The
rest will ahve to wait.

-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jasper Recto
Sent: Thursday, February 28, 2008 12:04 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Writing in Version 8

In version 6, Vantage uses both Crystal reports and report builder for
its
reporting.

Report builder would connect directly to the database tables to get its
information. The crystal reports would have to get its information from
tables that are created and stored on the working directory on the users
c:\
drive.

In version 8, how does it work now without report builder?

Does their built in crystal forms and reports still use tables generated
by
the application or does it connect directly to the database tables?

The reason I ask is because in version 6, the tables that are generation
don't always include ALL fields in the table it uses. If you need some
information that was not brought over to the temp table, you out of
luck.

I noticed in the last thread titled 'Crystal Invoices', the user used
ODBC
in their form to add more data. Can you do this for all their forms?

Thanks,
Jasper

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

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

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

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





[Non-text portions of this message have been removed]
I use Crystal Reports with an ODBC connection.

The ODBC connection uses a file DSN with the username/password built-
in, so they run without prompting the user for anything. Not as
secure as it should be, I know, but most users don't know what/where
a file DSN is anyway.

I use a free program Logicity (http://www.logicitysuite.com/Free-
Crystal-Reports-Viewer-Logicity.html) which allows reports to be
exported to PDF/Excel/RPT and emailed. The program creates an ".rrd"
file which runs through the normal Windows Task Scheduler.

Works great for me. Sales & stock reports are emailed each day and
other cumulative reports are emailed at the end of each month.

Nigel.


--- In vantage@yahoogroups.com, "Don Kollmann" <dkollmann@...> wrote:
>
> Hi
>
>
>
> How do you deliver and schedule your reports and email to outside
> personnel such as sales people?
>
>
>
> Don Kollmann
>
> ACH Foam Technologies
>
>
>
> ________________________________
>
>