(V8) - Custom Crystal reports and ODBC

system · February 20, 2007, 6:12pm

No, the BAQ creation utility in 8.03 isn't any better than in was in Vantage
8. I'll agree it's horrid. You can now tie a BAQ/Dashboard to a Crystal
Report now. We've setup a few dashboards that pull from multiple BAQs to
get a more complicated type query than a single BAQ could really do.

Even Access has a better query building tool than Vantage 8.xx does.

Thanks,

Randy

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Clunn
Sent: Tuesday, February 13, 2007 4:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (V8) - Custom Crystal reports and ODBC

Is BAQ 8.03 that different from 8.00? In 8.00, BAQ is hardly a
substitute for a real query tool. Without the ability to query a query,
the BAQ is only good for simple reports. I'm still using Access for the
heavy layered data crunching. Add in forms for user input and VBA for
evaluation and control, and you have a whole world of possibility.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of RSN
Sent: Friday, January 26, 2007 3:51 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] (V8) - Custom Crystal reports and ODBC

Joe- since you are on 8.03 and all vantage tables are open via the BAQ
thereby circumventing the need for ODBC, could you not deploy the same
report this via a dashboard report to your users.
RSN

Gary Parfrey <garyp@dotnetit. <mailto:garyp%40dotnetit.co.uk> co.uk
<mailto:garyp%40dotnetit.co.uk> >
wrote:
Joe

Use a connection string in the report rather than a DSN, this then means
you only have to distribute the progress odbc driver and do not have to
setup dsn's on your machines for crystal reports

Gary

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: 25 January 2007 16:03
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@tnco- <mailto:jrojas%40tnco-inc.com> inc.com
<mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

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

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

---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

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

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient
only and may contain confidential and privileged information. No one else
may read, print, store, copy, forward or act in reliance on it or its
attachments. If you are not the intended recipient, please return this
message to the sender and delete the message and any attachments from your
computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f- <http://www.f-secure.com/>
secure.com/

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

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

system · January 25, 2007, 11:18am

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...

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

system · January 25, 2007, 12:03pm

Joe,

Each client will need to have the ODBC drivers and a DSN that matches the
configuration of your development system in order to run the report.

Regards,

Michael

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

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Thursday, January 25, 2007 8:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

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

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

system · January 26, 2007, 2:27pm

Joe

Use a connection string in the report rather than a DSN, this then means
you only have to distribute the progress odbc driver and do not have to
setup dsn's on your machines for crystal reports

Gary

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: 25 January 2007 16:03
To: vantage@yahoogroups.com
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

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

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

system · January 26, 2007, 6:06pm

I use a connection string for all my Crystal reports, but I still need
to have a configured DSN on my system as the DSN is the first
declaration within the string.

I haven't been able to get it to work without it.

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Thursday, January 25, 2007 2:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (V8) - Custom Crystal reports and ODBC

Joe

Use a connection string in the report rather than a DSN, this then means
you only have to distribute the progress odbc driver and do not have to
setup dsn's on your machines for crystal reports

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: 25 January 2007 16:03
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

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

system · January 27, 2007, 12:12am

Joe- since you are on 8.03 and all vantage tables are open via the BAQ thereby circumventing the need for ODBC, could you not deploy the same report this via a dashboard report to your users.
RSN

Gary Parfrey <garyp@...> wrote:
Joe

Use a connection string in the report rather than a DSN, this then means
you only have to distribute the progress odbc driver and do not have to
setup dsn's on your machines for crystal reports

Gary

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: 25 January 2007 16:03
To: vantage@yahoogroups.com
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>

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

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

---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

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

system · January 27, 2007, 1:30am

Is there a technical document that shows how to do this? We
currently have our machines set up using ODBC.

--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Joe
>
>
>
> Use a connection string in the report rather than a DSN, this then
means
> you only have to distribute the progress odbc driver and do not
have to
> setup dsn's on your machines for crystal reports
>
>
>
> Gary
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Joe Rojas
> Sent: 25 January 2007 16:03
> To: vantage@yahoogroups.com
> Subject: [Vantage] (V8) - Custom Crystal reports and ODBC
>
>
>
> Hello,
>
> I created a custom Method Master Crystal report that uses ODBC.
>
> Does each client computer that will use this report need to have
the
> ODBC drivers and DNS setup?
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@... <mailto:jrojas%40tnco-inc.com>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 29, 2007, 8:33am

Hi Gary,

I tried this out but ran into two issues.

One was that I was trying to create a Crystal version of the Method
Master and as such I needed to join a many to one join to another many
to one relationship. This was not really a show stopper but more of an
inconvience.

