How to access current company name from vantage for reporting

Yahoo Archive
1
In reply to my own question, YES it works, I've wanted to be able to do
this for a long time. Now to see the performance on some very complex
reports.

Shirley

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, November 19, 2003 12:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to access current company name from vantage
for reporting

Todd,
Looking at this linkage, could this also be used to print
the user name of the person printing the report?

Shirley

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 19, 2003 12:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to access current company name from vantage
for reporting

There is a way to get the current company of the logged in user in
Report Builder and I suspect the same could be used for Crystal with
ODBC.

The tables and links are:
Table Links
_MyConnection Link to Connect table using PID field
Connect Link to UserFile using _Connect-Name to
DCDUserID
UserFile Link to desired master data table for report
using CurComp to Company field

This string of links becomes the top of your set of tables and causes
only data for the user's current Vantage company to be selected. I
think this same thing might work for Crystal if run from within Vantage.
I'm not experienced enough with Crystal & ODBC to know how well it would
know the current user's Progress PID. But this might be an avenue to
check out. You might also be able to skip the _My-Conneciton and
Connect tables and do something within crystal to associate a windows
login name to the name in the UserFile table.

-Todd C.


-----Original Message-----
From: jcheuk [mailto:jcheuk@...]
Sent: Wednesday, November 19, 2003 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to access current company name from vantage for
reporting




Dear All,

Our client wants to create some reports other than vantage standard
reports.

So, we create those reports by using crystal report designer.

However, we encounter a technical problem. That is how to get current
company name in vantage, and let the report know for which company it
should
retrieved data since vantage support multi companies.

We find that we can type and run a commond in command window of
vantage to
get the current company such as: msgbox {_COMPANYNAME}. However, it is
not
possible to ask our end user to type VBasic command in command window.

Are there any better ways to solve the problem?

