Multiple BOLB fields shown in one report

byebye

Hi,

Do anyone has idea that if I want to display the specific BLOB fields (Picture) in one report field? For example I create 3 BLOB field to import 3 different pictures in Customer card. Then I put a option string in Sales Header which if user select option 1 then want to display 1st BLOB picture; if user select option 2 then display 2nd BLOB picture.

I try set a variable and use 'CASE...IF' statement but I found that variable cannot direct assign to BLOB field so is there any way?

Thanks!

einsTeIn.NET

Some code snippets of your first trials are appreciated.
It should look like

CASE SalesHdr.OptionField OF
  SalesHdr.OptionField::"Option 1":
    Customer.CALCFIELDS("BLOB 1");
  ...
END;

But I don't know what exactly you want to do.

byebye

Thanks for your help which I also thinking on this direction but I am still remain 1 issue is that in report section when I display a field which value of 'Sourcexpression' I get which in this case I cannot directly get from the picture field so is it necessary to get from a variable? If using variable however variable cannot assign to a BLOB field.....

ufuk

Easiest way is creating 3 sections and using showoutput

Sunset

Have a look at how the picture is handled in report 206. That should give you an idea on how you can control placement

CASE SalesSetup."Logo Position on Documents" OF
  SalesSetup."Logo Position on Documents"::"No Logo":;
  SalesSetup."Logo Position on Documents"::Left:
    BEGIN
      CompanyInfo.CALCFIELDS(Picture);
    END;
  SalesSetup."Logo Position on Documents"::Center:
    BEGIN
      CompanyInfo1.GET;
      CompanyInfo1.CALCFIELDS(Picture);
    END;
  SalesSetup."Logo Position on Documents"::Right:
    BEGIN
      CompanyInfo2.GET;
      CompanyInfo2.CALCFIELDS(Picture);
    END;
END;

byebye

Thanks for your help which I will try to test!