Hello Chris,
One way to handle this is with SELECT statements. They can be entered in the Select Table dialog. First click the lower green refresh button in the top Database section, this will load in all available tables from your database.
If you click on a Table Name below, a select statement will be generated that will display all data in this table.
Basic Select Statement:
SELECT * FROM [Tablename$]
Clicking the Advanced radio button at the top will enable the Select Statement textbox entry for editing. This will allow you to enter more advanced select statements.
You will need to replace the red column names and the blue table name below with ones used in your database, then enter this select statement all in one line:
SELECT "ColumnName1", "ColumnName2", "ColumnName3", "ColumnName4", IIf("ColumnNameX" <> '', 'RedCircle.png', 'Black.png') AS Image FROM [Tablename$]
This select statement will create a new column labeled "Image", and check for data in ColumnNameX. If data is available, a RedCircle.png will be set for each row of the Image column. If no data is found, a Black.png will be set for each row of the Image column. You can now click the refresh button at the end of the select statement to see your results in the window below.
You will then need to have an image region that will be linked to the same database that the excel file uses and contain a path to the image, followed by the formatter to complete the path.
If your images were located in C:\Noventri\Database\Images you would use the following format for each image region:
Example:
Image 1 = C:\Noventri\Database\Images\[1:Image]
Image 2 = C:\Noventri\Database\Images\[2:Image]
Image 3 = C:\Noventri\Database\Images\[3:Image]
Image 4 = C:\Noventri\Database\Images\[4:Image]
Once the new select statement is applied, the path will be completed and display the following:
Example:
Image 1 = C:\Noventri\Database\Images\RedCircle.png
Image 2 = C:\Noventri\Database\Images\RedCircle.png
Image 3 = C:\Noventri\Database\Images\Black.png
Image 4 = C:\Noventri\Database\Images\RedCircle.png
Please let me know if you have any questions or if something is not clear for you.
We can also schedule a remote desktop connection if you need any assistance settings this up.
Kind Regards,
Sergey