Epicor 10 SSRS UD Fields in RDD

system · January 14, 2016, 4:17pm

Thanks for all the suggestions.

I finally got it. It was one detail I had overlooked.

In the RDD relationship from JobAsmbl>Part, the relation type was Definition Only.

I changed it to Output and yup... hello Part table!

On Thursday, January 14, 2016 3:38 PM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1705881093yiv6049063353ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-1705881093yiv6049063353gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Make sure you are in the Report DB when you log in to SQL. If that&#39;s the case then your Report Style / RDD aren&#39;t generating the part table.</div></div><div class="ygrps-yiv-1705881093yiv6049063353gmail_extra"><br clear="all"><div><div class="ygrps-yiv-1705881093yiv6049063353gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 3:22 PM, Larry Jedik larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Yes, I did add the fields I wanted to work with in DataSet>Fields>New Field. (Sorry, that's what I meant when I said they were added to the field list.)</span></div><div>I logged into SQL and ran the command and got an error message:</div><div dir="ltr">Invalid object name 'Part_(GUID string)'.</div><div><div class="ygrps-yiv-1705881093yiv6049063353h5"> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 3:04 PM, "Jose Gomez <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

<div> <div></div><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">I dont mean add the fields to SSRS in the query did you add the fields to SSRS as in DataSet 0> Fields -> New Field?</div><div style="font-family:verdana, sans-serif;font-size:small;">Select Select * From Part_GUID I mean if you log in to SQL and Run that command SELECT * FROM Part_GUID (where GUID is the guid if the report you just ran) do you get results?</div></div><div><br clear="all"><div><div><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice"><a rel="nofollow" shape="rect">904.469.1524</a></span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a> </font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a> <span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a> </span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 2:54 PM, Larry Jedik larry.jedik@… [vantage] <vantage@yahoogroups.com> wrote:

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Jose,</span></div><div><span>I did add the fields to the SSRS report in the query, the field list, and the design form.</span></div><div dir="ltr"><span>I'm not sure what you mean though by running Select *from Part_GUID - </span></div><div dir="ltr"><span>do you mean in the Query statement? </span></div><div><div> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 12:33 PM, "Jose Gomez <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

<div> <div></div><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Did you add the fields to SSRS?</div><div style="font-family:verdana, sans-serif;font-size:small;">Also if you run a Select * from Part_GUID does the table have data?</div></div><div><br clear="all"><div><div><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice"><a rel="nofollow" shape="rect">904.469.1524</a></span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a> </font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a> <span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a> </span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 12:00 PM, Larry Jedik larry.jedik@… [vantage] <vantage@yahoogroups.com> wrote:

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div>To answer a few questions, the data is present in a BAQ for the Part table.</div><div><br clear="none"></div><div>The query and fields were both updated to reflect the added table and fields.</div><div><div> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 10:42 AM, "Joshua Giese <a rel="nofollow" shape="rect" target="_blank" href="mailto:jgiese@...">jgiese@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

<div> <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Joshua Giese
Technology Solutions : CTO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Hi Jose, this is the query for the JobHead dataset I'm using.

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

If you do a BAQ against those fields do you get data?

Jim Kinneman

Encompass, Inc

</div> <div><div style="color:#fff;min-height:0;"></div></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div>
 


<div><div style="color:#fff;min-height:0;"></div></div>

</div><div><div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div><div style="color:#fff;min-height:0;"></div></div>

