I want to display the image in the Report that is in Part.ImageID

Kinetic ERP
1

I want to display the image in the Report that is in Part.ImageID.
I did it but the image is not showing.

="SELECT T1.DueDate,T1.IUM JobHead_IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T1.SysRowID,T1.Batch_c,

T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description] JobAsmbl_Description,T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum JobAsmbl_PartNum,T2.PullQty,T2.RevisionNum,T2.RequiredQty as AS_RequiredQty,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T2.Calc_AttributeSetShortDescription, T3.CommentText,T3.Instructions,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf,T5.Calc_RTUResDesc as ResourceTimeUsed_ResourceDesc,T5.Calc_RTUResGrpDesc as ResourceTimeUsed_ResourceGrpDesc,T6.LotShelfLife,T7.PartNum JobMtl_PartNum,T7.Description 
JobMtl_Description,T7.MtlSeq,T7.IUM JobMtl_IUM,T7.RequiredQty as JobMtl_RequiredQty,T6.ImageID,T9.Content,T9.FileType 


FROM JobHead_" + Parameters!TableGuid.Value + " T1
 LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2
  ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum
 LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3
  ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq
 LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4
  ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq
 LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5
  ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq
 LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T6
  ON T1.Company = T6.Company AND T1.PartNum = T6.PartNum LEFT OUTER JOIN JobMtl_" + Parameters!TableGuid.Value + " T7
  ON T1.Company = T7.Company AND T1.JobNum = T7.JobNum LEFT OUTER JOIN Image_" + Parameters!TableGuid.Value + " T8
  ON T6.Company = T8.Company AND T6.ImageID = T8.ImageID  LEFT OUTER JOIN FileStore_" + Parameters!TableGuid.Value + " T9  ON T8.Company = T9.Company AND T8.ImageSysRowID = T9.SysRowID"

image
image1920×1020 121 KB

image
image839×707 7.32 KB

2

Then why using [Content] field?

3

image
image1283×214 14.9 KB

I’m not sure if I need to use this field.

4

Change your join on FileStore to Image to be on T8.Company = T9.Company AND T8.ImageFileName = T9.FileName. Then add T8.FileType to your select statement (make sure FileStore.FileName and Image.FileType are added to your RDD if not there already).

Then go to into your dataset properties and add your new query field and also add a calculated field. The expression for your calculated field will be: =Convert.ToBase64String(Fields!Content.Value)

Then add your image and in the properties:

The source will be: Database

In ‘Use this field’ chose the calculated field you just created

In MIME type add this expression: =switch(UCASE(Fields!FileType.Value)=“.JPG”,“image/jpeg”,UCASE(Fields!FileType.Value)=“.PNG”,“image/png”,UCASE(Fields!FileType.Value)=“.BMP”,“image/bmp”,UCASE(Fields!FileType.Value)=“.GIF”,“image/gif”,UCASE(Fields!FileType.Value)=“.PNG”,“image/jpng”,UCASE(Fields!FileType.Value)=“.X-PNG”,“image/x-png”)

3 Likes
6

I did it. Thank you very much.