Submitted by Joy on 2020/10/25 04:19
I've made a connection to one of my grids from Excel (using an ODC file) - but I can only see parent items in Excel and none of the sub-items - please could you let me know what I need to do to make the sub-items visible?

Comments

Hi Joy,
 
As you can read here 7. Live Links to IQ Grids from Word and Excel, items shown will be those that meet the grid source
[quote]

What items / columns are exported:

  1. Items: The items will be those that match the grid source. Context parents and sub-items cannot be represented inside Word / Excel. The list will be the same as when the grid display settings are:
    • Display mode: Source items (flat list)
    • Context Parent off
       
  2. Columns: The columns (Excel) and fields (Word) visible through the ODC connection will be the ones in your grid when you create the ODC file. If you change the column set, simple regenerate the ODC file.
[/quote]
 
HTH !
 
Pierre_Admin
IQ Designer
 

Joy

2020/10/27 02:59

Permalink

That's great - hadn't spotted that in the documentation - thanks Pierre.