Second, I could not find a way to filter on Part Rev. This was a show
stopper and forced me to resort to ODBC.

If you know of a way around the second issue, I would more than be glad
to use a BAQ!

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RSN
Sent: Friday, January 26, 2007 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (V8) - Custom Crystal reports and ODBC

Joe- since you are on 8.03 and all vantage tables are open via the BAQ
thereby circumventing the need for ODBC, could you not deploy the same
report this via a dashboard report to your users.
RSN

Gary Parfrey <garyp@... <mailto:garyp%40dotnetit.co.uk> >
wrote:
Joe

Use a connection string in the report rather than a DSN, this then means
you only have to distribute the progress odbc driver and do not have to
setup dsn's on your machines for crystal reports

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: 25 January 2007 16:03
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

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

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

---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

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

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

system · January 29, 2007, 11:00am

I have gotten connection strings to work, and want to go that way.
However part of the purpose of the string is to name the port. So
my conclusion was that I need to maintain two complete sets of
reports, one for the production database and one for the pilot
database. Otherwise, it seems that every time you print a report
from pilot, the report would grab data from production. Is that
correct?

-Peter Volkert

Symetrics Industries

--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Joe
>
>
>
> Use a connection string in the report rather than a DSN, this then
means
> you only have to distribute the progress odbc driver and do not
have to
> setup dsn's on your machines for crystal reports
>
>
>
> Gary
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Joe Rojas
> Sent: 25 January 2007 16:03
> To: vantage@yahoogroups.com
> Subject: [Vantage] (V8) - Custom Crystal reports and ODBC
>
>
>
> Hello,
>
> I created a custom Method Master Crystal report that uses ODBC.
>
> Does each client computer that will use this report need to have
the
> ODBC drivers and DNS setup?
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@... <mailto:jrojas%40tnco-inc.com>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 29, 2007, 11:18am

That's correct, you will need two separate reports and if you export
your live into pilot you will need to update the report path in menu
maintenance.

I use an Access update query to update the path locations because I have
about 90 reports.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pvolkert365
Sent: Monday, January 29, 2007 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: (V8) - Custom Crystal reports and ODBC

I have gotten connection strings to work, and want to go that way.
However part of the purpose of the string is to name the port. So
my conclusion was that I need to maintain two complete sets of
reports, one for the production database and one for the pilot
database. Otherwise, it seems that every time you print a report
from pilot, the report would grab data from production. Is that
correct?

-Peter Volkert

Symetrics Industries

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Gary Parfrey" <garyp@...> wrote:

>
> Joe
>
>
>
> Use a connection string in the report rather than a DSN, this then

means

> you only have to distribute the progress odbc driver and do not

have to

> setup dsn's on your machines for crystal reports
>
>
>
> Gary
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of Joe Rojas
> Sent: 25 January 2007 16:03
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] (V8) - Custom Crystal reports and ODBC
>
>
>
> Hello,
>
> I created a custom Method Master Crystal report that uses ODBC.
>
> Does each client computer that will use this report need to have

the

> ODBC drivers and DNS setup?
>
> Thanks,
>
> Joe Rojas
>
> IT Manager
>
> TNCO, Inc.
>
> 781-447-6661 x7506
>
> jrojas@... <mailto:jrojas%40tnco-inc.com>
>
> [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]

system · February 13, 2007, 6:55pm

Is BAQ 8.03 that different from 8.00? In 8.00, BAQ is hardly a
substitute for a real query tool. Without the ability to query a query,
the BAQ is only good for simple reports. I'm still using Access for the
heavy layered data crunching. Add in forms for user input and VBA for
evaluation and control, and you have a whole world of possibility.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RSN
Sent: Friday, January 26, 2007 3:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (V8) - Custom Crystal reports and ODBC

Joe- since you are on 8.03 and all vantage tables are open via the BAQ
thereby circumventing the need for ODBC, could you not deploy the same
report this via a dashboard report to your users.
RSN

Gary Parfrey <garyp@... <mailto:garyp%40dotnetit.co.uk> >
wrote:
Joe

Use a connection string in the report rather than a DSN, this then means
you only have to distribute the progress odbc driver and do not have to
setup dsn's on your machines for crystal reports

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: 25 January 2007 16:03
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] (V8) - Custom Crystal reports and ODBC

Hello,

I created a custom Method Master Crystal report that uses ODBC.

Does each client computer that will use this report need to have the
ODBC drivers and DNS setup?

Thanks,

Joe Rojas

IT Manager

TNCO, Inc.

781-447-6661 x7506

jrojas@... <mailto:jrojas%40tnco-inc.com>
<mailto:jrojas%40tnco-inc.com>

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

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

---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

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

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

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