Priority Dispatch report

Yahoo Archive
1
Run it and see. If I recall correctly it sorts by Resource Group by default.

--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> By default, what does this report sort by? We have a production manager that seems to think this report will solve a lot of our problems, he's given up on the "Scheduled Shipments" report, and would prefer starting to use this report.
>
> Thanks,
>
> --sf
>
2
Has anyone out there ever modified the Priority Dispatch Report? If
so, I have some questions for you.

Thanks

Carol
3
Carol, i have modified this report, what is your question?

Bill

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of carolpelowski
Sent: Monday, October 06, 2008 3:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch report


Has anyone out there ever modified the Priority Dispatch Report? If
so, I have some questions for you.

Thanks

Carol



________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


[Non-text portions of this message have been removed]
4
I need to add the Customer Part Number to the Priority Dispatch
Report in 8.03.404.

In order to get the CustXPrt.XPartNum, I believe that I need to
establish a relationship between the JCR65 table and the CustXPrt
table in the report data definition.

However, not only does JCR65 seem to not be a "real" table (it is not
listed in the Data Dictionary), but no fields are available from
JCR65 for linking in Add Relationship Fields.

I also wanted to add a couple of user-defined fields from ECOOpr, but
same situation exists. The JCR65 table seems to be the master
controlling table for this report since it always contains the
Manufactured Part Number.

What can I do?

Has anyone ever added tables to this report?

Lynn K.


--- In vantage@yahoogroups.com, Bill King <bking@...> wrote:
>
> Carol, i have modified this report, what is your question?
>
> Bill
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of carolpelowski
> Sent: Monday, October 06, 2008 3:32 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Priority Dispatch report
>
>
> Has anyone out there ever modified the Priority Dispatch Report? If
> so, I have some questions for you.
>
> Thanks
>
> Carol
>
>
>
> ________________________________
> The information contained in this message is intended solely for
the individual to whom it is specifically and originally addressed.
This message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
> We have taken precautions to minimize the risk of transmitting
software viruses, but we advise you to carry out your own virus
checks on any attachment to this message. We cannot accept liability
for any loss or damage caused by software viruses.
>
> This message (including any attachments) is intended only for
> the use of the individual or entity to which it is addressed and
> may contain information that is non-public, proprietary,
> privileged, confidential, and exempt from disclosure under
> applicable law or may constitute as attorney work product.
> If you are not the intended recipient, you are hereby notified
> that any use, dissemination, distribution, or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, notify us immediately by telephone and
> (i) destroy this message if a facsimile or (ii) delete this message
> immediately if this is an electronic communication.
>
> Thank you.
>
>
> [Non-text portions of this message have been removed]
>
5
We had a lot of trouble modifying this report. We came up with our own
BAQ that shows what needs to be worked on per area.

As I recall the only way to add related tables to this report was to add
the table without adding a relationship. This means you¹ll get the WHOLE
related table in the report XML (and you have to define the relationship in
the report), which means that the report display with degrade over time as
the related table gets larger. Not a good solution.

That¹s a problem with a number of the system-provided Crystal reports that
are more complex ‹ they don¹t run off of a BAQ and have fake ³tables² in
their definition that are impossible to use in reference joins as they do
not appear in the data dictionary.

We found that the report wasn¹t that useful anyways and came up with our
own. :-)

-bws

On 12/8/08 10:16 AM, "Lynn" <lynn.khalife@...> wrote:

>
>
>
> I need to add the Customer Part Number to the Priority Dispatch
> Report in 8.03.404.
>
> In order to get the CustXPrt.XPartNum, I believe that I need to
> establish a relationship between the JCR65 table and the CustXPrt
> table in the report data definition.
>
> However, not only does JCR65 seem to not be a "real" table (it is not
> listed in the Data Dictionary), but no fields are available from
> JCR65 for linking in Add Relationship Fields.
>
> I also wanted to add a couple of user-defined fields from ECOOpr, but
> same situation exists. The JCR65 table seems to be the master
> controlling table for this report since it always contains the
> Manufactured Part Number.
>
> What can I do?
>
> Has anyone ever added tables to this report?
>
> Lynn K.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Bill King
> <bking@...> wrote:
>> >
>> > Carol, i have modified this report, what is your question?
>> >
>> > Bill
>> >
>> > ________________________________
>> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of carolpelowski
>> > Sent: Monday, October 06, 2008 3:32 PM
>> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>> > Subject: [Vantage] Priority Dispatch report
>> >
>> >
>> > Has anyone out there ever modified the Priority Dispatch Report? If
>> > so, I have some questions for you.
>> >
>> > Thanks
>> >
>> > Carol
>> >
>> >
>> >
>> > ________________________________
>> > The information contained in this message is intended solely for
> the individual to whom it is specifically and originally addressed.
> This message and its contents may contain confidential or privileged
> information. If you are not the intended recipient, you are hereby
> notified that any disclosure or distribution, or taking any action in
> reliance on the contents of this information, is strictly prohibited.
>> > We have taken precautions to minimize the risk of transmitting
> software viruses, but we advise you to carry out your own virus
> checks on any attachment to this message. We cannot accept liability
> for any loss or damage caused by software viruses.
>> >
>> > This message (including any attachments) is intended only for
>> > the use of the individual or entity to which it is addressed and
>> > may contain information that is non-public, proprietary,
>> > privileged, confidential, and exempt from disclosure under
>> > applicable law or may constitute as attorney work product.
>> > If you are not the intended recipient, you are hereby notified
>> > that any use, dissemination, distribution, or copying of this
>> > communication is strictly prohibited. If you have received this
>> > communication in error, notify us immediately by telephone and
>> > (i) destroy this message if a facsimile or (ii) delete this message
>> > immediately if this is an electronic communication.
>> >
>> > Thank you.
>> >
>> >
>> > [Non-text portions of this message have been removed]
>> >
>
>
>



[Non-text portions of this message have been removed]
6
By default, what does this report sort by? We have a production manager that seems to think this report will solve a lot of our problems, he's given up on the "Scheduled Shipments" report, and would prefer starting to use this report.

Thanks,

--sf