0

NL Picture and "IF" function

Jet Reports Historic Posts

July 14, 2014 09:23

None

Follow

Hi everbody,

first of all please excuse my simple english….

is it possible to combine the Excel IF-Function with "NL (Picture")?

In cell G5 I have this funktion: =if($F5="ALB";NL("Bild";;"\\filesrv2\daten\bilder\ge\GE_Logo_NOK.bmp";"Breite=";200;"Höhe=";10);"").

So far, so good. In Design mode G5 gives me "Picture" as value. When I run the report, G5 is empty (please see attachment).

Best regards
C_hris

• nl_pic.JPG

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 14, 2014 10:48 Official comment

  Hi Chris,
  pls check this discussion
  http://community.jetreports.com/viewtopic.php?f=7&t=3091&p=9363&hilit=picture#p9363
  
  Hallo Chris,
  schau mal in den Link..eine ähnliche Diskussion gab es schon mal mit einer Macro-Lösung….
  
  regards/MfG
  
  jetsetter

• 0
  
  Jet Reports Historic Posts July 14, 2014 13:08

  Hi Chris,
  pls check this discussion
  http://community.jetreports.com/viewtopic.php?f=7&t=3091&p=9363&hilit=picture#p9363
  
  Hallo Chris,
  schau mal in den Link..eine ähnliche Diskussion gab es schon mal mit einer Macro-Lösung….
  
  regards/MfG
  
  jetsetter

  
  Thanks a lot.
  Vielen Dank, das hilft mir schon weiter.
  
  C_hris