E10 Execute BAQ In Customization

Yahoo Archive
21

It might help to post your franken-code in its entirety at this point.

 

Joshua Giese

CIO

 

Direct:     920.593.8299

IT Dept:   920.437.6400 Ext. 337

Site ID:    27450-E905702A-SQL64

Wisconsin Converting, Inc.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, January 28, 2015 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 Execute BAQ In Customization

 

 

Ok, did all that and now I have this:

 Error: BC30455 - line 73 (338) - Argument not specified for parameter 'session' of 'Public Shared Function CreateImpl(Of T As Epicor.ServiceModel.Channels.ImplBase)(session As Ice.Core.Session, uriPath As String) As T'.
 Error: BC30455 - line 73 (338) - Argument not specified for parameter 'uriPath' of 'Public Shared Function CreateImpl(Of T As Epicor.ServiceModel.Channels.ImplBase)(session As Ice.Core.Session, uriPath As String) As T'.
 Error: BC30691 - line 73 (338) - 'DynamicQueryImpl' is a type in 'BO' and cannot be used as an expression.
 Error: BC30108 - line 73 (338) - 'Session' is a type and cannot be used as an expression.
 Error: BC30198 - line 73 (338) - ')' expected.

 

I know you were trying to save me lol, but its also good to see this so when I go back to fix them I know at least whats going on.

22

Yeah might need your entire function

On Jan 28, 2015 11:56 AM, "Joshua Giese jgiese@... [vantage]" <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

It might help to post your franken-code in its entirety at this point.

Â

Joshua Giese

CIO

Â

Direct: Â Â Â 920.593.8299

IT Dept: Â 920.437.6400 Ext. 337

Site ID: Â Â 27450-E905702A-SQL64

Wisconsin Converting, Inc.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, January 28, 2015 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 Execute BAQ In Customization

Â

Â

Ok, did all that and now I have this:

 Error: BC30455 - line 73 (338) - Argument not specified for parameter 'session' of 'Public Shared Function CreateImpl(Of T As Epicor.ServiceModel.Channels.ImplBase)(session As Ice.Core.Session, uriPath As String) As T'.
 Error: BC30455 - line 73 (338) - Argument not specified for parameter 'uriPath' of 'Public Shared Function CreateImpl(Of T As Epicor.ServiceModel.Channels.ImplBase)(session As Ice.Core.Session, uriPath As String) As T'.
 Error: BC30691 - line 73 (338) - 'DynamicQueryImpl' is a type in 'BO' and cannot be used as an expression.
 Error: BC30108 - line 73 (338) - 'Session' is a type and cannot be used as an expression.
 Error: BC30198 - line 73 (338) - ')' expected.

Â

I know you were trying to save me lol, but its also good to see this so when I go back to fix them I know at least whats going on.

</div>
 


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

 Private Sub btnRefresh_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnRefresh.Click
  '// ** Place Event Handling Code Here **
     'Ice.Core.Session session As New Session(amathis, amathis2, UD01Form.Session.LicenseType.Default, "C:\Epicor\ERP10.0Client\Client\config\default.sysconfig")
        'Dim connPool As New Ice.Core.BLConnectionPool(sUser, sPass, sAppServer)
     'Dim baq As DynamicQueryAdapter = new DynamicQueryAdapter(oTrans)
           Dim dynQry As Ice.Proxy.BO.DynamicQueryImpl
     dynQry = Ice.Lib.Framework.WCFServiceSupport.CreateImpl<Ice.Proxy.BO.DynamicQueryImpl>((Ice.Core.Session)epiSession, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.DynamicQuerySvcContract>.UriPath)
     Dim dsDQ As Ice.BO.DynamicQueryDataSet
     Dim dsEx as Ice.BO.QueryExecutionDataSet
              Dim ds2 As System.Data.DataSet
              Dim RetRows() as datarow
              Dim Rework as boolean

              dsDQ = dynQry.GetByID("JBIS-JobPerformance")
              dsDQ.QueryWhereItem(0).RValue = "JBIS"
              dsDQ.QueryWhereItem(1).RValue = True
              dsDQ.QueryWhereItem(2).RValue = dteStartDate.Text
              dsDQ.QueryWhereItem(3).RValue = dteEndDate.Text
     dsDQ.AcceptChanges()
              ds2 = dynQry.Execute(dsDQ, dsEx)



