Showing images instead of labels in reports
I have a summary report where I am listing position by banner. How do I show certain jpg images (logo of business) to replace labels in this report? I do have a separate table where I store my imag...
Forum Discussion
Not tested, but. but try this as a formula text field with HTML enabled (checkbox)
// first determine which logo to use. We need to calculate the Record ID number where to logo is stored.
Replace the 1, 2, 3, etc with the correct Record ID numbers.
Var text LogoRecordIDNumber = ToText(Case([Banner],
"BWS",1,
"Dan Murphy's",2,
"Metro",3,
"Woolworths",4,
"Woolworths Petrol",5,
"Countdown",6,
"Big W",7,
"Masters",8,
"FreshChoice",9,
"Thomas Dux",10,
"Online",11,
"Super Value",12));
//I'm not sure off hand if the single apostrophe will work OK for Dan Murphy's
"![]()
Replace the 13 with the field ID number of the file Attachment field.
Play with height to get the logo size you like.
// first determine which logo to use. We need to calculate the Record ID number where to logo is stored.
Replace the 1, 2, 3, etc with the correct Record ID numbers.
Var text LogoRecordIDNumber = ToText(Case([Banner],
"BWS",1,
"Dan Murphy's",2,
"Metro",3,
"Woolworths",4,
"Woolworths Petrol",5,
"Countdown",6,
"Big W",7,
"Masters",8,
"FreshChoice",9,
"Thomas Dux",10,
"Online",11,
"Super Value",12));
//I'm not sure off hand if the single apostrophe will work OK for Dan Murphy's
"
Replace the 13 with the field ID number of the file Attachment field.
Play with height to get the logo size you like.