Error: Subreport could not be shown After Adding Field in RDD/SSRS

Kinetic ERP
,
1

I am trying to add the PORel.PromiseDT field to the POForm report. I can add it into the RDD without erroring, but get the title error if I add it to the POForm_PORelPart.rdl using T3.PromiseDt as the field. Anyone got any ideas why I cant seem to add any fields to the subreport without breaking it?

2

Dylan, what is the query in your subreport? Paste it here.

Next, what is your report data definition and did you add a table and a relationship, or did you just add/unexclude a field? (paste screenshot of report dataset changes)

1 Like
3

SubReport Query:

<?xml version="1.0" encoding="utf-8"?> 7.67271in 0.22955in true Lbl_LShRelReq =Fields!RptLiteralsLShRelReq.Value Arial Unicode MS 9pt Bold Left 0.03246cm 0.2in 2.63222in None true None 0.21389in Lbl_DueDt =Fields!RptLiteralsLDueDt.Value Arial Unicode MS 9pt Bold Underline Right 0.03246cm 2.64611in 0.2in 0.79351in None Lbl_Qty =Fields!RptLiteralsLQty.Value Arial Unicode MS 9pt Bold Underline Right 0.03246cm 3.45351in 0.2in 0.87198in 1 None Lbl_JobNum =Microsoft.VisualBasic.Interaction.iif(Not Microsoft.VisualBasic.Information.Isnothing(Fields!JobNum.Value), Fields!RptLiteralsLJobNum.Value, "") Arial Unicode MS 9pt Bold Underline Right 5.56335in 0.2in 0.9125in 2 =Fields!AssemblyCount.Value < 1 None Lbl_MslshS =Fields!RptLiteralsLMslshS.Value Arial Unicode MS 9pt Bold Underline Center 6.48973in 0.2in 0.33in 3 =Fields!AssemblyCount.Value < 1 None Lbl_AssemblySeq =Fields!RptLiteralsLAsm.Value Arial Unicode MS 9pt Bold Underline Right 6.83362in 0.2in 0.4in 4 =Fields!AssemblyCount.Value < 1 None Lbl_Seq =Fields!RptLiteralsLSeq.Value Arial Unicode MS 9pt Bold Underline Right 7.24751in 0.2in 0.4in 5 =Fields!AssemblyCount.Value < 1 None Lbl_Tax =Fields!RptLiteralsLTax.Value Arial Unicode MS 9pt Bold Underline Right 0.03528cm 4.73418in 0.2in 0.81528in 6 None Lbl_PORel =Fields!RptLiteralsLRel.Value Arial Unicode MS 9pt Bold Underline Right 0.03246cm 1.69793in 0.2in 0.79351in 7 None true None 0.21338in Lbl_OrderRelNumShipto =Fields!RptLiteralsOrderRelNum.Value +chr(160)+ Fields!RptLiteralsLShipTo.Value Arial Unicode MS 9pt Bold Right 0.17in 0.97083in =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None true Calc_ShipToConName =Fields!Calc_ShipToConName.Value Arial Unicode MS 9pt Left 0.98472in 0.17in 1.34278in 1 None Lbl_Closed =iif(Fields!PrintAs.Value = "C" and Fields!OpenRelease.Value = false, Fields!RptLiteralsLClosed.Value,"") Italic Arial Unicode MS 9pt Bold Right 2.34139in 0.17in 0.44389in 2 None true true txtSpacer 0.181in 0in 0.97083in 3 None 2pt 2pt 2pt 2pt true None 0.19649in DueDate... =Microsoft.VisualBasic.Interaction.iif(Microsoft.VisualBasic.Information.isnothing(Fields!DueDate.Value), "", Microsoft.VisualBasic.Strings.formatdatetime(Fields!DueDate.Value, Microsoft.VisualBasic.DateFormat.ShortDate)) Arial Unicode MS 9pt Right 2.79917in 0.17in 0.64045in None RelQty =Microsoft.VisualBasic.Strings.format(Fields!RelQty.Value, "#,##0.00") Arial Unicode MS 9pt Right 3.45351in 0.17in 0.87198in 1 None PORel_POLine... =Microsoft.VisualBasic.Interaction.iif(Fields!PORel_POLine.Value = Fields!POLine.Value, Fields!PUM.Value, "") Arial Unicode MS 9pt Left 4.33938in 0.17in 0.3948in 2 =Microsoft.VisualBasic.Information.isnothing(Microsoft.VisualBasic.Interaction.iif(Fields!PORel_POLine.Value = Fields!POLine.Value, Fields!PUM.Value, "")) None JobSeq =Microsoft.VisualBasic.Strings.format(Fields!JobSeq.Value, "#,###") Arial Unicode MS 9pt Right 7.24751in 0.17in 0.4in 3 None JobSeqType =Fields!JobSeqType.Value Arial Unicode MS 9pt Center 6.48973in 0.17in 0.33in 4 None AssemblyCount... =Microsoft.VisualBasic.Interaction.iif(Fields!AssemblyCount.Value < 1, Microsoft.VisualBasic.Strings.format(Fields!AssemblySeq.Value, "#,###"), Microsoft.VisualBasic.Strings.format(Fields!AssemblySeq.Value, "#,##0")) Arial Unicode MS 9pt Right 6.83362in 0.17in 0.4in 5 None JobNum =Fields!JobNum.Value Arial Unicode MS 9pt Right 5.56335in 0.17in 0.9125in 6 None TaxExempt... =Microsoft.VisualBasic.Interaction.iif(Fields!TaxExempt.Value <> "", Fields!TaxExempt.Value, Microsoft.VisualBasic.Interaction.iif(Fields!Taxable.Value = True, "Yes", "No")) Arial Unicode MS 9pt Right 4.73418in 0.17in 0.81528in 7 None PORelNum =Fields!PORelNum.Value Arial Unicode MS 9pt Right 1.85099in 0.17in 0.64045in 8 None true None 0.21002in Calc_AttrShortDescription =Fields!Calc_AttrShortDescription.Value Arial Unicode MS 9pt Left 0.02944in 3.86in 0.17in 3.7582in None true true =Fields!RptLiteralsLAttributeSet.Value Arial Unicode MS 9pt Bold Right 0.01389in 2.55in 0.19613in 0.92543in 1 None 2pt 2pt 2pt 2pt true =Fields!Calc_TrackByAttribute.Value=False None true 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(0).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(1).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None AssemblyCount =format(Fields!AssemblyCount.Value,"#,##0.00") Arial Unicode MS 9pt Right 0.005in 3.99479in 0.175in 0.01042in 1 true None 2pt true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(2).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(3).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(4).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(5).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(6).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.18in PORel_Calc_ShipToAddrList =split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(7).ToString() Arial Unicode MS 9pt Left 0.98472in 0.18in 2.56167in None true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value = false) None 0.03125in true None =isnothing(Fields!RptLiteralsLShRelReq.Value) and isnothing(Fields!RptLiteralsLDueDt.Value) and isnothing(Fields!RptLiteralsLQty.Value) and isnothing(iif( not (Isnothing(Fields!JobNum.Value)) , Fields!RptLiteralsLJobNum.Value,nothing)) and isnothing(Fields!RptLiteralsLMslshS.Value) and isnothing(Fields!RptLiteralsLAsm.Value) and isnothing(Fields!RptLiteralsLSeq.Value) true End =iif(Fields!Calc_ShipToConName.Value = "" and (Fields!PrintAs.Value = "C" and Fields!OpenRelease.Value = True),True,False) true =IIf(Fields!Calc_AttrShortDescription.Value <> "",False,True) =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(0), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(1), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(2), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(3), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(4), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(5), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(6), " ","")) <= 0,true) true =switch( Fields!Calc_MultiShiptoAddresses.Value = false and Fields!Calc_PlantAddressInRelease.Value = false, Fields!Calc_ExistingDropShipReleases.Value = false, Len(Replace(Split(Fields!PORel_Calc_ShipToAddrList.Value,"~")(7), " ","")) <= 0,true) true =switch( Fields!DropShip.Value=false, Fields!Calc_MultiShiptoAddresses.Value = false, Fields!DropShip.Value=true, Fields!Calc_ExistingDropShipReleases.Value= true) true true POHeader 2.53458in 7.67271in None 2.58459in 7.69905in 0.25in 0.25in 0.16in 0.16in 0 /SaaS1022PilotSSRS_14271/reports/SharedReportDataSource Integrated 7e838f0e-21be-4f85-81ae-f24bc6e2f81d dsPOForm_PORelPart ="SELECT T1.CommentText, T1.Company, T1.FOB, T1.FreightPP, T1.OrderDate, T1.PONum, T1.PrintAs, T1.ShipToConName, T1.ShipViaCode, T1.Calc_AccountRef, T1.Calc_BillToAddrList, T1.Calc_Buyer, T1.Calc_CurDesc, T1.Calc_CurSymb, CAST( T1.Calc_ExistingDropShipReleases as nvarchar ) as Calc_ExistingDropShipReleases, CAST( T1.Calc_MultiShiptoAddresses as nvarchar ) as Calc_MultiShiptoAddresses, T1.Calc_PurTerms, T1.Calc_ShipToAddrList, T1.Calc_PlantAddressInRelease, T2.CommentText as PODetail_CommentText, T2.Company as PODetail_Company,T2.DocUnitCost, T2.MfgPartNum, T2.MfgPartOpts, T2.PartNum, T2.POLine, T2.PONUM as PODetail_PONum, T2.PUM, T2.RevisionNum, T2.SubPartNum, T2.SubPartOpts, T2.SubPartType, T2.VendorPartOpts, T2.VenPartNum, T2.Calc_CostPer, T2.Calc_DtLineDesc, T2.Calc_ExtCost, T2.Calc_TrackByAttribute, T3.AssemblySeq, CAST( T3.DropShip as nvarchar ) as DropShip, T3.DueDate, T3.JobNum, T3.JobSeq, T3.JobSeqType, CAST( T3.OpenRelease as nvarchar ) as OpenRelease, T3.POLine as PORel_POLine, T3.PORelNum, T3.RelQty, T3.Calc_ShiptoAddrList as PORel_Calc_ShipToAddrList, T3.Calc_ShipToConName, T3.Taxable, T3.TaxExempt, T3.Calc_AttrShortDescription, T4.RptLiteralsLAsm, T4.RptLiteralsLDueDt, T4.RptLiteralsLExtPrice, T4.RptLiteralsLLine, T4.RptLiteralsLLineChargeSubtotal, T4.RptLiteralsLMfgPartNumber, T4.RptLiteralsLMslshS, T4.RptLiteralsLOrderDate, T4.RptLiteralsLOrderQty, T4.RptLiteralsLOurPartNumber, T4.RptLiteralsLPg, T4.RptLiteralsLPhone, T4.RptLiteralsLPONum, T4.RptLiteralsLQty, T4.RptLiteralsLShipTo, T4.RptLiteralsLShRelReq, T4.RptLiteralsLClosed, T4.OrderRelNum AS RptLiteralsOrderRelNum, T4.RptLiteralsLJobNum, T4.RptLiteralsLSeq, T4.RptLiteralsLTax, T4.RptLiteralsLAttributeSet, T4.RptLiteralsLRel, T3.PromiseDt FROM POHeader_" + Parameters!TableGuid.Value + " T1 LEFT OUTER JOIN PODetail_" + Parameters!TableGuid.Value + " T2 ON T1.Company = T2.Company AND T1.PONum = T2.PONUM LEFT OUTER JOIN PORel_" + Parameters!TableGuid.Value + " T3 ON T2.Company = T3.Company AND T2.PONUM = T3.PONum AND T2.POLine = T3.POLine LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T4 ON T1.RptLanguageID = T4.RptLanguageID" true CommentText System.String Company System.String FOB System.String FreightPP System.Boolean OrderDate System.DateTime PONum System.Int32 PrintAs System.String ShipToConName System.String ShipViaCode System.String Calc_AccountRef System.String Calc_BillToAddrList System.String Calc_Buyer System.String Calc_CurDesc System.String Calc_CurSymb System.String Calc_ExistingDropShipReleases System.String Calc_MultiShiptoAddresses System.String Calc_PurTerms System.String Calc_ShipToAddrList System.String PODetail_CommentText System.String PODetail_Company System.String DocUnitCost System.Decimal MfgPartNum System.String MfgPartOpts System.String PartNum System.String POLine System.Int32 PODetail_PONum System.Int32 PUM System.String RevisionNum System.String SubPartNum System.String SubPartOpts System.String SubPartType System.String VendorPartOpts System.String VenPartNum System.String Calc_CostPer System.String Calc_DtLineDesc System.String Calc_ExtCost System.Decimal AssemblySeq System.Int32 DropShip System.String DueDate System.DateTime JobNum System.String JobSeq System.Int32 JobSeqType System.String OpenRelease System.String PORel_POLine System.Int32 PORelNum true RelQty System.Decimal PORel_Calc_ShipToAddrList System.String Calc_ShipToConName System.String Taxable System.Boolean TaxExempt true Calc_PlantAddressInRelease System.Boolean RptLiteralsLAsm System.String =iif(Fields!JobSeqType.Value="", 0 ,1) RptLiteralsLDueDt System.String RptLiteralsLExtPrice System.String RptLiteralsLLine System.String RptLiteralsLLineChargeSubtotal System.String RptLiteralsLMfgPartNumber System.String RptLiteralsLMslshS System.String RptLiteralsLOrderDate System.String RptLiteralsLOrderQty System.String RptLiteralsLOurPartNumber System.String RptLiteralsLPg System.String RptLiteralsLPhone System.String RptLiteralsLPONum System.String RptLiteralsLQty System.String RptLiteralsLShipTo System.String RptLiteralsLShRelReq System.String RptLiteralsLClosed System.String RptLiteralsOrderRelNum System.String RptLiteralsLJobNum System.String RptLiteralsLSeq System.String RptLiteralsLTax true RptLiteralsLAttributeSet true Calc_AttrShortDescription true RptLiteralsLRel true Calc_TrackByAttribute true =Fields!PONum.Value Equal =Parameters!Pm_POHeader_PONum.Value =Fields!POLine.Value Equal =Parameters!Pm_PODetail_POLine.Value String TableGuid Integer true PONum Integer true POLine =User!Language Inch 9fb274a9-128e-4236-8ed5-ee269ac234f2

RDD:

image
image720×560 28.4 KB

image
image828×708 31.8 KB

4

do you have teams?

5

It was the formatting of the query. Had a new line in it in the RDL dataset.