SSRS Error on Dataset

tmayfield · July 6, 2026, 1:03pm

I modified our OrderAck report, when I moved it up to production I’m getting an error message.

When I look at the SSRS log files it looks like it is failing on the GUID.

Query execution failed for dataset ‘OrderHed’. —> System.Data.SqlClient.SqlException: Invalid object name ‘OrderHed_93f08a9fa1d6460eb8a93c2e89d8a0aa’

dcamlin · July 6, 2026, 1:19pm

What did you change in your custom style/RDD?

You’re showing the relationship between OrderHed and OrderDtl… but that’s a standard relationship in the base RDD.

Can you post your custom RDL query?

tmayfield · July 6, 2026, 1:22pm

="SELECT
T1.RequestDate,
T1.Calc_CustAddrList,
T1.EntryPerson,
T1.Customer_Comment,
T1.Character01,
T2.Calc_LineTaxAmt,
CASE WHEN T7.OrderNum IS NULL THEN 0 ELSE 1 END ExistsLineOrderMsc,
CASE WHEN T8.OrderNum IS NULL THEN 0 ELSE 1 END ExistsOrderMsc,
CASE WHEN T5.OrderNum IS NULL THEN 0 ELSE 1 END ExistsFSContDt,
CASE WHEN T6.OrderNum IS NULL THEN 0 ELSE 1 END ExistsKitComponents,
T2.Calc_POLine,
T4.Calc_CarrierDesc AS RptLiteralsCalc_CarrierDesc,
T1.RptLanguageID,
T1.CardNumber,
T1.NeedByDate,
T1.OrderComment,
T1.OrderDate,
T1.OrderNum,
T1.PONum,
T1.Calc_BillToAddressList,
T1.Calc_BillToContact,
T1.Calc_CardNumber,
T1.Calc_CustPartOpts,
T1.Calc_FobDesc,
T1.Calc_MultiNeedDate,
T1.Calc_MultiRef,
T1.Calc_MultiShipContacts,
T1.Calc_MultiShipTo,
T1.Calc_MultiShipVia,
T1.Calc_PrcEmail,
T1.Calc_PrcFax,
T1.Calc_PrcPhone,
T1.Calc_SalesPerson,
T1.Calc_ShipToAddressList,
T1.Calc_ShipToContact,
T1.Calc_ShipToEmail,
T1.Calc_ShipToFax,
T1.Calc_ShipToPhone,
T1.Calc_ShipViaDesc,
T1.Calc_TermsDesc,
T1.CurrencyCode_CurrDesc,
T1.CurrencyCode_CurrSymbol,
T1.Customer_ResaleID,
T1.Calc_CurrSymbol,
T1.Calc_MiscTotal,
T1.Calc_LineMiscTotal,
T2.Company,
T2.ContractNum,
T2.DisplaySeq,
T2.DocDiscount,
T2.DocUnitPrice,
T2.KitFlag,
T2.KitPricing,
T2.KitPrintCompsInv,
T2.KitShipComplete,
T2.OrderComment AS OrderDtl_OrderComment,
T2.OrderLine,T2.PartNum,
T2.POLine,
T2.PricePerCode,
T2.Reference,
T2.RevisionNum,
T2.SalesUM,
T2.SellingQuantity,
T2.WarrantyComment,
T2.XPartNum,
T2.XRevisionNum,
T2.Calc_ExtPrice,
T2.Calc_LineDesc,
T2.PartNum_PartDescription,
T2.WarrantyCode_WarrDescription,
T2.Calc_UOMForeignDesc,
T3.NeedByDate AS OrderRel_NeedByDate,
T3.OrderRelNum,
T3.Reference AS OrderRel_Reference,
T3.ReqDate,
T3.SellingReqQty,
T3.ShipViaCode,
T3.Calc_ResaleID,
T3.Calc_ShipToAddressList AS OrderRel_Calc_ShipToAddressList,
T3.Calc_ShipToContact AS OrderRel_Calc_ShipToContact,
T3.ShipViaCode_Description,
T3.Calc_OrderRelCounter,
T4.Calc_ExtPrice AS RptLiteralsCalc_ExtPrice,
T4.Calc_OrderTotal AS RptLiteralsCalc_OrderTotal,
T4.Calc_SalesPerson AS RptLiteralsCalc_SalesPerson,
T4.Calc_ShipToContact AS RptLiteralsCalc_ShipToContact,
T4.Discount RptLiteralsDiscount,
T4.FaxNum AS RptLiteralsFaxNum,
T4.FOB AS RptLiteralsFOB,
T4.NeedByDate AS RptLiteralsNeedByDate,
T4.OrderDate AS RptLiteralsOrderDate,
T4.RptLiteralsLLine,
T4.OrderQty AS RptLiteralsOrderQty,
T4.OrderRelNum AS RptLiteralsOrderRelNum,
T4.PhoneNum AS RptLiteralsPhoneNum,
T4.Reference AS RptLiteralsReference,
T4.ResaleID AS RptLiteralsResaleID,
T4.RevisionNum AS RptLiteralsRevisionNum,
T4.RptLiteralsLCrdNum,
T4.RptLiteralsLCustPart,
T4.RptLiteralsLDate,
T4.RptLiteralsLEmail,
T4.RptLiteralsLFax,
T4.RptLiteralsLPhone,
T4.RptLiteralsLLNMSC,
T4.RptLiteralsLOrderAck,
T4.RptLiteralsLORMSC,
T4.RptLiteralsLORNUM,
T4.RptLiteralsLOurPart,
T4.RptLiteralsLPage,
T4.RptLiteralsLPONum,
T4.RptLiteralsLPriPer,
T4.RptLiteralsLPrtDes,
T4.RptLiteralsLQty,
T4.RptLiteralsLShipTo,
T4.RptLiteralsLSHSHC,
T4.RptLiteralsLSHSHM,
T4.RptLiteralsLSLSHE,
T4.RptLiteralsLSoldTo,
T4.RptLiteralsLSubTotal,
T4.RptLiteralsLTerms,
T4.RptLiteralsLYURPOLN,
T4.RptLiteralsSalesKit,
T4.UnitPrice AS RptLiteralsUnitPrice,
T4.Warranty AS RptLiteralsWarranty,
T4.ShipViaCode AS RptLiteralsShipViaCode,
T4.OrderLine AS RptLiteralsOrderLine,
T4.RptLiteralsSeeBelow,
T1.Calc_TaxMethod,
T4.RptLiteralsLTotalTax,
T1.DocTotalTax,
T1.DocOrderAmt,
T1.AddtlShipAddInfo1_c,
T1.AddtlShipAddInfo2_c,
T1.AddtlShipContactName_c,
T1.AddtlShipEmail_c,
T1.AddtlShipPhoneNum_c,
T1.Calc_TotalTaxAmt
FROM OrderHed\_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN OrderDtl\_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.OrderNum = T2.OrderNum
LEFT OUTER JOIN OrderRel\_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.OrderNum = T3.OrderNum AND T2.OrderLine = T3.OrderLine
LEFT OUTER JOIN RptLabels\_" + Parameters!TableGuid.Value + " T4
ON T1.RptLanguageID = T4.RptLanguageID LEFT JOIN (SELECT DISTINCT Company, Calc_OrderNum OrderNum, Calc_OrderLine OrderLine, ContractNum FROM FSContDt\_" + Parameters!TableGuid.Value + ") T5 ON T2.Company = T5.Company
AND T2.OrderNum = T5.OrderNum AND T2.OrderLine = T5.OrderLine AND T2.ContractNum = T5.ContractNum
LEFT JOIN (SELECT DISTINCT OrderNum, KitParentLine FROM OrderDtl\_" + Parameters!TableGuid.Value + " WHERE KitFlag = 'C') T6 ON T6.OrderNum = T1.OrderNum
AND T6.KitParentLine = T2.OrderLine LEFT JOIN (SELECT DISTINCT OrderNum, OrderLine FROM OrderMsc\_" + Parameters!TableGuid.Value + ") T7 ON T2.OrderNum = T7.OrderNum
AND T2.OrderLine = T7.OrderLine LEFT JOIN (SELECT DISTINCT OrderNum FROM OHOrderMsc\_" + Parameters!TableGuid.Value + ") T8 ON T2.OrderNum = T8.OrderNum"