//The code here is just a table being set up, nothing fancy really.


end Sub


There is the code, hope it helps.

24

 Private Sub btnRefresh_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnRefresh.Click
  '// ** Place Event Handling Code Here ** 

           Dim dynQry As Ice.Proxy.BO.DynamicQueryImpl
     dynQry = Ice.Lib.Framework.WCFServiceSupport.CreateImpl<Ice.Proxy.BO.DynamicQueryImpl>((Ice.Core.Session)epiSession, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.DynamicQuerySvcContract>.UriPath)
     Dim dsDQ As Ice.BO.DynamicQueryDataSet
     Dim dsEx as Ice.BO.QueryExecutionDataSet
              Dim ds2 As System.Data.DataSet
              Dim RetRows() as datarow
              Dim Rework as boolean

              dsDQ = dynQry.GetByID("JBIS-JobPerformance")
              dsDQ.QueryWhereItem(0).RValue = "JBIS"
              dsDQ.QueryWhereItem(1).RValue = True
              dsDQ.QueryWhereItem(2).RValue = dteStartDate.Text
              dsDQ.QueryWhereItem(3).RValue = dteEndDate.Text
     dsDQ.AcceptChanges()
              ds2 = dynQry.Execute(dsDQ, dsEx)


End Sub


Cleaned it up a bit.

25
If you add the following to your imports and use the following declaration it should work
Imports Ice.Proxy.BO
Imports Ice.Core
Imports Ice.BO

Dim dq As DynamicQueryImpl
dq = WCFServiceSupport.CreateImpl(Of Ice.Proxy.BO.DynamicQueryImpl)(DirectCast(oTrans.Session, Session), Epicor.ServiceModel.Channels.ImplBase(Of Ice.Contracts.DynamicQuerySvcContract).UriPath)


Make sure you brought in Ice.Core.Session, and the DynamicQuery Adapter and BO


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Jan 28, 2015 at 12:07 PM, amathis@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span class="ygrps-yiv-1139906790">Â Private Sub btnRefresh_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnRefresh.Click<br>Â Â &#39;// ** Place Event Handling Code Here **Â <br><br></span>Â Â Â Â Â Â Â Â Â Â  Dim dynQry As Ice.Proxy.BO.DynamicQueryImpl<br>Â Â Â Â  dynQry = Ice.Lib.Framework.WCFServiceSupport.CreateImpl&lt;Ice.Proxy.BO.DynamicQueryImpl&gt;((Ice.Core.Session)epiSession, Epicor.ServiceModel.Channels.ImplBase&lt;Ice.Contracts.DynamicQuerySvcContract&gt;.UriPath) <br><span class="ygrps-yiv-1139906790">Â Â Â Â  Dim dsDQ As Ice.BO.DynamicQueryDataSet<br>Â Â Â Â  Dim dsEx as Ice.BO.QueryExecutionDataSet<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  Dim ds2 As System.Data.DataSet<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  Dim RetRows() as datarow<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  Dim Rework as boolean</span></p><p><span class="ygrps-yiv-1139906790">Â Â Â Â Â Â Â Â Â Â Â Â Â  dsDQ = dynQry.GetByID(&quot;JBIS-JobPerformance&quot;)<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  dsDQ.QueryWhereItem(0).RValue = &quot;JBIS&quot;<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  dsDQ.QueryWhereItem(1).RValue = True<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  dsDQ.QueryWhereItem(2).RValue = dteStartDate.Text<br>Â Â Â Â Â Â Â Â Â Â Â Â Â  dsDQ.QueryWhereItem(3).RValue = dteEndDate.Text<br>Â Â Â Â  dsDQ.AcceptChanges()<br></span>Â Â Â Â Â Â Â Â Â Â Â Â Â  ds2 = dynQry.Execute(dsDQ, dsEx)</p><p><br></p><p>End Sub</p><p><br></p><p>Cleaned it up a bit.<br></p><p></p>

</div>
 


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

26
Jose you are amazing! Thank you so much. Code is compiling now and I will be testing here soon!
27

Glad it worked,
Take the time to change up those BAQ's though it's worth it for the future

On Jan 28, 2015 3:14 PM, "amathis@... [vantage]" <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Jose you are amazing! Thank you so much. Code is compiling now and I will be testing here soon!</p>

