XLS Export Nested Grid

Hello,

Does anyone have any idea how to get the xls export option to include records from a nested grid? I have XLS set to YES in the nested grid settings but it does not seem to work. I’m using SC 9.2.008.

Has anyone got this working?

Cheers,

Mike

Hi,

Just in case anyone else encounters this I managed figure out how to make it work…

It seems that you need to have the XML button included on the toolbar of the nested grid. If you don’t include this button then the records do not show up in the generated xls file; if you don’t need this button you can simply hide it by using sc_btn_display(‘xls’, ‘off’) in the onScriptInit event of the nested grid.

It’s a little strange and probably should be documented somewhere, but at least I have it working now.

Regards,

Mike

Ok. Good tip.