dcamlin · July 6, 2026, 1:30pm

Well, its tough to tell what could be an issue, and what could be an artifact of copy/pasting into the forum.

But first thing that jumps out is the mix of straight and curly quotes, apostrophes.

Are these all “straight” your RDL?

tmayfield · July 6, 2026, 2:09pm

Those should be okay. All I did was add 5 entries into the select. I ended up fixing it by recopying down from production and recreating my ssrs report.

dcamlin · July 6, 2026, 2:24pm

Glad its working… but now I’m wondering what the issue was

tmayfield · July 6, 2026, 2:34pm

Since its a production issue I’m just glad they aren’t yelling anymore…lol

DaveOlender · July 6, 2026, 2:57pm

I have never see the TableName_" +Parameters!. . .

is that some sort of new syntax? I have only used TableName_" + Parameters! . . .

DaveO

DaveOlender · July 6, 2026, 2:58pm

Interesting - my backslashes are not showing.

I am seeing “TableName_” tried putting in quotes

DaveO

tmayfield · July 6, 2026, 4:10pm

Now its barfing on the subtotal report…sigh… it has something cached. back to the drawing board to try and figure this out

tmayfield · July 6, 2026, 4:31pm

Figured out why the SOTotal wasn’t working because it had a different shared connection then the report I was using that why it was failing.

mbilodeau · July 6, 2026, 4:36pm

When adding new stuff to the select statement, I always forget about adding a space character at the end of the line. Welcome to SSRS

Nancy_Hoyt · July 6, 2026, 4:55pm

I was looking at your post and thinking wth did DaveO write that is different from original poster.. the wonders of our programs that fix things for us! (Side note I felt joyful today when copilot in Excel was trying to deal with excel having changed 10-10-10 to a date after it had done a paste to work up a dataset for me)

Nancy