</div><div><div class="ygrps-yiv-1705881093yiv6049063353h5">
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-1705881093yiv6049063353yqt3522965961" id="ygrps-yiv-1705881093yiv6049063353yqt65172"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353 -- #ygrps-yiv-1705881093yiv6049063353ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mkp #ygrps-yiv-1705881093yiv6049063353hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mkp #ygrps-yiv-1705881093yiv6049063353ads {
margin-bottom:10px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mkp .ygrps-yiv-1705881093yiv6049063353ad {
padding:0 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mkp .ygrps-yiv-1705881093yiv6049063353ad p {
margin:0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mkp .ygrps-yiv-1705881093yiv6049063353ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-sponsor #ygrps-yiv-1705881093yiv6049063353ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-sponsor #ygrps-yiv-1705881093yiv6049063353ygrp-lc #ygrps-yiv-1705881093yiv6049063353hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-sponsor #ygrps-yiv-1705881093yiv6049063353ygrp-lc .ygrps-yiv-1705881093yiv6049063353ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353activity span {
font-weight:700;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353activity span span {
color:#ff7900;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353activity span .ygrps-yiv-1705881093yiv6049063353underline {
text-decoration:underline;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353attach div a {
text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353attach label a {
text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353bold a {
text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 dd.ygrps-yiv-1705881093yiv6049063353last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 dd.ygrps-yiv-1705881093yiv6049063353last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 dd.ygrps-yiv-1705881093yiv6049063353last p span.ygrps-yiv-1705881093yiv6049063353yshortcuts {
margin-right:0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353attach-table {
width:400px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353file-title a, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353file-title a:active, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353file-title a:hover, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353photo-title a, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353photo-title a:active, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353photo-title a:hover, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div.ygrps-yiv-1705881093yiv6049063353photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 div#ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg #ygrps-yiv-1705881093yiv6049063353ygrp-msg p a span.ygrps-yiv-1705881093yiv6049063353yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353green {
color:#628c2a;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 o {
font-size:0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353photos div {
float:left;width:72px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353reco-category {
font-size:77%;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353reco-desc {
font-size:77%;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 .ygrps-yiv-1705881093yiv6049063353replbq {
margin:4px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg select, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 input, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg pre, #ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 code {
font:115% monospace;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-mlmsg #ygrps-yiv-1705881093yiv6049063353logo {
padding-bottom:10px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-msg p#ygrps-yiv-1705881093yiv6049063353attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-reco #ygrps-yiv-1705881093yiv6049063353reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-sponsor #ygrps-yiv-1705881093yiv6049063353ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-sponsor #ygrps-yiv-1705881093yiv6049063353ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-sponsor #ygrps-yiv-1705881093yiv6049063353ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1705881093 #ygrps-yiv-1705881093yiv6049063353 #ygrps-yiv-1705881093yiv6049063353ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1705881093

system · January 12, 2016, 1:42pm

In Epicor 10.0.700.4 and using SSRS,

I am attempting to add two UD fields to the Job Traveler - Part.Number11 and Part.Character06.

I have successfully been able to add UD fields from the JobOper table (which is already part of the RDD), but I am stumped here.

I'm also not sure if my error is in the RDD, the SQL query or both. I have tried different combinations of Keys, Relation Types, etc.

Right now I have added the Part and the Part_UD tables to the RDD.

I have a Relationship JobAsmbl>Part (no key), definition only, joined on Company and PartNum.

I also added a Part>Part_UD relationship, no key, type Output, and joined on SysRowID>ForeignSysRowID.

From the part table, I have un-excluded Company,PartNum,Character06, and Number11.

I also have un-excluded Character06 and Number11 from the Part_UD table (I have tried it several different ways).

I have added the new report style using this RDD, I print a job traveler, grab the GUID, and go to SSRS.

In the Query expression for the JobHead dataset, I've added the Character06 and Number11 fields in the expression and to the field list, and added a join to the Part table:

LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T1.Company = T6.Company AND T1.PartNum = T6.PartNum"

Do I need to reference the Part_UD table here too?

When I run this report in SSRS, I don't get any errors, but the textboxes where I've added the values for Character06 and Number11 are blank (character06 will always have a value so that is not why).

How much of this is even close to correct? Any help would be much appreciated.

system · January 12, 2016, 1:53pm

You do not need to bring in the _UD tables by bringing in the main tables you already have what you need. Remove the _UD tables, and then simply add the field to the DataSet as well as to the Field List in SSRS (from the main table)

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Tue, Jan 12, 2016 at 1:42 PM, larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p></p><p><span>In Epicor 10.0.700.4 and using SSRS,</span></p><p><span>I am attempting to add two UD fields to the Job Traveler - Part.Number11 and Part.Character06.</span></p><p><span>I have successfully been able to add UD fields from the JobOper table (which is already part of the RDD), but I am stumped here.</span></p><p><span><br></span></p><p><span>I&#39;m also not sure if my error is in the RDD, the SQL query or both. I have tried different combinations of Keys, Relation Types, etc.</span></p><p><span><br></span></p><p><span>Right now I have added the Part and the Part_UD tables to the RDD.</span></p><p><span>I have a Relationship JobAsmbl&gt;Part (no key), definition only, joined on Company and PartNum.</span></p><p><span>I also added a Part&gt;Part_UD relationship, no key, type Output, and joined on SysRowID&gt;ForeignSysRowID.</span></p><p><span>From the part table, I have un-excluded Company,PartNum,Character06, and Number11.</span></p><p><span>I also have un-excluded Character06 and Number11 from the Part_UD table (I have tried it several different ways).</span></p><p><span><br></span></p><p><span>I have added the new report style using this RDD, I print a job traveler, grab the GUID, and go to SSRS.</span></p><p><span>In the Query expression for the JobHead dataset, I&#39;ve added the Â Character06 and Number11 fields in the expression and to the field list, and added a join to the Part table:</span></p><p><span>LEFT OUTER JOIN Part_&quot; + Parameters!TableGuid.Value + &quot; T6 Â ON T1.Company = T6.Company AND T1.PartNum = T6.PartNum&quot;<br></span></p><p><span>Do I need to reference the Part_UD table here too?</span></p><p>When I run this report in SSRS, I don&#39;t get any errors, but the textboxes where I&#39;ve added the values for Character06 and Number11 are blank (character06 will always have a value so that is not why).</p><p><br></p><p><span>How much of this is even close to correct?Â  Any help would be much appreciated.</span></p><p><span><br></span></p><p><span><br></span></p><p><span><br></span></p><p><span><br></span></p><p><span><br></span></p><p><br></p><p><span><br></span></p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · January 13, 2016, 2:39pm

Hi Jose,

That was what I originally thought, and had tried that with no success.

I did remove my relationship to the Part_UD table, and then re-ran the report, got the GUID, ensured that my fields Number11 and Character06 were in the field list. I still get no errors, but also no data for those fields.

I also added UnitPrice from the Part table to the RDD, query, and report fields. The UnitPrice field won't populate on the SSRS report either. So, it seems as though the issue has nothing to do with the UD fields themselves, but rather my joining of the part table.

Any ideas on what else I could check? Usually the errors help me figure out the issue, but I'm not getting any so I'm at a loss.

Thanks

Larry

system · January 13, 2016, 3:06pm

What is the error?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Wed, Jan 13, 2016 at 2:39 PM, larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p>Hi Jose,</p><div>That was what I originally thought, and had tried that with no success.</div><div>I did remove my relationship to the Part_UD table, and then re-ran the report, got the GUID, ensured that my fields Number11 and Character06 were in the field list. I still get no errors, but also no data for those fields.</div><div>I also added UnitPrice from the Part table to the RDD, query, and report fields. The UnitPrice field won&#39;t populate on the SSRS report either. So, it seems as though the issue has nothing to do with the UD fields themselves, but rather my joining of the part table.</div><div>Any ideas on what else I could check? Usually the errors help me figure out the issue, but I&#39;m not getting any so I&#39;m at a loss.</div><div><br></div><div>Thanks</div><div>Larry</div><p></p>

</div><span class="ygrps-yiv-1847298450">
 


<div style="color:#fff;min-height:0;"></div>

system · January 13, 2016, 3:29pm

I'm not getting an error. The fields from the Part table are just blank after adding them to the report design and previewing it.

system · January 14, 2016, 8:31am

If you do a BAQ against those fields do you get data?

Jim Kinneman

Encompass, Inc

system · January 14, 2016, 8:46am

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p>If you do a BAQ against those fields do you get data?Â </p><div><br></div><div>Jim Kinneman</div><div>Encompass, Inc</div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · January 14, 2016, 10:30am

Hi Jose, this is the query for the JobHead dataset I'm using.

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1052147022yiv6854745977ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-1052147022yiv6854745977gmail_default" style="font-family:verdana, sans-serif;font-size:small;">What does your SQL DataSet look like in SSRS?</div></div><div class="ygrps-yiv-1052147022yiv6854745977gmail_extra"><br clear="all"><div><div class="ygrps-yiv-1052147022yiv6854745977gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

<div>
  
  
  <div>If you do a BAQ against those fields do you get data?&nbsp;</div><div><br clear="none"></div><div>Jim Kinneman</div><div>Encompass, Inc</div><div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-1052147022yiv6854745977yqt0176651736" id="ygrps-yiv-1052147022yiv6854745977yqt26149"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977 -- #ygrps-yiv-1052147022yiv6854745977ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mkp #ygrps-yiv-1052147022yiv6854745977hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mkp #ygrps-yiv-1052147022yiv6854745977ads {
margin-bottom:10px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mkp .ygrps-yiv-1052147022yiv6854745977ad {
padding:0 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mkp .ygrps-yiv-1052147022yiv6854745977ad p {
margin:0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mkp .ygrps-yiv-1052147022yiv6854745977ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-sponsor #ygrps-yiv-1052147022yiv6854745977ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-sponsor #ygrps-yiv-1052147022yiv6854745977ygrp-lc #ygrps-yiv-1052147022yiv6854745977hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-sponsor #ygrps-yiv-1052147022yiv6854745977ygrp-lc .ygrps-yiv-1052147022yiv6854745977ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977activity span {
font-weight:700;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977activity span span {
color:#ff7900;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977activity span .ygrps-yiv-1052147022yiv6854745977underline {
text-decoration:underline;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977attach div a {
text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977attach label a {
text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977bold a {
text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 dd.ygrps-yiv-1052147022yiv6854745977last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 dd.ygrps-yiv-1052147022yiv6854745977last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 dd.ygrps-yiv-1052147022yiv6854745977last p span.ygrps-yiv-1052147022yiv6854745977yshortcuts {
margin-right:0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977attach-table {
width:400px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977file-title a, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977file-title a:active, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977file-title a:hover, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977photo-title a, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977photo-title a:active, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977photo-title a:hover, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div.ygrps-yiv-1052147022yiv6854745977photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 div#ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg #ygrps-yiv-1052147022yiv6854745977ygrp-msg p a span.ygrps-yiv-1052147022yiv6854745977yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977green {
color:#628c2a;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 o {
font-size:0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977photos div {
float:left;width:72px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977reco-category {
font-size:77%;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977reco-desc {
font-size:77%;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 .ygrps-yiv-1052147022yiv6854745977replbq {
margin:4px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg select, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 input, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg pre, #ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 code {
font:115% monospace;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-mlmsg #ygrps-yiv-1052147022yiv6854745977logo {
padding-bottom:10px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-msg p#ygrps-yiv-1052147022yiv6854745977attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-reco #ygrps-yiv-1052147022yiv6854745977reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-sponsor #ygrps-yiv-1052147022yiv6854745977ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-sponsor #ygrps-yiv-1052147022yiv6854745977ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-sponsor #ygrps-yiv-1052147022yiv6854745977ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1052147022 #ygrps-yiv-1052147022yiv6854745977 #ygrps-yiv-1052147022yiv6854745977ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1052147022

system · January 14, 2016, 10:42am

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Joshua Giese
Technology Solutions : CTO

Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Hi Jose, this is the query for the JobHead dataset I'm using.

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

If you do a BAQ against those fields do you get data?

Jim Kinneman

Encompass, Inc

system · January 14, 2016, 12:03pm

To answer a few questions, the data is present in a BAQ for the Part table.

The query and fields were both updated to reflect the added table and fields.

On Thursday, January 14, 2016 10:42 AM, "Joshua Giese jgiese@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1478669925yiv6007170603ygrp-text">
  
  
  <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Joshua Giese
Technology Solutions : CTO

Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Hi Jose, this is the query for the JobHead dataset I'm using.

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

If you do a BAQ against those fields do you get data?

Jim Kinneman

Encompass, Inc

</div>
 


<div class="ygrps-yiv-1478669925yiv6007170603yqt8959323391" id="ygrps-yiv-1478669925yiv6007170603yqt19904"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603 -- #ygrps-yiv-1478669925yiv6007170603ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mkp #ygrps-yiv-1478669925yiv6007170603hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mkp #ygrps-yiv-1478669925yiv6007170603ads {
margin-bottom:10px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mkp .ygrps-yiv-1478669925yiv6007170603ad {
padding:0 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mkp .ygrps-yiv-1478669925yiv6007170603ad p {
margin:0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mkp .ygrps-yiv-1478669925yiv6007170603ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-sponsor #ygrps-yiv-1478669925yiv6007170603ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-sponsor #ygrps-yiv-1478669925yiv6007170603ygrp-lc #ygrps-yiv-1478669925yiv6007170603hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-sponsor #ygrps-yiv-1478669925yiv6007170603ygrp-lc .ygrps-yiv-1478669925yiv6007170603ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603activity span {
font-weight:700;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603activity span span {
color:#ff7900;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603activity span .ygrps-yiv-1478669925yiv6007170603underline {
text-decoration:underline;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603attach div a {
text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603attach label a {
text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603bold a {
text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 dd.ygrps-yiv-1478669925yiv6007170603last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 dd.ygrps-yiv-1478669925yiv6007170603last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 dd.ygrps-yiv-1478669925yiv6007170603last p span.ygrps-yiv-1478669925yiv6007170603yshortcuts {
margin-right:0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603attach-table {
width:400px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603file-title a, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603file-title a:active, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603file-title a:hover, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603photo-title a, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603photo-title a:active, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603photo-title a:hover, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div.ygrps-yiv-1478669925yiv6007170603photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 div#ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg #ygrps-yiv-1478669925yiv6007170603ygrp-msg p a span.ygrps-yiv-1478669925yiv6007170603yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603green {
color:#628c2a;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 o {
font-size:0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603photos div {
float:left;width:72px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603reco-category {
font-size:77%;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603reco-desc {
font-size:77%;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 .ygrps-yiv-1478669925yiv6007170603replbq {
margin:4px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg select, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 input, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg pre, #ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 code {
font:115% monospace;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-mlmsg #ygrps-yiv-1478669925yiv6007170603logo {
padding-bottom:10px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-msg p#ygrps-yiv-1478669925yiv6007170603attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-reco #ygrps-yiv-1478669925yiv6007170603reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-sponsor #ygrps-yiv-1478669925yiv6007170603ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-sponsor #ygrps-yiv-1478669925yiv6007170603ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-sponsor #ygrps-yiv-1478669925yiv6007170603ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1478669925 #ygrps-yiv-1478669925yiv6007170603 #ygrps-yiv-1478669925yiv6007170603ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1478669925

system · January 14, 2016, 12:33pm

Did you add the fields to SSRS?

Also if you run a Select * from Part_GUID does the table have data?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 12:00 PM, Larry Jedik larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div>To answer a few questions, the data is present in a BAQ for the Part table.</div><div><br></div><div>The query and fields were both updated to reflect the added table and fields.</div><div><div class="ygrps-yiv-126857330h5"> <div><br><br></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 10:42 AM, "Joshua Giese <a rel="nofollow" target="_blank" href="mailto:jgiese@...">jgiese@...</a> [vantage]" <<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br></font></div> <br><br> <div><div><div>

Â

<div> <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Â

Joshua Giese
Technology Solutions : CTO

Direct Phone:Â Â Â 920.593.8299
Office Phone:Â Â Â 920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Â

Â

Hi Jose, this is the query for the JobHead dataset I'm using.

Â

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

Â LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

Â ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

Â LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

Â ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

Â LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

Â ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

Â LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

Â ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 Â ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

Â

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

Â

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

Â

Â

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

Â

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

Â

If you do a BAQ against those fields do you get data?Â

Â

Jim Kinneman

Encompass, Inc

Â

Â

</div> <div><div style="color:#fff;min-height:0;"></div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · January 14, 2016, 2:58pm

Jose,

I did add the fields to the SSRS report in the query, the field list, and the design form.

I'm not sure what you mean though by running Select *from Part_GUID -

do you mean in the Query statement?

On Thursday, January 14, 2016 12:33 PM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1158627708yiv8211092363ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-1158627708yiv8211092363gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Did you add the fields to SSRS?</div><div class="ygrps-yiv-1158627708yiv8211092363gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Also if you run a Select * from Part_GUID does the table have data?</div></div><div class="ygrps-yiv-1158627708yiv8211092363gmail_extra"><br clear="all"><div><div class="ygrps-yiv-1158627708yiv8211092363gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 12:00 PM, Larry Jedik larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div>To answer a few questions, the data is present in a BAQ for the Part table.</div><div><br clear="none"></div><div>The query and fields were both updated to reflect the added table and fields.</div><div><div class="ygrps-yiv-1158627708yiv8211092363h5"> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 10:42 AM, "Joshua Giese <a rel="nofollow" shape="rect" target="_blank" href="mailto:jgiese@...">jgiese@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

<div> <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Joshua Giese
Technology Solutions : CTO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Hi Jose, this is the query for the JobHead dataset I'm using.

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

If you do a BAQ against those fields do you get data?

Jim Kinneman

Encompass, Inc

</div> <div><div style="color:#fff;min-height:0;"></div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-1158627708yiv8211092363yqt7430681803" id="ygrps-yiv-1158627708yiv8211092363yqt64714"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363 -- #ygrps-yiv-1158627708yiv8211092363ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mkp #ygrps-yiv-1158627708yiv8211092363hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mkp #ygrps-yiv-1158627708yiv8211092363ads {
margin-bottom:10px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mkp .ygrps-yiv-1158627708yiv8211092363ad {
padding:0 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mkp .ygrps-yiv-1158627708yiv8211092363ad p {
margin:0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mkp .ygrps-yiv-1158627708yiv8211092363ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-sponsor #ygrps-yiv-1158627708yiv8211092363ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-sponsor #ygrps-yiv-1158627708yiv8211092363ygrp-lc #ygrps-yiv-1158627708yiv8211092363hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-sponsor #ygrps-yiv-1158627708yiv8211092363ygrp-lc .ygrps-yiv-1158627708yiv8211092363ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363activity span {
font-weight:700;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363activity span span {
color:#ff7900;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363activity span .ygrps-yiv-1158627708yiv8211092363underline {
text-decoration:underline;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363attach div a {
text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363attach label a {
text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363bold a {
text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 dd.ygrps-yiv-1158627708yiv8211092363last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 dd.ygrps-yiv-1158627708yiv8211092363last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 dd.ygrps-yiv-1158627708yiv8211092363last p span.ygrps-yiv-1158627708yiv8211092363yshortcuts {
margin-right:0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363attach-table {
width:400px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363file-title a, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363file-title a:active, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363file-title a:hover, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363photo-title a, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363photo-title a:active, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363photo-title a:hover, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div.ygrps-yiv-1158627708yiv8211092363photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 div#ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg #ygrps-yiv-1158627708yiv8211092363ygrp-msg p a span.ygrps-yiv-1158627708yiv8211092363yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363green {
color:#628c2a;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 o {
font-size:0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363photos div {
float:left;width:72px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363reco-category {
font-size:77%;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363reco-desc {
font-size:77%;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 .ygrps-yiv-1158627708yiv8211092363replbq {
margin:4px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg select, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 input, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg pre, #ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 code {
font:115% monospace;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-mlmsg #ygrps-yiv-1158627708yiv8211092363logo {
padding-bottom:10px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-msg p#ygrps-yiv-1158627708yiv8211092363attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-reco #ygrps-yiv-1158627708yiv8211092363reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-sponsor #ygrps-yiv-1158627708yiv8211092363ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-sponsor #ygrps-yiv-1158627708yiv8211092363ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-sponsor #ygrps-yiv-1158627708yiv8211092363ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1158627708 #ygrps-yiv-1158627708yiv8211092363 #ygrps-yiv-1158627708yiv8211092363ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1158627708

system · January 14, 2016, 3:03pm

I dont mean add the fields to SSRS in the query did you add the fields to SSRS as in DataSet 0> Fields -> New Field?

Select Select * From Part_GUID I mean if you log in to SQL and Run that command SELECT * FROM Part_GUID (where GUID is the guid if the report you just ran) do you get results?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 2:54 PM, Larry Jedik larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Jose,</span></div><div><span>I did add the fields to the SSRS report in the query, the field list, and the design form.</span></div><div dir="ltr"><span>I'm not sure what you mean though by running Select *from Part_GUID -Â </span></div><div dir="ltr"><span>do you mean in the Query statement?Â </span></div><div><div class="ygrps-yiv-420313218h5"> <div><br><br></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 12:33 PM, "Jose Gomez <a rel="nofollow" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]" <<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br></font></div> <br><br> <div><div><div>

Â

<div> <div></div><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Did you add the fields to SSRS?</div><div style="font-family:verdana, sans-serif;font-size:small;">Also if you run a Select * from Part_GUID does the table have data?</div></div><div><br clear="all"><div><div><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice"><a rel="nofollow">904.469.1524</a></span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>Â </font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>Â <span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>Â </span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 12:00 PM, Larry Jedik larry.jedik@… [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div>To answer a few questions, the data is present in a BAQ for the Part table.</div><div><br clear="none"></div><div>The query and fields were both updated to reflect the added table and fields.</div><div><div> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 10:42 AM, "Joshua Giese <a rel="nofollow" shape="rect" target="_blank" href="mailto:jgiese@...">jgiese@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

Â

<div> <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Â

Joshua Giese
Technology Solutions : CTO

Direct Phone:Â Â Â 920.593.8299
Office Phone:Â Â Â 920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Â

Â

Hi Jose, this is the query for the JobHead dataset I'm using.

Â

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

Â LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

Â ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

Â LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

Â ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

Â LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

Â ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

Â LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

Â ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 Â ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

Â

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

Â

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

Â

Â

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

Â

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

Â

If you do a BAQ against those fields do you get data?Â

Â

Jim Kinneman

Encompass, Inc

Â

Â

</div> <div><div style="color:#fff;min-height:0;"></div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div><div style="color:#fff;min-height:0;"></div></div>

</div><div><div class="ygrps-yiv-420313218h5">
 


<div style="color:#fff;min-height:0;"></div>

system · January 14, 2016, 3:25pm

Yes, I did add the fields I wanted to work with in DataSet>Fields>New Field. (Sorry, that's what I meant when I said they were added to the field list.)

I logged into SQL and ran the command and got an error message:

Invalid object name 'Part_(GUID string)'.

On Thursday, January 14, 2016 3:04 PM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1759912973yiv6008255145ygrp-text">
  
  
  <div></div><div dir="ltr"><div class="ygrps-yiv-1759912973yiv6008255145gmail_default" style="font-family:verdana, sans-serif;font-size:small;">I dont mean add the fields to SSRS in the query did you add the fields to SSRS as in DataSet 0&gt; Fields -&gt; New Field?</div><div class="ygrps-yiv-1759912973yiv6008255145gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Select Select * From Part_GUID I mean if you log in to SQL and Run that command SELECT * FROM Part_GUID (where GUID is the guid if the report you just ran) do you get results?</div></div><div class="ygrps-yiv-1759912973yiv6008255145gmail_extra"><br clear="all"><div><div class="ygrps-yiv-1759912973yiv6008255145gmail_signature"><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice">904.469.1524</span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>&nbsp;</font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>&nbsp;<a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>&nbsp;<span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>&nbsp;</span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 2:54 PM, Larry Jedik larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Jose,</span></div><div><span>I did add the fields to the SSRS report in the query, the field list, and the design form.</span></div><div dir="ltr"><span>I'm not sure what you mean though by running Select *from Part_GUID - </span></div><div dir="ltr"><span>do you mean in the Query statement? </span></div><div><div class="ygrps-yiv-1759912973yiv6008255145h5"> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 12:33 PM, "Jose Gomez <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

<div> <div></div><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Did you add the fields to SSRS?</div><div style="font-family:verdana, sans-serif;font-size:small;">Also if you run a Select * from Part_GUID does the table have data?</div></div><div><br clear="all"><div><div><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice"><a rel="nofollow" shape="rect">904.469.1524</a></span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a> </font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a> <a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a> <span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a> </span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 12:00 PM, Larry Jedik larry.jedik@… [vantage] <vantage@yahoogroups.com> wrote:

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div>To answer a few questions, the data is present in a BAQ for the Part table.</div><div><br clear="none"></div><div>The query and fields were both updated to reflect the added table and fields.</div><div><div> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 10:42 AM, "Joshua Giese <a rel="nofollow" shape="rect" target="_blank" href="mailto:jgiese@...">jgiese@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

<div> <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Joshua Giese
Technology Solutions : CTO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Hi Jose, this is the query for the JobHead dataset I'm using.

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com


Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

If you do a BAQ against those fields do you get data?

Jim Kinneman

Encompass, Inc

</div> <div><div style="color:#fff;min-height:0;"></div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div><div style="color:#fff;min-height:0;"></div></div>

</div><div><div class="ygrps-yiv-1759912973yiv6008255145h5">
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div class="ygrps-yiv-1759912973yiv6008255145yqt6711418362" id="ygrps-yiv-1759912973yiv6008255145yqt82387"><div style="color:#fff;height:0;"></div></div>

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145 -- #ygrps-yiv-1759912973yiv6008255145ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mkp #ygrps-yiv-1759912973yiv6008255145hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mkp #ygrps-yiv-1759912973yiv6008255145ads {
margin-bottom:10px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mkp .ygrps-yiv-1759912973yiv6008255145ad {
padding:0 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mkp .ygrps-yiv-1759912973yiv6008255145ad p {
margin:0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mkp .ygrps-yiv-1759912973yiv6008255145ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-sponsor #ygrps-yiv-1759912973yiv6008255145ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-sponsor #ygrps-yiv-1759912973yiv6008255145ygrp-lc #ygrps-yiv-1759912973yiv6008255145hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-sponsor #ygrps-yiv-1759912973yiv6008255145ygrp-lc .ygrps-yiv-1759912973yiv6008255145ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145activity span {
font-weight:700;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145activity span span {
color:#ff7900;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145activity span .ygrps-yiv-1759912973yiv6008255145underline {
text-decoration:underline;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145attach div a {
text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145attach label a {
text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145bold a {
text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 dd.ygrps-yiv-1759912973yiv6008255145last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 dd.ygrps-yiv-1759912973yiv6008255145last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 dd.ygrps-yiv-1759912973yiv6008255145last p span.ygrps-yiv-1759912973yiv6008255145yshortcuts {
margin-right:0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145attach-table {
width:400px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145file-title a, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145file-title a:active, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145file-title a:hover, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145photo-title a, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145photo-title a:active, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145photo-title a:hover, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div.ygrps-yiv-1759912973yiv6008255145photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 div#ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg #ygrps-yiv-1759912973yiv6008255145ygrp-msg p a span.ygrps-yiv-1759912973yiv6008255145yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145green {
color:#628c2a;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 o {
font-size:0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145photos div {
float:left;width:72px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145reco-category {
font-size:77%;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145reco-desc {
font-size:77%;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 .ygrps-yiv-1759912973yiv6008255145replbq {
margin:4px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg select, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 input, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg pre, #ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 code {
font:115% monospace;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-mlmsg #ygrps-yiv-1759912973yiv6008255145logo {
padding-bottom:10px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-msg p#ygrps-yiv-1759912973yiv6008255145attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-reco #ygrps-yiv-1759912973yiv6008255145reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-sponsor #ygrps-yiv-1759912973yiv6008255145ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-sponsor #ygrps-yiv-1759912973yiv6008255145ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-sponsor #ygrps-yiv-1759912973yiv6008255145ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1759912973 #ygrps-yiv-1759912973yiv6008255145 #ygrps-yiv-1759912973yiv6008255145ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1759912973

system · January 14, 2016, 3:38pm

Make sure you are in the Report DB when you log in to SQL. If that's the case then your Report Style / RDD aren't generating the part table.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Thu, Jan 14, 2016 at 3:22 PM, Larry Jedik larry.jedik@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Yes, I did add the fields I wanted to work with in DataSet>Fields>New Field. (Sorry, that's what I meant when I said they were added to the field list.)</span></div><div>I logged into SQL and ran the command and got an error message:</div><div dir="ltr">Invalid object name 'Part_(GUID string)'.</div><div><div class="ygrps-yiv-1092862228h5"> <div><br><br></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 3:04 PM, "Jose Gomez <a rel="nofollow" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]" <<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br></font></div> <br><br> <div><div><div>

Â

<div> <div></div><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">I dont mean add the fields to SSRS in the query did you add the fields to SSRS as in DataSet 0> Fields -> New Field?</div><div style="font-family:verdana, sans-serif;font-size:small;">Select Select * From Part_GUID I mean if you log in to SQL and Run that command SELECT * FROM Part_GUID (where GUID is the guid if the report you just ran) do you get results?</div></div><div><br clear="all"><div><div><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice"><a rel="nofollow">904.469.1524</a></span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>Â </font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>Â <span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>Â </span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 2:54 PM, Larry Jedik larry.jedik@… [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div><span>Jose,</span></div><div><span>I did add the fields to the SSRS report in the query, the field list, and the design form.</span></div><div dir="ltr"><span>I'm not sure what you mean though by running Select *from Part_GUID -Â </span></div><div dir="ltr"><span>do you mean in the Query statement?Â </span></div><div><div> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 12:33 PM, "Jose Gomez <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

Â

<div> <div></div><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Did you add the fields to SSRS?</div><div style="font-family:verdana, sans-serif;font-size:small;">Also if you run a Select * from Part_GUID does the table have data?</div></div><div><br clear="all"><div><div><div dir="ltr"><div><font face="verdana, sans-serif"><br clear="none"><font color="#333333"><b>Jose C Gomez</b></font></font></div><div><font color="#666666" face="verdana, sans-serif" size="1"><b>Software Engineer<br clear="none"><br clear="none"></b></font></div><div><font face="verdana, sans-serif"><font><font color="#666666"><b><br clear="none"></b></font><font color="#FF6600" size="1">T: </font></font><font size="1"><span title="Call with Google Voice"><span title="Call with Google Voice"><a rel="nofollow" shape="rect">904.469.1524</a></span></span> mobile</font></font></div><div><font size="1" face="verdana, sans-serif"><font color="#FF6600">E:</font> <a rel="nofollow" shape="rect" target="_blank" href="mailto:jose@...">jose@...</a></font><font size="1" face="verdana, sans-serif"><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/"><font color="#FF6600">http://www.josecgomez.com</font></a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://www.linkedin.com/in/josecgomez" style="font-size:small;"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.facebook.com/josegomez" style="font-size:small;"><img></a>Â </font><a rel="nofollow" shape="rect" target="_blank" href="http://www.google.com/profiles/jose.gomez"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.twitter.com/joc85"><img></a>Â <a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/professional-resume/"><img></a>Â <span style="font-family:verdana, sans-serif;"><a rel="nofollow" shape="rect" target="_blank" href="http://www.josecgomez.com/feed/"><img></a>Â </span></div><div><span lang="LA" style="color:black;"><br clear="none"><font face="Verdana, sans-serif" style="font-weight:bold;" size="1"><i>Quis custodiet

ipsos custodes?

On Thu, Jan 14, 2016 at 12:00 PM, Larry Jedik larry.jedik@… [vantage] <vantage@yahoogroups.com> wrote:

Â

<div> <div></div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div>To answer a few questions, the data is present in a BAQ for the Part table.</div><div><br clear="none"></div><div>The query and fields were both updated to reflect the added table and fields.</div><div><div> <div><br clear="none"><br clear="none"></div><div> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"><font size="2" face="Arial"> On Thursday, January 14, 2016 10:42 AM, "Joshua Giese <a rel="nofollow" shape="rect" target="_blank" href="mailto:jgiese@...">jgiese@...</a> [vantage]" <<a rel="nofollow" shape="rect" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div><div><div>

Â

<div> <div>

Did you update the select in this query and the fields in the dataset in the report builder? You have to do it in both places. Sorry if you already mentioned if you have or have not, I missed that at some point then.

Â

Joshua Giese
Technology Solutions : CTO

Direct Phone:Â Â Â 920.593.8299
Office Phone:Â Â Â 920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 14, 2016 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Epicor 10 SSRS UD Fields in RDD

Â

Â

Hi Jose, this is the query for the JobHead dataset I'm using.

Â

="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.Number01,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf

, T6.Company as Part_Company, T6.PartNum as Part_PartNum, T6.Character06, T6.Number11, T6.UnitPrice FROM JobHead_" + Parameters!TableGuid.Value + " T1

Â LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2

Â ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum

Â LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3

Â ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq

Â LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4

Â ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq

Â LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5

Â ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6 Â ON T2.Company = T6.Company AND T2.PartNum = T6.PartNum"

Â

I wasn't sure if I needed to add Part and Company to T6 in the list of fields. I had tried it both ways and still just get no data returned. Thanks.

Â

On Thursday, January 14, 2016 8:46 AM, "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com> wrote:

Â

Â

What does your SQL DataSet look like in SSRS?

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com
Â Â Â Â Â Â

Quis custodiet ipsos custodes?

Â

On Thu, Jan 14, 2016 at 8:31 AM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

Â

If you do a BAQ against those fields do you get data?Â

Â

Jim Kinneman

Encompass, Inc

Â

Â

</div> <div><div style="color:#fff;min-height:0;"></div></div>

</div> <div style="color:#fff;min-height:0;"></div>

</div>
 


<div><div style="color:#fff;min-height:0;"></div></div>

</div><div><div>
 


<div style="color:#fff;min-height:0;"></div>

</div>
 


<div><div style="color:#fff;min-height:0;"></div></div>

</div><div><div class="ygrps-yiv-1092862228h5">
 


<div style="color:#fff;min-height:0;"></div>

Topic		Replies	Views
SSRS Form/Database not Displaying UD Field Data Epicor ERP 10	19	4877	April 27, 2020
AR Form RDD Epicor ERP 10	17	1204	September 26, 2018
10.2 -- Anyone having trouble with Report Data Definitions recognizing older UD fields? Epicor ERP 10	1	1012	February 23, 2018
Difficulty getting UD field onto Job Traveler Kinetic ERP ssrs	40	2056	December 21, 2023
Report Data Definition Epicor ERP 10 reports	7	2803	January 18, 2023

Epicor 10 SSRS UD Fields in RDD

Related topics