//line below is the link SalesQuotationTable && custQuotationJour
SalesQuotationTable = custQuotationJour.salesQuotationTable();
salesQuotationTmp.TCC_totalDiscount = SalesQuotationTableloc.TCC_TotalDiscount;
//if image is there
if(SalesQuotationTable.PrintImage == NoYes::Yes) //customized field
{
ProductImage = Inventtable::find(salesQuotationTmp.ItemId).RecId;
ProductImage1 = docuRef::find(custQuotationTrans.dataAreaId,ProductImage).RecId;
select ecoResProductImage
where (ecoResProductImage.RefRecId == ProductImage
|| ecoResProductImage.RefRecord == ProductImage)
&& ecoResProductImage.DefaultImage == NoYes::Yes ;
salesQuotationTmp.ItemImageLogo = ecoResProductImage.MediumSize;
}
above code can be used to get image stored in ecoResProductImage for the item to your temp table in the SSRS report.
No comments:
Post a Comment