Discussions

Expand all | Collapse all

Showing images instead of labels in reports

  • 1.  Showing images instead of labels in reports

    Silver
    Contributor
    Posted 05-07-2017 23:48
    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.  


  • 2.  RE: Showing images instead of labels in reports

    Posted 05-08-2017 02:01
    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.


  • 3.  RE: Showing images instead of labels in reports

    Silver
    Contributor
    Posted 05-08-2017 02:20
    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.  


  • 4.  RE: Showing images instead of labels in reports

    Posted 05-08-2017 13:28
    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.


  • 5.  RE: Showing images instead of labels in reports

    Silver
    Contributor
    Posted 05-08-2017 21:12
    Thanks. Will leave it for you to find a resolution otherwise. 


  • 6.  RE: Showing images instead of labels in reports

    Posted 05-08-2017 21:52
    I did a test and logos will work fine in a summary report for the row and column headings.


  • 7.  RE: Showing images instead of labels in reports

    Silver
    Contributor
    Posted 05-08-2017 21:54
    Thanks. Just sent you an email and this is one of the issue therein.  


  • 8.  RE: Showing images instead of labels in reports

    Top
    Contributor
    Posted 05-08-2017 04:44
    Why not store the company image on the company table?