V8.03 Dashboard and Memos

Yahoo Archive
1
Patrick,



Thank you, this is working perfectly. Was not aware that Key1 held the
job number. I thought I dumped all fields of the table into a Crystal
Report just to see what was going where but I must not have.



Thanks

Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Winter, Patrick
Sent: Wednesday, May 16, 2007 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8.03 Dashboard and Memos



Can you join Company to Company then Key1 field in memo's to
JobHead.Jobnum?

Patrick


________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Hofert
Sent: Wednesday, May 16, 2007 6:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] V8.03 Dashboard and Memos

Does anyone have any insight on how to join the Memo table to JobHead
table for reporting purposes?

Todd Hofert

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 Hofert
Sent: Friday, May 11, 2007 7:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8.03 Dashboard and Memos

I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?

Thanks

Todd

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
2
I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?



Thanks

Todd



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
3
Does anyone have any insight on how to join the Memo table to JobHead
table for reporting purposes?



Todd Hofert



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Friday, May 11, 2007 7:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] V8.03 Dashboard and Memos



I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?

Thanks

Todd

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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





This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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



I would be interested in finding out how to do this too. I tried to
figure it out and ended up using Excel Query to get the data from
Vantage and create the report.



Linda



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

I'm still in 6.1 so I don't know if this will help you or not, but I
have the Memo Table linked to the Job Num in an Access application.
The Job Num in the Memo Table is stored in field Key 1.

HTH,

Brian Stenglein


--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> Does anyone have any insight on how to join the Memo table to
JobHead
> table for reporting purposes?
>
>
>
> Todd Hofert
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Todd Hofert
> Sent: Friday, May 11, 2007 7:20 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] V8.03 Dashboard and Memos
>
>
>
> I am trying to create a job status dashboard that includes a grid
view
> of job head memos. I want the selected job memos to display in a
grid.
> The problem is the Memo table doesn't store the Job Number as the
Job
> Number. It stores a value in the Memo Text as "Job Number(xxxxx).
Can
> anyone assit me in figuring out a way to select the job appropriate
> memos to list in the view?
>
> Thanks
>
> Todd
>
> This e-mail and any attachments may contain confidential and
privileged
> information. If you are not the intended recipient, please notify
the
> sender immediately by return e-mail, delete this e-mail and destroy
any
> copies. Any dissemination or use of this information by a person
other
> than the intended recipient is unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> This e-mail and any attachments may contain confidential and
privileged
> information. If you are not the intended recipient, please notify
the
> sender immediately by return e-mail, delete this e-mail and destroy
any
> copies. Any dissemination or use of this information by a person
other
> than the intended recipient is unauthorized and may be illegal.
>
> [Non-text portions of this message have been removed]
>
6
Can you join Company to Company then Key1 field in memo's to
JobHead.Jobnum?

Patrick


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Wednesday, May 16, 2007 6:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8.03 Dashboard and Memos



Does anyone have any insight on how to join the Memo table to JobHead
table for reporting purposes?

Todd Hofert

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Hofert
Sent: Friday, May 11, 2007 7:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8.03 Dashboard and Memos

I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?

Thanks

Todd

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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






This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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

for each JobHead Where JobHead.Company = cur-comp no-lock,
each Memo Where Memo.Company = JobHead.Company
and Memo.key1 = JobHead.JobNum
and Memo.RelatedToFile = "JobHead" no-lock
BY JobHead.JobNum:




--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Hi Todd,
>
>
>
> I would be interested in finding out how to do this too. I tried
to
> figure it out and ended up using Excel Query to get the data from
> Vantage and create the report.
>
>
>
> Linda
>
>
>
> [Non-text portions of this message have been removed]
>
8
Yes, I had to use a trim statement to make mine work though.

Steve Mulder
Information Systems


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Winter, Patrick
Sent: Wednesday, May 16, 2007 8:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8.03 Dashboard and Memos



Can you join Company to Company then Key1 field in memo's to
JobHead.Jobnum?

Patrick


________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Hofert
Sent: Wednesday, May 16, 2007 6:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] V8.03 Dashboard and Memos

Does anyone have any insight on how to join the Memo table to JobHead
table for reporting purposes?

Todd Hofert

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 Hofert
Sent: Friday, May 11, 2007 7:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] V8.03 Dashboard and Memos

I am trying to create a job status dashboard that includes a grid view
of job head memos. I want the selected job memos to display in a grid.
The problem is the Memo table doesn't store the Job Number as the Job
Number. It stores a value in the Memo Text as "Job Number(xxxxx). Can
anyone assit me in figuring out a way to select the job appropriate
memos to list in the view?

Thanks

Todd

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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






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