Copy of Time Phase Report Not Bringing Data Thru - Where to look

Yahoo Archive
1
Pat -

Verify the Epicor joins on the JobHead table in the report data definition.
If you can't find the missing data, check to see that the related data is being managed by the system.


Thank you in advance,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@...<mailto:calvin@...>
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@...214290]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Monday, June 24, 2013 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Copy of Time Phase Report Not Bringing Data Thru - Where to look next?



Not sure where to check next?

Copied the Report Data Definition TimePhase to TimePhase2.
Added Job Number to the Tphse table to not be excluded.
Added New Table JobHead
Added Relationships for Company and JobNumber - Type Output (Outer Join)
Add JobHead.JobCode field to not be excluded. (This is the data want on
the report.)
Updated Report Style and Crystal, fix crystal links to JobHead with
Outer Joins Company and Job.

The JobHead table appears in crystal but no data is coming thru?
Again not sure where to check next?

Patrick Winter

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



[Non-text portions of this message have been removed]
2
Not sure where to check next?

Copied the Report Data Definition TimePhase to TimePhase2.
Added Job Number to the Tphse table to not be excluded.
Added New Table JobHead
Added Relationships for Company and JobNumber - Type Output (Outer Join)
Add JobHead.JobCode field to not be excluded. (This is the data want on
the report.)
Updated Report Style and Crystal, fix crystal links to JobHead with
Outer Joins Company and Job.

The JobHead table appears in crystal but no data is coming thru?
Again not sure where to check next?

Patrick Winter




[Non-text portions of this message have been removed]
3
Unless something has changed recenlty...

You cannot add/join to views like Tphse in an RDD.
They are not "exposed" to customizations.
The interface allows you to add tables and joins but... they won't work.

Only when an RDD uses "real" tables can you add working tables and joins.

--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> Not sure where to check next?
>
> Copied the Report Data Definition TimePhase to TimePhase2.
> Added Job Number to the Tphse table to not be excluded.
> Added New Table JobHead
> Added Relationships for Company and JobNumber - Type Output (Outer Join)
> Add JobHead.JobCode field to not be excluded. (This is the data want on
> the report.)
> Updated Report Style and Crystal, fix crystal links to JobHead with
> Outer Joins Company and Job.
>
> The JobHead table appears in crystal but no data is coming thru?
> Again not sure where to check next?
>
> Patrick Winter
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Well that's pretty much what I'm seeing.



Thx



Patrick



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of b_ordway
Sent: Monday, June 24, 2013 14:47
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Copy of Time Phase Report Not Bringing Data Thru
- Where to look next?





Unless something has changed recenlty...

You cannot add/join to views like Tphse in an RDD.
They are not "exposed" to customizations.
The interface allows you to add tables and joins but... they won't work.

Only when an RDD uses "real" tables can you add working tables and
joins.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Winter, Patrick" <pjw@...> wrote:
>
> Not sure where to check next?
>
> Copied the Report Data Definition TimePhase to TimePhase2.
> Added Job Number to the Tphse table to not be excluded.
> Added New Table JobHead
> Added Relationships for Company and JobNumber - Type Output (Outer
Join)
> Add JobHead.JobCode field to not be excluded. (This is the data want
on
> the report.)
> Updated Report Style and Crystal, fix crystal links to JobHead with
> Outer Joins Company and Job.
>
> The JobHead table appears in crystal but no data is coming thru?
> Again not sure where to check next?
>
> Patrick Winter
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
5
I'm going from memory, but doesn't PartDetail list all supply/demand info needed for a netting report? I may have the table name wrong... It's been 5 years since I used it for anything developed after going live on Vantage 8 & most of those early efforts at tools were replaced by browser based (highly optmized to avoid system performance hits) SQL/odbc queries (written by people far more skilled at this stuff than I.)
Â
PO new & change suggestions are also in tables that can be joined in as can unfirmed jobs (jobhead) & I believe (but couldn't swear to) job change suggestions. Starting o/h is best derived by summing all the bin o/h's for a part (don't use whse o/h on v8 - It regularly becomes randomly inaccurate).


>________________________________
>From: "Winter, Patrick" <pjw@...>
>To: vantage@yahoogroups.com
>Sent: Monday, June 24, 2013 4:24 PM
>Subject: RE: [Vantage] Re: Copy of Time Phase Report Not Bringing Data Thru - Where to look next?
>
>Â
>Well that's pretty much what I'm seeing.
>
>Thx
>
>Patrick
>
>From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
>Of b_ordway
>Sent: Monday, June 24, 2013 14:47
>To: mailto:vantage%40yahoogroups.com
>Subject: [Vantage] Re: Copy of Time Phase Report Not Bringing Data Thru
>- Where to look next?
>
>Unless something has changed recenlty...
>
>You cannot add/join to views like Tphse in an RDD.
>They are not "exposed" to customizations.
>The interface allows you to add tables and joins but... they won't work.
>
>Only when an RDD uses "real" tables can you add working tables and
>joins.
>
>--- In mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
>"Winter, Patrick" <pjw@...> wrote:
>>
>> Not sure where to check next?
>>
>> Copied the Report Data Definition TimePhase to TimePhase2.
>> Added Job Number to the Tphse table to not be excluded.
>> Added New Table JobHead
>> Added Relationships for Company and JobNumber - Type Output (Outer
>Join)
>> Add JobHead.JobCode field to not be excluded. (This is the data want
>on
>> the report.)
>> Updated Report Style and Crystal, fix crystal links to JobHead with
>> Outer Joins Company and Job.
>>
>> The JobHead table appears in crystal but no data is coming thru?
>> Again not sure where to check next?
>>
>> Patrick Winter
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>[Non-text portions of this message have been removed]
>
>
>

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