Printing Username on report

Yahoo Archive
1
And, if you don't find it, you can add the UserFile to the RDD with a new relationship...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Monday, July 29, 2013 9:05 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Printing Username on report



Thanks Vic, found it under SubAsmbl table. I'll make sure to check all the available tables next time and should be able to find the userid field somewhere.

________________________________
From: Vic Drecchio <vic.drecchio@...<mailto:vic.drecchio%40swepcotube.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Monday, July 29, 2013 9:53 AM
Subject: RE: [Vantage] Printing Username on report


Ted, I can't think of one canned report that doesn't pass along the UserID
in one of the fields.

The JobTrav Report Data Def has RPTUSERID (Calc Field) in the SubAsmbl
table, JobOper table and JobShip tables

One of them should work, no?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
tkoch77
Sent: Monday, July 29, 2013 9:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Printing Username on report



Hi all,

Looking for a way to make available the current users ID for printing on a
report, I want to have the current user's user ID print on the job traveler.
The priority dispatch report has the calculated field Calc_UserID in the
Company table. I don't think you can make your own calculated fields unless
you have the SDK. Curious if anyone found a way around this?

Thanks,

-Ted

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

------------------------------------

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/linksYahoo! Groups Links

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



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

Looking for a way to make available the current users ID for printing on a report, I want to have the current user's user ID print on the job traveler. The priority dispatch report has the calculated field Calc_UserID in the Company table. I don't think you can make your own calculated fields unless you have the SDK. Curious if anyone found a way around this?

Thanks,

-Ted
3
You want it in ALL reports? If not then you can customize the Input Screen
and send it as part of report Param table... Which BTW you should check as
it may already have this inf.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jul 29, 2013 at 9:22 AM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> Hi all,
>
> Looking for a way to make available the current users ID for printing on a
> report, I want to have the current user's user ID print on the job
> traveler. The priority dispatch report has the calculated field Calc_UserID
> in the Company table. I don't think you can make your own calculated fields
> unless you have the SDK. Curious if anyone found a way around this?
>
> Thanks,
>
> -Ted
>
>
>


[Non-text portions of this message have been removed]
4
I mainly want it on the Job Traveler for right now, but if I get it working for the traveler I can get it to work on other reports when needed. I am looking at the ReportParam table in the object explorer and there are no ud fields to pass extra parameters, have you just used a field that already exists that you wouldn't normally use in the report.




________________________________
From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Monday, July 29, 2013 9:26 AM
Subject: Re: [Vantage] Printing Username on report


You want it in ALL reports? If not then you can customize the Input Screen
and send it as part of report Param table... Which BTW you should check as
it may already have this inf.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jul 29, 2013 at 9:22 AM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> Hi all,
>
> Looking for a way to make available the current users ID for printing on a
> report, I want to have the current user's user ID print on the job
> traveler. The priority dispatch report has the calculated field Calc_UserID
> in the Company table. I don't think you can make your own calculated fields
> unless you have the SDK. Curious if anyone found a way around this?
>
> Thanks,
>
> -Ted
>
>Â
>


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



------------------------------------

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/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
5
Some Reports have Character01.. etc. if it doesn't you could jsut use a
field you don't need.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jul 29, 2013 at 9:35 AM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I mainly want it on the Job Traveler for right now, but if I get it
> working for the traveler I can get it to work on other reports when needed.
> I am looking at the ReportParam table in the object explorer and there are
> no ud fields to pass extra parameters, have you just used a field that
> already exists that you wouldn't normally use in the report.
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: Vantage <vantage@yahoogroups.com>
> Sent: Monday, July 29, 2013 9:26 AM
> Subject: Re: [Vantage] Printing Username on report
>
>
>
> You want it in ALL reports? If not then you can customize the Input Screen
> and send it as part of report Param table... Which BTW you should check as
> it may already have this inf.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jul 29, 2013 at 9:22 AM, tkoch77 <tkoch77@...> wrote:
>
> > **
>
> >
> >
> > Hi all,
> >
> > Looking for a way to make available the current users ID for printing on
> a
> > report, I want to have the current user's user ID print on the job
> > traveler. The priority dispatch report has the calculated field
> Calc_UserID
> > in the Company table. I don't think you can make your own calculated
> fields
> > unless you have the SDK. Curious if anyone found a way around this?
> >
> > Thanks,
> >
> > -Ted
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> 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/linksYahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
6
Ted, I can't think of one canned report that doesn't pass along the UserID
in one of the fields.



The JobTrav Report Data Def has RPTUSERID (Calc Field) in the SubAsmbl
table, JobOper table and JobShip tables



One of them should work, no?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
tkoch77
Sent: Monday, July 29, 2013 9:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Printing Username on report





Hi all,

Looking for a way to make available the current users ID for printing on a
report, I want to have the current user's user ID print on the job traveler.
The priority dispatch report has the calculated field Calc_UserID in the
Company table. I don't think you can make your own calculated fields unless
you have the SDK. Curious if anyone found a way around this?

Thanks,

-Ted





[Non-text portions of this message have been removed]
7
Thanks Vic, found it under SubAsmbl table. I'll make sure to check all the available tables next time and should be able to find the userid field somewhere.




________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Monday, July 29, 2013 9:53 AM
Subject: RE: [Vantage] Printing Username on report


Ted, I can't think of one canned report that doesn't pass along the UserID
in one of the fields.Â



The JobTrav Report Data Def has RPTUSERID (Calc Field) in the SubAsmbl
table, JobOper table and JobShip tables



One of them should work, no?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
tkoch77
Sent: Monday, July 29, 2013 9:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Printing Username on report



Â

Hi all,

Looking for a way to make available the current users ID for printing on a
report, I want to have the current user's user ID print on the job traveler.
The priority dispatch report has the calculated field Calc_UserID in the
Company table. I don't think you can make your own calculated fields unless
you have the SDK. Curious if anyone found a way around this?

Thanks,

-Ted





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



------------------------------------

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/linksYahoo! Groups Links



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