</div>
 


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

We have till end of march to get this not only converted, but working for end users, but after that trust me. I will be updating everything to C# and the BAQs, on a side note. It is compiling now, but not working. in the screen I get a JIT error. hmm, guess its debugging time.


 Private Sub btnRefresh_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnRefresh.Click
  '// ** Place Event Handling Code Here ** 

           Dim dynQry As DynamicQueryImpl
     dynQry = WCFServiceSupport.CreateImpl(Of Ice.Proxy.BO.DynamicQueryImpl)(DirectCast(oTrans.Session, Session), Epicor.ServiceModel.Channels.ImplBase(Of Ice.Contracts.DynamicQuerySvcContract).UriPath)
     Dim dsDQ As Ice.BO.DynamicQueryDataSet
     Dim dsEx as Ice.BO.QueryExecutionDataSet
              Dim ds2 As System.Data.DataSet
              Dim RetRows() as datarow
              Dim Rework as boolean

              dsDQ = dynQry.GetByID("JBIS-JobPerformance")
              dsDQ.QueryWhereItem(0).RValue = "JBIS"
              dsDQ.QueryWhereItem(1).RValue = 1
              dsDQ.QueryWhereItem(2).RValue = dteStartDate.Text
              dsDQ.QueryWhereItem(3).RValue = dteEndDate.Text
     dsDQ.AcceptChanges()
              ds2 = dynQry.Execute(dsDQ, dsEx)


End Sub


That is the final code, and it is compiling.

29
Nevermind, I saw my error. Thanks though !
30

