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 images.
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. - Many thanks. So assuming this check box sits in the logos table and when linking to these records from my stores table, I understand I will need a web reference of each record? Is that right.
- I'm not sure what you mean by a checkbox. Also, I'm not sure what you mean by "a web reference".
You said in your post that you had a table of logos.
My solution will work in a table report. I have not ever used a logo image in a summary report, for the row or columns, but it should work. - Thanks. Will leave it for you to find a resolution otherwise.
- I did a test and logos will work fine in a summary report for the row and column headings.
- Why not store the company image on the company table?
