0

nl("Picture")

Jet Reports Historic Posts

March 14, 2012 12:47

None

Follow

How do I conditional load a picture. Seems everything I try works in design mode but not Report. I need the "nl" syntax for conditional load picture.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts March 27, 2012 05:31

  Hi Tim,
  
  I did a bit of testing and believe that I have something that will work. This is the function that tested fine on my machine:
  
  =NL("Picture","Item","Picture","No.",IF(B2="A",C2,"@@"))
  
  In this scenario, cell B2 was the condition to test for (so in this case it will return the picture if the value in cell B2 is "A").
  
  Cell C2 contains the item number that I want to display the picture for.
  
  Essentially we are telling it to return the picture where the item number is blank if our condition is not met.
  
  Wrapping the IF() around the NL("Picture") function won't work so it is necessary to place the IF() inside the NL() function itself.
  
  I hope that this helps!

• 0
  
  Jet Reports Historic Posts March 27, 2012 08:26

  Hi Brian,
  
  That didn't work. I guess I should have mentioned that my pictures is a file and not in the database. Here is the statement I am trying to make conditional.
  
  =NL("Picture",,C35,"WIDTH=",$F$18,"HEIGHT=",$F$19)
  
  "C35" Has the file name of the picture (""c:\my pictures\901.jpg")