Here is full Query, it runs, no errors and compiles, however, nothing shows up in grid, but if I run is straight from BAQ the date I put in there will work just fine and return rows. So I assume its gotta be somewhere below while making the grid.


 Private Sub btnRefresh_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnRefresh.Click
  '// ** Place Event Handling Code Here **

           Dim dynQry As DynamicQueryImpl
     dynQry = WCFServiceSupport.CreateImpl(Of Ice.Proxy.BO.DynamicQueryImpl)(DirectCast(oTrans.Session, Session), Epicor.ServiceModel.Channels.ImplBase(Of Ice.Contracts.DynamicQuerySvcContract).UriPath)
     Dim dsDQ As New Ice.BO.DynamicQueryDataSet()
     Dim dsEx as New Ice.BO.QueryExecutionDataSet()
              Dim ds2 As System.Data.DataSet
              Dim RetRows() as datarow
              Dim Rework as boolean

              dsDQ = dynQry.GetByID("JBIS-JobPerformance1")
              dsDQ.QueryWhereItem(0).RValue = "JBIS"
              dsDQ.QueryWhereItem(1).RValue = 1
              dsDQ.QueryWhereItem(2).RValue = CDate(dteStartDate.Text).ToString("yyyyMMdd") 'this will format a date from 09/01/2014 to 20140901
              dsDQ.QueryWhereItem(3).RValue =  CDate(dteEndDate.Text).ToString("yyyyMMdd")  'this will format a date from 09/01/2014 to 20140901
     dsDQ.AcceptChanges()
              ds2 = dynQry.Execute(dsDQ, dsEx)

              Dim JobNum As String = ""
              Dim dtJobData As New System.Data.DataTable
              dtJobData.TableName = "JobData"
              dtJobData.Columns.Add("JobNum", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("PartNum", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("ProdQty", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("QtyCompleted", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("JobCompletionDate", System.Type.GetType("System.DateTime"))
              dtJobData.Columns.Add("MtlAct", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("MtlEst", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("Scrap", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("UnitCostAct", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("UnitCostEst", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("Op10Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op10Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op10SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op10SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Rework", System.Type.GetType("System.Boolean"))
                           

              Dim dt1 As System.Data.DataTable
              dt1 = ds2.Tables(0)
              Dim dt2 As System.Data.DataTable = ds2.Tables(0).DefaultView.ToTable("JobHead", True, "JobHead_JobNum")
              For Each dr2 As DataRow In dt2.Rows
                     JobNum = dr2(0).ToString
                     Dim PartNum As String = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(1).ToString
                     Dim CompletionDate As Date = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(2).ToString
                     Dim ProdQty As Decimal = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(3).ToString
                     Dim QtyCompleted As Decimal = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(4).ToString
                     Dim MatAct As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("MatAct") 
                     Dim MtlEst As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("MtlEst")
                     Dim Op10Act As Object = dt1.Compute("Sum(Op10Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op10Est As Object = dt1.Compute("Sum(Op10Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op10SuAct As Object = dt1.Compute("Sum(Op10SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op10SuEst As Object = dt1.Compute("Sum(Op10SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20Act As Object = dt1.Compute("Sum(Op20Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20Est As Object = dt1.Compute("Sum(Op20Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20SuAct As Object = dt1.Compute("Sum(Op20SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20SuEst As Object = dt1.Compute("Sum(Op20SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30Act As Object = dt1.Compute("Sum(Op30Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30Est As Object = dt1.Compute("Sum(Op30Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30SuAct As Object = dt1.Compute("Sum(Op30SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30SuEst As Object = dt1.Compute("Sum(Op30SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40Act As Object = dt1.Compute("Sum(Op40Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40Est As Object = dt1.Compute("Sum(Op40Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40SuAct As Object = dt1.Compute("Sum(Op40SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40SuEst As Object = dt1.Compute("Sum(Op40SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50Act As Object = dt1.Compute("Sum(Op50Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50Est As Object = dt1.Compute("Sum(Op50Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50SuAct As Object = dt1.Compute("Sum(Op50SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50SuEst As Object = dt1.Compute("Sum(Op50SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60Act As Object = dt1.Compute("Sum(Op60Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60Est As Object = dt1.Compute("Sum(Op60Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60SuAct As Object = dt1.Compute("Sum(Op60SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60SuEst As Object = dt1.Compute("Sum(Op60SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70Act As Object = dt1.Compute("Sum(Op70Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70Est As Object = dt1.Compute("Sum(Op70Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70SuAct As Object = dt1.Compute("Sum(Op70SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70SuEst As Object = dt1.Compute("Sum(Op70SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80Act As Object = dt1.Compute("Sum(Op80Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80Est As Object = dt1.Compute("Sum(Op80Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80SuAct As Object = dt1.Compute("Sum(Op80SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80SuEst As Object = dt1.Compute("Sum(Op80SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim UnitCostAct2 As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("UnitCostAct2")
                     Dim UnitCostEst2 As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("UnitCostEst2")
                     RetRows = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))
                     If RetRows(0)("JobHead_Checkbox01") is System.DBNull.value then
                        Rework = False
                     else
                        Rework = RetRows(0)("JobHead_Checkbox01")
                     end if                
                     Dim Scrap As Object = dt1.Compute("Sum(Scrap)", String.Format("JobHead_JobNum='{0}'", JobNum))

                     Dim jdRow As DataRow = dtJobData.NewRow()
                     jdRow("JobCompletionDate") = CompletionDate
                     jdRow("JobNum") = JobNum
                     jdRow("PartNum") = PartNum
                     jdRow("ProdQty") = ProdQty
                     jdRow("QtyCompleted") = QtyCompleted
                     jdRow("MtlAct") = string.format("{0:C}", MatAct)
                     jdRow("MtlEst") = string.format("{0:C}", MtlEst)
                     jdRow("Op10Act") = Op10Act
                     jdRow("Op10Est") = Op10Est
                     jdRow("Op10SuAct") = Op10SuAct
                     jdRow("Op10SuEst") = Op10SuEst
                     jdRow("Op20Act") = Op20Act
                     jdRow("Op20Est") = Op20Est
                     jdRow("Op20SuAct") = Op20SuAct
                     jdRow("Op20SuEst") = Op20SuEst
                     jdRow("Op30Act") = Op30Act
                     jdRow("Op30Est") = Op30Est
                     jdRow("Op30SuAct") = Op30SuAct
                     jdRow("Op30SuEst") = Op30SuEst
                     jdRow("Op40Act") = Op40Act
                     jdRow("Op40Est") = Op40Est
                     jdRow("Op40SuAct") = Op40SuAct
                     jdRow("Op40SuEst") = Op40SuEst
                     jdRow("Op50Act") = Op50Act
                     jdRow("Op50Est") = Op50Est
                     jdRow("Op50SuAct") = Op50SuAct
                     jdRow("Op50SuEst") = Op50SuEst
                     jdRow("Op60Act") = Op60Act
                     jdRow("Op60Est") = Op60Est
                     jdRow("Op60SuAct") = Op60SuAct
                     jdRow("Op60SuEst") = Op60SuEst
                     jdRow("Op70Act") = Op70Act
                     jdRow("Op70Est") = Op70Est
                     jdRow("Op70SuAct") = Op70SuAct
                     jdRow("Op70SuEst") = Op70SuEst
                     jdRow("Op80Act") = Op80Act
                     jdRow("Op80Est") = Op80Est
                     jdRow("Op80SuAct") = Op80SuAct
                     jdRow("Op80SuEst") = Op80SuEst
                     jdRow("Scrap") = Scrap
                     jdRow("UnitCostAct") = string.format("{0:C}", UnitCostAct2)
                     jdRow("UnitCostEst") = string.format("{0:C}", UnitCostEst2)
                     jdRow("Rework") = Rework
                     dtJobData.Rows.Add(jdRow)
              Next
              eugJobData.DataSource = dtJobData

 End Sub

31
Why not do this?
eugJobData.DataSource = ds2.Tables(0)

From: "amathis@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, January 28, 2015 5:26 PM
Subject: [Vantage] Re: E10 Execute BAQ In Customization

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219 --

#ygrps-yiv-1231854626yiv5347050219 .ygrps-yiv-1231854626yiv5347050219ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219photo-title
a,
#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219photo-title a:active,
#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219photo-title a:hover,
#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219attach-table div.ygrps-yiv-1231854626yiv5347050219attach-row {
clear:both;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219attach-table div.ygrps-yiv-1231854626yiv5347050219attach-row div {
float:left;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219ygrp-file {
width:30px;}
#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219attach-table div.ygrps-yiv-1231854626yiv5347050219attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219attach-table div.ygrps-yiv-1231854626yiv5347050219attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 div.ygrps-yiv-1231854626yiv5347050219ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1231854626
#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219 –
#ygrps-yiv-1231854626yiv5347050219ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219ygrp-mkp #ygrps-yiv-1231854626yiv5347050219hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219ygrp-mkp #ygrps-yiv-1231854626yiv5347050219ads {
margin-bottom:10px;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219ygrp-mkp .ygrps-yiv-1231854626yiv5347050219ad {
padding:0 0;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219ygrp-mkp .ygrps-yiv-1231854626yiv5347050219ad p {
margin:0;}

#ygrps-yiv-1231854626 #ygrps-yiv-1231854626yiv5347050219 #ygrps-yiv-1231854626yiv5347050219ygrp-mkp .ygrps-yiv-1231854626yiv5347050219ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1231854626



Here is full Query, it runs, no errors and compiles, however, nothing shows up in grid, but if I run is straight from BAQ the date I put in there will work just fine and return rows. So I assume its gotta be somewhere below while making the grid.

 Private Sub btnRefresh_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnRefresh.Click
  '// ** Place Event Handling Code Here **
           Dim dynQry As DynamicQueryImpl
     dynQry = WCFServiceSupport.CreateImpl(Of Ice.Proxy.BO.DynamicQueryImpl)(DirectCast(oTrans.Session, Session), Epicor.ServiceModel.Channels.ImplBase(Of Ice.Contracts.DynamicQuerySvcContract).UriPath)
     Dim dsDQ As New Ice.BO.DynamicQueryDataSet()
     Dim dsEx as New Ice.BO.QueryExecutionDataSet()
              Dim ds2 As System.Data.DataSet
              Dim RetRows() as datarow
              Dim Rework as boolean
              dsDQ = dynQry.GetByID("JBIS-JobPerformance1")
              dsDQ.QueryWhereItem(0).RValue = "JBIS"
              dsDQ.QueryWhereItem(1).RValue = 1
              dsDQ.QueryWhereItem(2).RValue = CDate(dteStartDate.Text).ToString("yyyyMMdd") 'this will format a date from 09/01/2014 to 20140901
              dsDQ.QueryWhereItem(3).RValue =  CDate(dteEndDate.Text).ToString("yyyyMMdd")  'this will format a date from 09/01/2014 to 20140901
     dsDQ.AcceptChanges()
              ds2 = dynQry.Execute(dsDQ, dsEx)
              Dim JobNum As String = ""
              Dim dtJobData As New System.Data.DataTable
              dtJobData.TableName = "JobData"
              dtJobData.Columns.Add("JobNum", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("PartNum", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("ProdQty", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("QtyCompleted", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("JobCompletionDate", System.Type.GetType("System.DateTime"))
              dtJobData.Columns.Add("MtlAct", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("MtlEst", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("Scrap", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("UnitCostAct", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("UnitCostEst", System.Type.GetType("System.String"))
              dtJobData.Columns.Add("Op10Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op10Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op10SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op10SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op20SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op30SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op40SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op50SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op60SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op70SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80Act", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80Est", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80SuAct", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Op80SuEst", System.Type.GetType("System.Decimal"))
              dtJobData.Columns.Add("Rework", System.Type.GetType("System.Boolean"))
                           
              Dim dt1 As System.Data.DataTable
              dt1 = ds2.Tables(0)
              Dim dt2 As System.Data.DataTable = ds2.Tables(0).DefaultView.ToTable("JobHead", True, "JobHead_JobNum")
              For Each dr2 As DataRow In dt2.Rows
                     JobNum = dr2(0).ToString
                     Dim PartNum As String = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(1).ToString
                     Dim CompletionDate As Date = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(2).ToString
                     Dim ProdQty As Decimal = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(3).ToString
                     Dim QtyCompleted As Decimal = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item(4).ToString
                     Dim MatAct As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("MatAct") 
                     Dim MtlEst As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("MtlEst")
                     Dim Op10Act As Object = dt1.Compute("Sum(Op10Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op10Est As Object = dt1.Compute("Sum(Op10Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op10SuAct As Object = dt1.Compute("Sum(Op10SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op10SuEst As Object = dt1.Compute("Sum(Op10SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20Act As Object = dt1.Compute("Sum(Op20Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20Est As Object = dt1.Compute("Sum(Op20Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20SuAct As Object = dt1.Compute("Sum(Op20SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op20SuEst As Object = dt1.Compute("Sum(Op20SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30Act As Object = dt1.Compute("Sum(Op30Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30Est As Object = dt1.Compute("Sum(Op30Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30SuAct As Object = dt1.Compute("Sum(Op30SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op30SuEst As Object = dt1.Compute("Sum(Op30SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40Act As Object = dt1.Compute("Sum(Op40Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40Est As Object = dt1.Compute("Sum(Op40Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40SuAct As Object = dt1.Compute("Sum(Op40SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op40SuEst As Object = dt1.Compute("Sum(Op40SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50Act As Object = dt1.Compute("Sum(Op50Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50Est As Object = dt1.Compute("Sum(Op50Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50SuAct As Object = dt1.Compute("Sum(Op50SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op50SuEst As Object = dt1.Compute("Sum(Op50SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60Act As Object = dt1.Compute("Sum(Op60Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60Est As Object = dt1.Compute("Sum(Op60Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60SuAct As Object = dt1.Compute("Sum(Op60SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op60SuEst As Object = dt1.Compute("Sum(Op60SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70Act As Object = dt1.Compute("Sum(Op70Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70Est As Object = dt1.Compute("Sum(Op70Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70SuAct As Object = dt1.Compute("Sum(Op70SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op70SuEst As Object = dt1.Compute("Sum(Op70SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80Act As Object = dt1.Compute("Sum(Op80Act)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80Est As Object = dt1.Compute("Sum(Op80Est)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80SuAct As Object = dt1.Compute("Sum(Op80SuAct)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim Op80SuEst As Object = dt1.Compute("Sum(Op80SuEst)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim UnitCostAct2 As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("UnitCostAct2")
                     Dim UnitCostEst2 As Object = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))(0).Item("UnitCostEst2")
                     RetRows = ds2.Tables(0).Select(String.Format("JobHead_JobNum='{0}'", JobNum))
                     If RetRows(0)("JobHead_Checkbox01") is System.DBNull.value then
                        Rework = False
                     else
                        Rework = RetRows(0)("JobHead_Checkbox01")
                     end if                
                     Dim Scrap As Object = dt1.Compute("Sum(Scrap)", String.Format("JobHead_JobNum='{0}'", JobNum))
                     Dim jdRow As DataRow = dtJobData.NewRow()
                     jdRow("JobCompletionDate") = CompletionDate
                     jdRow("JobNum") = JobNum
                     jdRow("PartNum") = PartNum
                     jdRow("ProdQty") = ProdQty
                     jdRow("QtyCompleted") = QtyCompleted
                     jdRow("MtlAct") = string.format("{0:C}", MatAct)
                     jdRow("MtlEst") = string.format("{0:C}", MtlEst)
                     jdRow("Op10Act") = Op10Act
                     jdRow("Op10Est") = Op10Est
                     jdRow("Op10SuAct") = Op10SuAct
                     jdRow("Op10SuEst") = Op10SuEst
                     jdRow("Op20Act") = Op20Act
                     jdRow("Op20Est") = Op20Est
                     jdRow("Op20SuAct") = Op20SuAct
                     jdRow("Op20SuEst") = Op20SuEst
                     jdRow("Op30Act") = Op30Act
                     jdRow("Op30Est") = Op30Est
                     jdRow("Op30SuAct") = Op30SuAct
                     jdRow("Op30SuEst") = Op30SuEst
                     jdRow("Op40Act") = Op40Act
                     jdRow("Op40Est") = Op40Est
                     jdRow("Op40SuAct") = Op40SuAct
                     jdRow("Op40SuEst") = Op40SuEst
                     jdRow("Op50Act") = Op50Act
                     jdRow("Op50Est") = Op50Est
                     jdRow("Op50SuAct") = Op50SuAct
                     jdRow("Op50SuEst") = Op50SuEst
                     jdRow("Op60Act") = Op60Act
                     jdRow("Op60Est") = Op60Est
                     jdRow("Op60SuAct") = Op60SuAct
                     jdRow("Op60SuEst") = Op60SuEst
                     jdRow("Op70Act") = Op70Act
                     jdRow("Op70Est") = Op70Est
                     jdRow("Op70SuAct") = Op70SuAct
                     jdRow("Op70SuEst") = Op70SuEst
                     jdRow("Op80Act") = Op80Act
                     jdRow("Op80Est") = Op80Est
                     jdRow("Op80SuAct") = Op80SuAct
                     jdRow("Op80SuEst") = Op80SuEst
                     jdRow("Scrap") = Scrap
                     jdRow("UnitCostAct") = string.format("{0:C}", UnitCostAct2)
                     jdRow("UnitCostEst") = string.format("{0:C}", UnitCostEst2)
                     jdRow("Rework") = Rework
                     dtJobData.Rows.Add(jdRow)
              Next
              eugJobData.DataSource = dtJobData
 End Sub




32
If  notice the desired result is to have the tables summed up rather then display 10 accounts for the same record, so some custom work was done, otherwise I would of just done that. Also found out its not the custom grid code causing issues, its the formatting of the QueryWhereItems and somehow that isn't working :/
33
Why don't you do the summarizing within the BAQ then?

From: "amathis@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Thursday, January 29, 2015 11:09 AM
Subject: [Vantage] Re: E10 Execute BAQ In Customization

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566 --

#ygrps-yiv-1285453582yiv8940483566 .ygrps-yiv-1285453582yiv8940483566ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566photo-title
a,
#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566photo-title a:active,
#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566photo-title a:hover,
#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566attach-table div.ygrps-yiv-1285453582yiv8940483566attach-row {
clear:both;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566attach-table div.ygrps-yiv-1285453582yiv8940483566attach-row div {
float:left;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566ygrp-file {
width:30px;}
#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566attach-table div.ygrps-yiv-1285453582yiv8940483566attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566attach-table div.ygrps-yiv-1285453582yiv8940483566attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 div.ygrps-yiv-1285453582yiv8940483566ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1285453582
#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566 –
#ygrps-yiv-1285453582yiv8940483566ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566ygrp-mkp #ygrps-yiv-1285453582yiv8940483566hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566ygrp-mkp #ygrps-yiv-1285453582yiv8940483566ads {
margin-bottom:10px;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566ygrp-mkp .ygrps-yiv-1285453582yiv8940483566ad {
padding:0 0;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566ygrp-mkp .ygrps-yiv-1285453582yiv8940483566ad p {
margin:0;}

#ygrps-yiv-1285453582 #ygrps-yiv-1285453582yiv8940483566 #ygrps-yiv-1285453582yiv8940483566ygrp-mkp .ygrps-yiv-1285453582yiv8940483566ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1285453582



If  notice the desired result is to have the tables summed up rather then display 10 accounts for the same record, so some custom work was done, otherwise I would of just done that. Also found out its not the custom grid code causing issues, its the formatting of the QueryWhereItems and somehow that isn't working :confused: