Does Epicor really expect people to be able to do this that are not developers?
Jose C Gomez
T: 904.469.1524 mobile
Maybe they just expect the people using Crystal to keep using crystal for now and they will release reporting as an enhancement lol?
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905700B2-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of Jose Gomez
Sent: Tuesday, May 6, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
Jose C Gomez
Software Engineer
T:
904.469.1524 mobile
Quis custodiet ipsos custodes?
E10 reports will be SSRS (Sequel Server Reporting Services) and not Crystal Reports. Your Crystal Reports will transfer over, but changes will not be able to be done using Crystal Reports – the Epicor presenter stated that we will have run time only for Crystal.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of Scott A. Litzau
Sent: Tuesday, May 06, 2014 8:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 SSRS...
Can you explain what you mean by “E10 SSRS Conceptâ€.
Thanks,
Scott
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3…etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Save the rdl file and upload it back to the Report Server
     ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:Â<div> <p></p><div><p class="ygrps-yiv-700959923MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">Can you explain what you mean by “</span><span>E10 SSRS Conceptâ€. <u></u><u></u></span></p><p class="ygrps-yiv-700959923MsoNormal"><span><u></u> <u></u></span></p>Thanks,
Â
Scott
Â
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS…Â
Â
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks…
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Â
Unbelievable!
Jose C GomezSoftware Engineer
T: 904.469.1524 mobileE: jose@...
http://www.josecgomez.com
Â
Â
Â
Â
Â
Â
Quis custodiet ipsos custodes?</div> <div style="color:#fff;min-height:0;"></div>
That looks painfully familiar. When I implemented Dynamics CRM I came to hate SSRS with a passion.  At least with Vantage/Epicor and ODBC you can still use external Crystal Reports – unlike Dynamics CRM. For runtime we used the Logicity Viewer from SabreLogic (free version with adware) and added to favorites bar to run within Vantage. Most other Crystal Reports were scheduled within CRD. SSRS is  far too cumbersome and time consuming – IMHO.
-Todd C.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 9:08 AM
To: Vantage
Subject: Re: [Vantage] E10 SSRS...
in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step
Modify Report Data Definition (Same as before)
Copy the Original Report in the SSRS Portal
Open the SSRS Report
Find the Data Set you want to modify
Modify the Expression (the expression looks as shown below)
Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it does
is add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3...etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)
Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data type
Save the rdl file and upload it back to the Report Server
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.Plant
FROM InvcHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
LEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5
ON T1.RptLanguageID = T5.RptLanguageID"
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:
Can you explain what you mean by “E10 SSRS Conceptâ€.
Thanks,
Scott
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
The customers must have wanted this according to the review about E10 from earlier today.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of Scott A. Litzau
Sent: Tuesday, May 06, 2014 9:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 SSRS...
I agree, this is way more cumbersome than Crystal.
Thanks for the info Jose
Scott
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of Todd Caughey
Sent: Tuesday, May 06, 2014 10:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 SSRS...
That looks painfully familiar. When I implemented Dynamics CRM I came to hate SSRS with a passion. At least with Vantage/Epicor and ODBC you can still use external Crystal Reports – unlike Dynamics CRM. For runtime we used the Logicity Viewer from SabreLogic (free version with adware) and added to favorites bar to run within Vantage. Most other Crystal Reports were scheduled within CRD. SSRS is far too cumbersome and time consuming – IMHO.
-Todd C.
From:
vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 9:08 AM
To: Vantage
Subject: Re: [Vantage] E10 SSRS...
in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step
Modify Report Data Definition (Same as before)
Copy the Original Report in the SSRS Portal
Open the SSRS Report
Find the Data Set you want to modify
Modify the Expression (the expression looks as shown below)
Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it does
is add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3...etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)
Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data type
Save the rdl file and upload it back to the Report Server
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.Plant
FROM InvcHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
LEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5
ON T1.RptLanguageID = T5.RptLanguageID"
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:
Can you explain what you mean by “E10 SSRS Conceptâ€.
Thanks,
Scott
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
On Tue, May 6, 2014 at 2:16 PM, Calvin Dekker <calvind@...> wrote:Â<div> <p>Jose –
Query the system task history to get the TableGUID.
Use the TableGUID with the RDL to modify the SSRS report. As easy as the Crystal Report xml files.
If you’re really adventurous, convert the SSRS reports to sprocs and you’ll be much happier in the long run.
Thank you in advance,
Calvin Dekker
[cid:image006.jpg@01CF692D.53153FA0]<http://www.codabears.com/>
630-672-7688 x1484
[cid:image002.png@01CF692D.53100F80] <https://www.facebook.com/CodaBearsInc> [cid:image003.png@01CF692D.53100F80] <http://www.linkedin.com/company/codabears-inc> [cid:image004.png@01CF692D.53100F80] <https://twitter.com/CodaBearsInc> [cid:image005.png@01CF692D.53100F80] <http://google.com/+CodaBearsIncRoselle>
Sent: Tuesday, May 6, 2014 8:46 AMTo: Vantage
Subject: [Vantage] E10 SSRS...
E: jose@...<mailto:jose@...>
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks…
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute…
Unbelievable!
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
http://www.josecgomez.com
[http://www.josecgomez.com/images/linkedin.png]<http://www.linkedin.com/in/josecgomez> [http://www.josecgomez.com/images/facebook.png] <http://www.facebook.com/josegomez> [http://www.josecgomez.com/images/google.png] <http://www.google.com/profiles/jose.gomez> [http://www.josecgomez.com/images/twitter.png] <http://www.twitter.com/joc85> [http://www.josecgomez.com/images/wp.png] <http://www.josecgomez.com/professional-resume/> [http://www.josecgomez.com/images/rss.png] <http://www.josecgomez.com/feed/>
Quis custodiet ipsos custodes?
[Non-text portions of this message have been removed]
</div> <div style="color:#fff;min-height:0;"></div>
On May 6, 2014, at 10:07 AM, Jose Gomez <jose@...> wrote:
<div id="ygrps-yiv-452013222ygrp-text"> <p></p><div dir="ltr"><div class="ygrps-yiv-452013222gmail_default" style="font-family:verdana, sans-serif;font-size:small;">in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step</div>Modify Report Data Definition (Same as before)Copy the Original Report in the SSRS PortalOpen the SSRS ReportFind the Data Set you want to modifyModify the Expression (the expression looks as shown below)Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it doesis add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3…etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data typeSave the rdl file and upload it back to the Report Server
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.PlantFROM InvcHead_" + Parameters!TableGuid.Value + " T1LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNumLEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNumLEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5ON T1.RptLanguageID = T5.RptLanguageID"
Jose C GomezSoftware Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:<div> <p></p><div><p class="ygrps-yiv-452013222MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">Can you explain what you mean by “</span><span>E10 SSRS Conceptâ€. <u></u><u></u></span></p><p class="ygrps-yiv-452013222MsoNormal"><span><u></u> <u></u></span></p>Thanks,
Scott
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS…
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks…
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
</div> <div style="color:#fff;min-height:0;"></div>
</div>
Or…
Pardon going all conspiracy theory…
Maybe a way for Epicor to generate more consulting revenue.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Tuesday, May 06, 2014 6:56 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E10 SSRS...
One step forward, three steps back.....
Sent from my iPad
On May 6, 2014, at 10:07 AM, Jose Gomez <jose@...> wrote:
in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step
Modify Report Data Definition (Same as before)
Copy the Original Report in the SSRS Portal
Open the SSRS Report
Find the Data Set you want to modify
Modify the Expression (the expression looks as shown below)
Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it does
is add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3...etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)
Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data type
Save the rdl file and upload it back to the Report Server
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.Plant
FROM InvcHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
LEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5
ON T1.RptLanguageID = T5.RptLanguageID"
Jose C GomezSoftware Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:
Can you explain what you mean by “E10 SSRS Conceptâ€.
Thanks,
Scott
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
The “theory†I had heard was Epicor just does not like feeding revenue to SAP for the runtime licensing built in to the system cost.  Maybe feedback from the sales side competing against SAP. There’s plenty of ways to roll your own Crystal reports and keep using it with E10.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Tuesday, May 06, 2014 7:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 SSRS...
Or…
Pardon going all conspiracy theory…
Maybe a way for Epicor to generate more consulting revenue.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Tuesday, May 06, 2014 6:56 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E10 SSRS...
One step forward, three steps back.....
Sent from my iPad
On May 6, 2014, at 10:07 AM, Jose Gomez <jose@...> wrote:
in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step
Modify Report Data Definition (Same as before)
Copy the Original Report in the SSRS Portal
Open the SSRS Report
Find the Data Set you want to modify
Modify the Expression (the expression looks as shown below)
Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it does
is add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3...etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)
Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data type
Save the rdl file and upload it back to the Report Server
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.Plant
FROM InvcHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
LEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5
ON T1.RptLanguageID = T5.RptLanguageID"
Jose C GomezSoftware Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:
Can you explain what you mean by “E10 SSRS Conceptâ€.
Thanks,
Scott
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
Todd, that's what I was candidly told. Plus SAP hasn't done much with CR since buying it. I still prefer CR over SSRS any day.  For those of you looking for another alternative, I use ASPRunner Pro and make awesome web-based dashboards/reports. It's a slick and cheap product. http://www.xlinesoft.com/asprunnerpro
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Todd Caughey
Sent: Tuesday, May 06, 2014 9:30 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 SSRS...
The “theory†I had heard was Epicor just does not like feeding revenue to SAP for the runtime licensing built in to the system cost. Maybe feedback from the sales side competing against SAP. There’s plenty of ways to roll your own Crystal reports and keep using it with E10.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Tuesday, May 06, 2014 7:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 SSRS...
Or…
Pardon going all conspiracy theory…
Maybe a way for Epicor to generate more consulting revenue.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Tuesday, May 06, 2014 6:56 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E10 SSRS...
One step forward, three steps back.....
Sent from my iPad
On May 6, 2014, at 10:07 AM, Jose Gomez <jose@...> wrote:
in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step
Modify Report Data Definition (Same as before)
Copy the Original Report in the SSRS Portal
Open the SSRS Report
Find the Data Set you want to modify
Modify the Expression (the expression looks as shown below)
Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it does
is add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3...etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)
Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data type
Save the rdl file and upload it back to the Report Server
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.Plant
FROM InvcHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
LEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5
ON T1.RptLanguageID = T5.RptLanguageID"
Jose C GomezSoftware Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@...> wrote:
Can you explain what you mean by “E10 SSRS Conceptâ€.
Thanks,
Scott
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS...
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks...
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute....
Unbelievable!
On Wed, May 7, 2014 at 9:14 AM, <mitchelljohn@...> wrote:Â<div> <p></p><div>I didn't think E10 had any change in reporting. This means that the XML generation would be the exact same as E9 and would allow you to use either Crystal or SSRS. You will have to modify reports because of the DB schema changes from E9 to E10 but it won't be a complete rewrite.</div>John</div> <div style="color:#fff;min-height:0;"></div>
On Wed, May 7, 2014 at 9:08 AM, Winter, Patrick <pjw@...> wrote:Â<div> <p></p><div><p class="ygrps-yiv-1319855305MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">Just to clarify what I’m hearing your losing me, when I move from 9.05.702 to E10:<u></u><u></u></span></p><p class="ygrps-yiv-1319855305MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">Canned reports in E10? <u></u><u></u></span></p>               No xml to Crystal.
               Will now be in SSRS and have to be re customized.
Canned forms (packing slip, job traveler, etc..) in E10?
               No xml to Crystal.
               Will now be in SSRS and have to be re customized.
All my added BAQ reports to XML into Crystal or BAQs to Dashboards should convert?
How about a BAQ to a Dashboard with a Crystal report imbedded?
I thought I heard we could still use BAQ’s to Crystal?
Â
Patrick
Â
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Tuesday, May 06, 2014 17:56
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E10 SSRS…Â
Â
One step forward, three steps back.....
Sent from my iPad
On May 6, 2014, at 10:07 AM, Jose Gomez <jose@...> wrote:Â
in E10 Reporting moved to SSRS by default, they also moved away from XML and into SQL Temporary Tables, the way you modify reports now is extremely cumbersome for non developers. Here is brief step by step
Â
Modify Report Data Definition (Same as before)
Copy the Original Report in the SSRS Portal
Open the SSRS Report
Find the Data Set you want to modify
Modify the Expression (the expression looks as shown below)
Note: this is within the Report itself, for example if in the RDD you added a field call it Field X, you have to modify the below expression to now include that field because modifying the RDD all it does
is add the field to the temporary table that Epicor Generates but it doesn't actually add said field to your report.
So to add field X to the InvoiceDtl table you have to parse through the below expression and find out which table T1, T2, T3...etc is InvcDtl then add that to the select statement. In this case InvcDtl is T2 so I have to add ,T2.X to my select statement.
Â
Then within the Data Set I have to manually add the field to the report (DataSet, Fields, Add Query Field)
Then I have to Download the RDL file , Open it with notepad, find my new field and modify the data type
Save the rdl file and upload it back to the Report Server
Â
Â
Â
="SELECT T1.RptLanguageID,T1.Company,T1.CreditMemo,T1.CustNum,T1.DocDepositCredit,T1.DocInvoiceAmt,T1.DocRounding,T1.DocumentPrinted,T1.InvoiceComment,T1.InvoiceDate,T1.InvoiceNum,T1.InvoiceType,T1.LegalNumber,T1.PONum,T1.SoldToInvoiceAddress,T1.Calc_BillToAddressList,T1.Calc_BottomAddress,T1.Calc_CompanyAddressList,T1.Calc_CurrDocDesc,T1.Calc_CurSymbol,T1.Calc_CustContactName,T1.Calc_CustPartOpts,T1.Calc_DteOrdrd,T1.Calc_fFOB,T1.Calc_MulPackNum,T1.Calc_mulponum,T1.Calc_MulShipDate,T1.Calc_MulShipTo,T1.Calc_MulShipVia,T1.Calc_MultSoldTo,T1.Calc_MultTaxID,T1.Calc_NumRecordPerPage,T1.Calc_NumTotalParts,T1.Calc_PackNum,T1.Calc_PrintBottomAddress,T1.Calc_SalesPerson,T1.Calc_SalesTerms,T1.Calc_ShipDate,T1.Calc_ShipToAddressList,T1.Calc_ShipToContactName,T1.Calc_ShipVia,T1.[Calc_Voucher-String] as Calc_Voucher_String,T1.CurrencyCode_CurrencyID,T1.CurrencyCode_DecimalsGeneral,T1.Calc_SEBankRef,T1.Calc_CustResaleID,T1.BranchID,T1.CustAgentTaxRegNo,T1.CHISRCodeLine,T1.Calc_CHBankAcctIBANCode,T1.Calc_CHBankAcctISRPartyID, T2.AdvanceBillCredit,T2.Company as InvcDtl_Company,T2.DocAdvanceBillCredit,T2.DocDiscount,T2.DocUnitPrice,T2.InvoiceComment as InvcDtl_InvoiceComment,T2.InvoiceLine,T2.InvoiceNum as InvcDtl_InvoiceNum,T2.PackLine,T2.PackNum,T2.PartNum,T2.POLine,T2.PricePerCode,T2.RevisionNum,T2.SalesUM,T2.SellingOrderQty,T2.SellingShipQty,T2.ShipDate,T2.XPartNum,T2.XRevisionNum,T2.Calc_ActDate,T2.Calc_BackOrdQty,T2.Calc_UnitPrice,T2.Calc_ExtPrice,T2.Calc_Duration,T2.Calc_GetNextLegalNum,T2.Calc_InvcComment,T2.Calc_InvoiceDisplayLine,T2.Calc_IsKitParent,T2.Calc_JobNumber,T2.Calc_LabDur,T2.Calc_LabMod,T2.Calc_Labor,T2.Calc_LineDesc,T2.Calc_LineSoldToAddressList,T2.Calc_MatDur,T2.Calc_Mate,T2.Calc_MatMod,T2.Calc_Misc,T2.Calc_MiscDur,T2.Calc_MiscMod,T2.Calc_Modifier,T2.Calc_NextLegalNumID,T2.Calc_NumLineByInv,T2.Calc_ponum,T2.Calc_PSLegalNum,T2.Calc_Reference,T2.Calc_SerialNumber,T2.Calc_ShipToAddressList as InvcDtl_Calc_ShipToAddressList,T2.Calc_ShipToContactName as InvcDtl_Calc_ShipToContactName,T2.Calc_ShipToShipVia,T2.Calc_StateTaxID,T2.Calc_WarrDesc,T2.Calc_WhseCode,T2.OrderLine_DisplaySeq,T2.OrderLine_KitFlag,T2.OrderLine_KitPrintCompsInv,T2.OrderLine_KitsLoaded,T2.OrderLine_OrderLine,T2.PartNum_PartDescription, T3.CallComment,T3.CallQty,T3.PartNum as FSCallDt_PartNum,T3.RevisionNum as FSCallDt_RevisionNum,T3.XPartNum as FSCallDt_XPartNum,T3.XRevisionNum as FSCallDt_XRevisionNum,T3.Calc_CProb,T3.Calc_fCallLine,T3.Calc_fCallNum,T3.Calc_InvoiceLine,T3.Calc_InvoiceNum, T4.Calc_InvoiceNum as FSCallMt_Calc_InvoiceNum,T4.Calc_MatNum,T4.Calc_MtPaNum,T4.Calc_MtQty,T4.Calc_MtBillPrice,T4.Calc_MtExtPrice,T4.Calc_MtLinedesc,T4.Calc_MtRevNum,T4.ResReasonCode,T5.RptLanguageID as Label_RptLanguageID,T5.Calc_ActDate  as Label_Calc_ActDate,T5.Calc_CreditMemo as Label_Calc_CreditMemo,T5.Calc_Duration as Label_Calc_Duration,T5.Calc_JobNumber as Label_Calc_JobNumber,T5.Calc_LabDur as Label_Calc_LabDur,T5.Calc_Labor as Label_Calc_Labor,T5.Calc_MatDur as Label_Calc_MatDur,T5.RptLiteralsLMaterial as Label_Calc_Mate,T5.Calc_Misc as Label_Calc_Misc,T5.Calc_MiscDur as Label_Calc_MiscDur,T5.Calc_MtExtPrice as Label_Calc_MtExtPrice,T5.Calc_SerialNumber as Label_Calc_SerialNumber,T5.DepositCredit as Label_DepositCredit,T5.DocUnitPrice as Label_DocUnitPrice,T5.InvoiceLine as Label_InvoiceLine,T5.PONum as Label_PONum,T5.ProbReasonCode as Label_ProbReasonCode,T5.Reference as Label_Reference,T5.RptLiteralsLBckOrd,T5.RptLiteralsLBillTo ,T5.RptLiteralsLComeFrom ,T5.RptLiteralsLContinueInNext ,T5.RptLiteralsLCusPart ,T5.RptLiteralsLDate ,T5.RptLiteralsLEMaila ,T5.RptLiteralsLExtPrice ,T5.RptLiteralsLFax ,T5.RptLiteralsLFOB ,T5.RptLiteralsLHdng ,T5.RptLiteralsLInvoice ,T5.RptLiteralsLLegNum ,T5.RptLiteralsLLine ,T5.RptLiteralsLLineRef ,T5.RptLiteralsLof ,T5.RptLiteralsLOurPart ,T5.RptLiteralsLPackSlp ,T5.RptLiteralsLPage ,T5.RptLiteralsLPartDesc ,T5.RptLiteralsLPartRev  ,T5.RptLiteralsLPhone ,T5.RptLiteralsLPONum ,T5.RptLiteralsLQty ,T5.RptLiteralsLQtyOrd ,T5.RptLiteralsLRev ,T5.RptLiteralsLRounding ,T5.RptLiteralsLSalesKit ,T5.RptLiteralsLSeeBelow ,T5.RptLiteralsLShipTo ,T5.RptLiteralsLShpVia ,T5.RptLiteralsLSlsTxID ,T5.RptLiteralsLSoldToL ,T5.RptLiteralsLTotal ,T5.RptLiteralsLWarrantyA ,T5.RptLiteralsLWHCode ,T5.ShipDate as Label_ShipDate,T5.UnitPrice as Label_UnitPrice,T5.RptLiteralsLAUHdng ,T5.RptLiteralsLAUTxID ,T5.RptLiteralsLSEOCR ,T5.RptLiteralsLTHServiceTax ,T5.RptLiteralsLTHCopy ,T5.RptLiteralsLNOKID ,T5.RptLiteralsLDiscountPercent ,T5.RptLiteralsLVatNr ,T5.RptLiteralsLTHBranch ,T5.RptLiteralsLTHBranchID ,T5.RptLiteralsLTHHeadOffice ,T5.RptLiteralsLTHTaxPayerNo, T5.RptLiteralsLlessAdvBill,T1.Plant
     FROM InvcHead_" + Parameters!TableGuid.Value + " T1
     LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
     ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
     LEFT OUTER JOIN FSCallDt_" + Parameters!TableGuid.Value + " T3
     ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
     LEFT OUTER JOIN FSCallMt_" + Parameters!TableGuid.Value + " T4
     ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
     LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T5
     ON T1.RptLanguageID = T5.RptLanguageID"
Â
Â
Â
Jose C GomezSoftware Engineer
T: 904.469.1524 mobileE: jose@...
http://www.josecgomez.com
Quis custodiet ipsos custodes?
Â
On Tue, May 6, 2014 at 9:59 AM, Scott A. Litzau <salitzau@…> wrote:
Â
Can you explain what you mean by “E10 SSRS Conceptâ€.
Â
Thanks,
Â
Scott
Â
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, May 06, 2014 8:46 AM
To: Vantage
Subject: [Vantage] E10 SSRS…Â
Â
So I just got all but laughed out of the room when I introduced the new E10 SSRS Concept to a few folks…
Does Epicor really expect people to be able to do this that are not developers?
They did a great Job with 10 but someone forgot about reporting and threw it together at the last minute…
Â
Unbelievable!
Jose C GomezSoftware Engineer
T: 904.469.1524 mobileE: jose@...
http://www.josecgomez.com
Quis custodiet ipsos custodes?Â
</div> <div style="color:#fff;min-height:0;"></div>