John Cheuk




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/.
<http://groups.yahoo.com/group/vantage/files/>
<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]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/*http://www.netflix
.com/Default?mqso=60178338
<http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116730> &partid=4116730> click here


<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=282507975>

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/.
<http://groups.yahoo.com/group/vantage/files/>
<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]





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12chm016o/M=267637.4116732.5333197.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069349810/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116732> click here


<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=223011137>

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/.
<http://groups.yahoo.com/group/vantage/files/>
<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!
<http://docs.yahoo.com/info/terms/> Terms of Service.

Tracking #: 8E6B4AFE1B092D40A4EFA7EE995E70EBABF15DCF


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





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c6uis2o/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069350305/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116730> click here


<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=613966915>

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/.
<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!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
2
Dear All,

Our client wants to create some reports other than vantage standard reports.

So, we create those reports by using crystal report designer.

However, we encounter a technical problem. That is how to get current
company name in vantage, and let the report know for which company it should
retrieved data since vantage support multi companies.

We find that we can type and run a commond in command window of vantage to
get the current company such as: msgbox {_COMPANYNAME}. However, it is not
possible to ask our end user to type VBasic command in command window.

Are there any better ways to solve the problem?

John Cheuk
3
I may be missing something but couldn't you just add a parameter field to
the report requesting which Company, translate that to the Company ID and
then print the matching information?


Jim Carnes
Information Systems Administrator
jcarnes@...
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230

-----Original Message-----
From: jcheuk [mailto:jcheuk@...]
Sent: Wednesday, November 19, 2003 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to access current company name from vantage for
reporting




Dear All,

Our client wants to create some reports other than vantage standard
reports.

So, we create those reports by using crystal report designer.

However, we encounter a technical problem. That is how to get current
company name in vantage, and let the report know for which company it
should
retrieved data since vantage support multi companies.

We find that we can type and run a commond in command window of vantage to
get the current company such as: msgbox {_COMPANYNAME}. However, it is not
possible to ask our end user to type VBasic command in command window.

Are there any better ways to solve the problem?

John Cheuk




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]
4
There is a way to get the current company of the logged in user in Report Builder and I suspect the same could be used for Crystal with ODBC.

The tables and links are:
Table Links
_MyConnection Link to Connect table using PID field
Connect Link to UserFile using _Connect-Name to DCDUserID
UserFile Link to desired master data table for report using CurComp to Company field

This string of links becomes the top of your set of tables and causes only data for the user's current Vantage company to be selected. I think this same thing might work for Crystal if run from within Vantage. I'm not experienced enough with Crystal & ODBC to know how well it would know the current user's Progress PID. But this might be an avenue to check out. You might also be able to skip the _My-Conneciton and Connect tables and do something within crystal to associate a windows login name to the name in the UserFile table.

-Todd C.


-----Original Message-----
From: jcheuk [mailto:jcheuk@...]
Sent: Wednesday, November 19, 2003 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to access current company name from vantage for
reporting




Dear All,

Our client wants to create some reports other than vantage standard
reports.

So, we create those reports by using crystal report designer.

However, we encounter a technical problem. That is how to get current
company name in vantage, and let the report know for which company it
should
retrieved data since vantage support multi companies.

We find that we can type and run a commond in command window of vantage to
get the current company such as: msgbox {_COMPANYNAME}. However, it is not
possible to ask our end user to type VBasic command in command window.

Are there any better ways to solve the problem?

John Cheuk




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]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/*http://www.netflix.com/Default?mqso=60178338&partid=4116730> click here
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1853618/rand=282507975>

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]
5
Todd,
Looking at this linkage, could this also be used to print
the user name of the person printing the report?

Shirley

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 19, 2003 12:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to access current company name from vantage
for reporting

There is a way to get the current company of the logged in user in
Report Builder and I suspect the same could be used for Crystal with
ODBC.

The tables and links are:
Table Links
_MyConnection Link to Connect table using PID field
Connect Link to UserFile using _Connect-Name to
DCDUserID
UserFile Link to desired master data table for report
using CurComp to Company field

This string of links becomes the top of your set of tables and causes
only data for the user's current Vantage company to be selected. I
think this same thing might work for Crystal if run from within Vantage.
I'm not experienced enough with Crystal & ODBC to know how well it would
know the current user's Progress PID. But this might be an avenue to
check out. You might also be able to skip the _My-Conneciton and
Connect tables and do something within crystal to associate a windows
login name to the name in the UserFile table.

-Todd C.


-----Original Message-----
From: jcheuk [mailto:jcheuk@...]
Sent: Wednesday, November 19, 2003 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to access current company name from vantage for
reporting




Dear All,

Our client wants to create some reports other than vantage standard
reports.

So, we create those reports by using crystal report designer.

However, we encounter a technical problem. That is how to get current
company name in vantage, and let the report know for which company it
should
retrieved data since vantage support multi companies.

We find that we can type and run a commond in command window of
vantage to
get the current company such as: msgbox {_COMPANYNAME}. However, it is
not
possible to ask our end user to type VBasic command in command window.

Are there any better ways to solve the problem?

John Cheuk




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/.
<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]



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/*http://www.netflix
.com/Default?mqso=60178338
<http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116730> &partid=4116730> click here


<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=282507975>

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/.
<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]





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12chm016o/M=267637.4116732.5333197.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069349810/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116732> click here


<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=223011137>

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/.
<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!
<http://docs.yahoo.com/info/terms/> Terms of Service.

Tracking #: 8E6B4AFE1B092D40A4EFA7EE995E70EBABF15DCF


[Non-text portions of this message have been removed]
6
Yup, that's why I first messed around with it - looking for user's name. Then I found I could avoid making users change company in filter or writing company specific versions.

Only trouble is retrofitting it to existing reports because _MyConneciton has to be master table and changing master table is really tedious. Better to have a stub report with this setup and write all reports needing name starting with it and then "save as..." a new name.

-Todd C.

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Wednesday, November 19, 2003 11:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to access current company name from vantage for reporting


Todd,
Looking at this linkage, could this also be used to print
the user name of the person printing the report?

Shirley

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 19, 2003 12:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to access current company name from vantage
for reporting

There is a way to get the current company of the logged in user in
Report Builder and I suspect the same could be used for Crystal with
ODBC.

The tables and links are:
Table Links
_MyConnection Link to Connect table using PID field
Connect Link to UserFile using _Connect-Name to
DCDUserID
UserFile Link to desired master data table for report
using CurComp to Company field

This string of links becomes the top of your set of tables and causes
only data for the user's current Vantage company to be selected. I
think this same thing might work for Crystal if run from within Vantage.
I'm not experienced enough with Crystal & ODBC to know how well it would
know the current user's Progress PID. But this might be an avenue to
check out. You might also be able to skip the _My-Conneciton and
Connect tables and do something within crystal to associate a windows
login name to the name in the UserFile table.

-Todd C.


-----Original Message-----
From: jcheuk [mailto:jcheuk@...]
Sent: Wednesday, November 19, 2003 11:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to access current company name from vantage for
reporting




Dear All,

Our client wants to create some reports other than vantage standard
reports.

So, we create those reports by using crystal report designer.

However, we encounter a technical problem. That is how to get current
company name in vantage, and let the report know for which company it
should
retrieved data since vantage support multi companies.

We find that we can type and run a commond in command window of
vantage to
get the current company such as: msgbox {_COMPANYNAME}. However, it is
not
possible to ask our end user to type VBasic command in command window.

Are there any better ways to solve the problem?

John Cheuk




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/.
< 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]



Yahoo! Groups Sponsor

ADVERTISEMENT
< http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/* http://www.netflix
.com/Default?mqso=60178338
< http://rd.yahoo.com/SIG=12cvc288u/M=267637.4116730.5333196.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069346405/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116730> &partid=4116730> click here


< http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=282507975>

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/.
< 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]





Yahoo! Groups Sponsor


ADVERTISEMENT

< http://rd.yahoo.com/SIG=12chm016o/M=267637.4116732.5333197.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1069349810/A=1853618/R=0/*http:/www.netflix.
com/Default?mqso=60178338&partid=4116732> click here


< http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egrou
pmail/S=:HM/A=1853618/rand=223011137>

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/.
< 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!
< http://docs.yahoo.com/info/terms/> Terms of Service.

Tracking #: 8E6B4AFE1B092D40A4EFA7EE995E70EBABF15DCF


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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12c6uis2o/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705007183:HM/EXP=1069350305/A=1853618/R=0/*http://www.netflix.com/Default?mqso=60178338&partid=4116730> click here
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1853618/rand=613966915>

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]