I the visual Studio Report, I added
FULL OUTER JOIN PartPlant_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.Calc_PartNumIndentor = T3.PartNum"
and
SELECT T2.MtlPartNum,T3.VendorNum_Name AS VendorName,T3.Part_TypeCode AS PartTypeCode,T3.LeadTime,T2.PartNum_TypeCode AS TypeCode,
to the dataset PartRevPartMtl.
I created the Query fields to match and added to the report. Not getting the info like I expected.
Thank you for that tip! It showed me that I was only pulling in 1 row of data. I have to change the relationship fields it connected with from PartNum = PartNum to MtlPartNum = PartNum.
It then pulled in all the data I needed.
I really appreciate the time you spent educating me on this. It will definitely help in the future.
You can also get the report GUID from the System Monitor. Do like Ken said, run the report with 1 day archive then go to the Reports tab and scroll all the way to the right. This tip is for those of you who can’t/won’t use SSMS.
I knew where to get the GUID in the monitor, just wasn’t sure where to find the temp tables and their info. Good to know that they are on the SSRS SQL server.