Vantage 5.0 ODBC

Yahoo Archive
1
I had heard it was the last bracket that gave you the best clue of where to start looking...

Troy Funte
Liberty Electronics

----- Original Message -----
From: Jill Seath
To: 'vantage@egroups.com'
Sent: Thursday, January 04, 2001 6:37 AM
Subject: RE: [Vantage] Vantage 5.0 ODBC


I haven't seen these error but I do remember hearing that the
information in the first brackets indicates where the problem
originates. So in your case Merant.
Hope this helps in some way.
Sophie

> -----Original Message-----
> From: Admin1 [SMTP:rnewell@...]
> Sent: 04 January 2001 13:33
> To: vantage@egroups.com
> Subject: RE: [Vantage] Vantage 5.0 ODBC
>
> Hi Ted,
>
> ODBC error:[MERANT][ODBC PROGRESS driver][PROGRESS]-20217
>
> This is the latest error I am getting.
>
> -----Original Message-----
> From: Ted Kitch [mailto:ted@...]
> Sent: Wednesday, January 03, 2001 4:15 PM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Vantage 5.0 ODBC
>
>
> It always helps that when you post a question you include the error
> message
> that you receive.
>
> Ted Kitch
> ted@...
> ----- Original Message -----
> From: Admin1
> To: vantage@egroups.com
> Sent: Wednesday, January 03, 2001 1:55 PM
> Subject: [Vantage] Vantage 5.0 ODBC
>
>
>
>
> eGroups Sponsor
> Create your family tree at MyFamily.com!
> <http://rd.yahoo.com/M=114382.818028.2619452.2/D=egroupmail/S=17000071
> 83:N/A=401181/*http://ad.doubleclick.net/jump/N1146.yahoo/B22751;sz=46
> 8x60;ord=978615423?>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
> <http://www.egroups.com/files/vantage/>
> (Note: If this link does not work for you the first time you try it,
> go to www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>





eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
2
I am trying to write a report in Report Builder that shows how many
times we sold a particular part to customers. I am having a lot of
trouble with my joins (duplicate/repeating data). If anyone has built a
similar report could you give me a clue as to what tables you used and
how they were joined. I would really appreciate it!

Thanks in advance,

Juliet
3
Juliet -

Focus in on the Invoice Detail table, add the
Invoice Head and Customer. Set your grouping
by customer, then part.

HTH,
Calvin

ps: If you want orders open as well as billed,
use the Order Dtl and Order Head and not the
Invoice tables.



----- Original Message -----
From: Juliet Martin <jmartin@...>
To: <vantage@egroups.com>
Sent: Wednesday, January 03, 2001 7:02 AM
Subject: [Vantage] Report Builder - Sales


> I am trying to write a report in Report Builder that shows how many
> times we sold a particular part to customers. I am having a lot of
> trouble with my joins (duplicate/repeating data). If anyone has built a
> similar report could you give me a clue as to what tables you used and
> how they were joined. I would really appreciate it!
>
> Thanks in advance,
>
> Juliet
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
4
Juliet:

Does the Sales Analysis Report (found under Accounts Receivable Reports) not
give you adequate info. This is one of those reports that I tend to forget
about, but you can select it by part, customer, pick a date range, all kinds
of "stuff". Sorry I can't be of more help.

Lydia


I am trying to write a report in Report Builder that shows how many
times we sold a particular part to customers. I am having a lot of
trouble with my joins (duplicate/repeating data). If anyone has built a
similar report could you give me a clue as to what tables you used and
how they were joined. I would really appreciate it!

Thanks in advance,

Juliet
5
Hi,

Has anyone been able to connect and run reports using ODBC and the new
Vantage 5.0?

I keep getting left outer join errors on reports that ran like a charm on
Vantage 4.0

Any help would be appreciated.

Thanks,


Ron Newell
Neon Products
6
It always helps that when you post a question you include the error message that you receive.

Ted Kitch
ted@...
----- Original Message -----
From: Admin1
To: vantage@egroups.com
Sent: Wednesday, January 03, 2001 1:55 PM
Subject: [Vantage] Vantage 5.0 ODBC


Hi,

Has anyone been able to connect and run reports using ODBC and the new
Vantage 5.0?

I keep getting left outer join errors on reports that ran like a charm on
Vantage 4.0

Any help would be appreciated.

Thanks,


Ron Newell
Neon Products


eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



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

ODBC error:[MERANT][ODBC PROGRESS driver][PROGRESS]-20217

This is the latest error I am getting.

-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Wednesday, January 03, 2001 4:15 PM
To: vantage@egroups.com
Subject: Re: [Vantage] Vantage 5.0 ODBC


It always helps that when you post a question you include the error message
that you receive.

Ted Kitch
ted@...
----- Original Message -----
From: Admin1
To: vantage@egroups.com
Sent: Wednesday, January 03, 2001 1:55 PM
Subject: [Vantage] Vantage 5.0 ODBC
8
I haven't seen these error but I do remember hearing that the
information in the first brackets indicates where the problem
originates. So in your case Merant.
Hope this helps in some way.
Sophie

> -----Original Message-----
> From: Admin1 [SMTP:rnewell@...]
> Sent: 04 January 2001 13:33
> To: vantage@egroups.com
> Subject: RE: [Vantage] Vantage 5.0 ODBC
>
> Hi Ted,
>
> ODBC error:[MERANT][ODBC PROGRESS driver][PROGRESS]-20217
>
> This is the latest error I am getting.
>
> -----Original Message-----
> From: Ted Kitch [mailto:ted@...]
> Sent: Wednesday, January 03, 2001 4:15 PM
> To: vantage@egroups.com
> Subject: Re: [Vantage] Vantage 5.0 ODBC
>
>
> It always helps that when you post a question you include the error
> message
> that you receive.
>
> Ted Kitch
> ted@...
> Â ----- Original Message -----
> Â From: Admin1
> Â To: vantage@egroups.com
> Â Sent: Wednesday, January 03, 2001 1:55 PM
> Â Subject: [Vantage] Vantage 5.0 ODBC
>
>
>
>
> eGroups Sponsor
> Create your family tree at MyFamily.com!
> <http://rd.yahoo.com/M=114382.818028.2619452.2/D=egroupmail/S=17000071
> 83:N/A=401181/*http://ad.doubleclick.net/jump/N1146.yahoo/B22751;sz=46
> 8x60;ord=978615423?>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:Â
> <http://www.egroups.com/files/vantage/>
> (Note:Â If this link does not work for you the first time you try it,
> go to www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>